Thursday, September 18, 2014

Error while creating relationship - "Choose the key from allowed namespace"

Scenario
You are trying to enhance standard data model by creating new entity types and creating relationships.

Issue
Error when trying to create a leading relationship for new entity type (SU type-4) on entity type-1 .

Error Screenshot




Solution
Create new relationship by prefixing ZZ i.e., ZZMATMARC1

MDG - Web Workbench for Data Modeling


You can use MDG's Web Workbench to do normal MDG data modeling tasks using below url

http://<host>:<ITS-Port>/sap/bc/webdynpro/sap/wda_mdg_dt_conf_workbench?FROM_TRANS=X&sap-client=800&sap-language=EN#

Tuesday, September 16, 2014

How to know generated tables for MDG Data Model


PurposeKnow details of generated tables for MDG data models.
Report (SE38)USMD_DATA_MODEL

MDG menu not visible on NWBC. Instead, It shows an error “The user menu tree for user is empty."

Issue
MDG menu not visible on NWBC. Instead, It shows an error “The user menu tree for user is empty."

Error Screenshot


Solution
Role is assigned but folder is defined as a "link collection" instead of a "service map" - see:http://goo.gl/OEq9qa

Steps to solution
Step-1: Goto transaction PFCG

Step-2: Open your Role in edit mode. 

Step-3: Goto ‘Menu’ Tab.

Step-4: Double click on the folder in which your views are defined. If no folder defined, then create one and move the views to this folder.

Step-5: Click on ‘Other Node Details’ button

Step-6: Select ‘Folder Option’ as ‘As Service Map'

Step-7: Save & Execute NWBC

Solution Screenshot

References 1378659 - NWBC known issues & what to check when opening a ticket
https://websmp208.sap-ag.de/~sapidb/012003146900001035042013E/empty_user_menu.pdf

Sunday, September 14, 2014

Regular - Security

Role-IdName/Description
SAP_MDG_ADMIN [External] 
 Master Data Governance Administrator

Custom Objects - Security

Role-IdName/Description
SAP_MDGX_MENU_04 [External] 
 For self-defined objects

SAP_MDGX_FND_SAMPLE_SF_04 [External]
 For self-defined objects – Flight Data Model example

Financials - Security

Role-IdName/Description
SAP_MDGF_ACC_DISP_04 
 Accounting Display

SAP_MDGF_ACC_REQ_04 [External]
 Accounting Requester

SAP_MDGF_ACC_SPEC_04 [External]
 Accounting Specialist

SAP_MDGF_ACC_STEW_04 [External]
 Accounting Data Steward

SAP_MDGF_CO_DISP_04 [External]
 Accounting Data Steward

SAP_MDGF_CO_REQ_04 [External]
 Consolidation Requester

SAP_MDGF_CO_SPEC_04 [External]
 Consolidation Specialist

SAP_MDGF_CO_STEW_04 [External]
 Consolidation Data Steward

SAP_MDGF_CTR_DISP_04 [External]
 Controlling Display

SAP_MDGF_CTR_REQ_04 [External]
 Controlling Requester

SAP_MDGF_CTR_SPEC_04 [External]
 Controlling Specialist

SAP_MDGF_CTR_STEW_04 [External]
 Controlling Data Steward

Material - Security

Role-IdName/Description
SAP_MDGM_MENU_04 
 Menu

SAP_MDGM_DISP_04
 Display

SAP_MDGM_REQ_04
 Requester

SAP_MDGM_SPEC_04
 Specialist

SAP_MDGM_STEW_04
 Data Steward

Customer - Security

Role-IdName/Description
SAP_MDGC_MENU_04
 Menu [External]

SAP_MDGC_DISP_04
 Display [External]

SAP_MDGC_REQ_04
 Requester [External]

SAP_MDGC_SPEC_04
 Specialist [External]

SAP_MDGC_STEW_04
 Data Steward [External]

SAP_MDGC_CL_MENU_04
 (ERP Customer UI): Menu[External]

SAP_MDGC_LCC_MENU_04 
 (Lean Request UI): Menu[External]

SAP_MDGC_LCC_REQ_04
 (Lean Request UI):Requester [External]

Supplier - Security

Role-IdName/Description
SAP_MDGS_MENU_04
 Menu [External]

SAP_MDGS_DISP_04
 Display [External]

SAP_MDGS_REQ_04
 Requester [External]

SAP_MDGS_SPEC_04
 Specialist [External]

SAP_MDGS_STEW_04
 Data Steward [External]

SAP_MDGS_VL_MENU_04
 (ERP Vendor UI): Menu[External]

SAP_MDGS_LVC_MENU_04 
 (Lean Request UI): Menu[External]

SAP_MDGS_LVC_REQ_04
 (Lean Request UI):Requester [External]

Business Partner - Security

Role-IdName/Description
SAP_MDGBP_MENU_04 [External] 
 Menu

SAP_MDGBP_DISP_04 [External]
 Display

SAP_MDGBP_REQ_04 [External]
 Requester

SAP_MDGBP_SPEC_04[External]
 Specialist

SAP_MDGBP_STEW_04 [External]
 Data Steward

Transaction Codes - MDG - Quick Reference

#ItemDetail/Comment
1CA-MDG:

General

MDGIMG - Master Data Governance Customizing

DRFOUT - Execute Data Replication

MDGDT - Configuration Workbench

DRFLOG - Analyze Replication Log

USMD_RULE - Validations and Derivations

MDG_TR_DEST - Destination for Transport Methods

MDG_TR_WZ - RFC Connection Wizard

USMD_SSW_RULE - Process Definition of RBWF
2 CA-MDG-DRF:

Data Replication Framework


DRFOUT - Execute Data Replication

DRFLOG - Analyze Replication Log 
3
CA-MDG-DT:

Design Time

MDGDT - Configuration Workbench
4 CA-MDG-AF:

Application Framework
USMD_RULE - Validations and Derivations

MDG_TR_DEST - Destination for Transport Methods

MDG_TR_WZ - RFC Connection Wizard

USMD_SSW_RULE - Process Definition of RBWF

Relationships - Quick Reference

From Entity Type To Entity Type Relationship Type Cardinality Note/Comments

Entity Type -1

Changeable via Change Request ; Generated database tables

Entity Type - 4

Changeable via Other entity type ; Generated database tables
Leading 1:1 1:0 is no more an option, It should be 1:1

Saturday, September 13, 2014

General - Quick Reference

#ItemDetail/Comment
1SPRO Path for Master Data Governance
-> Cross-Application Components -> Process and Tools for Enterprise Applications -> Master Data Governance

2Create Org. and Staffing
TCode - PPOCW