Book 4
Book 4
Book 4
1. Duplicate Records
2. lack of Framework
3. Data Quality
1. Console
2. Data Manager
3. Import Manager
4. Syndicator
MDG 6.1
MDG 7.0
MDG 8.0
MDG 9.0
MDG 9.1
MDG 9.2
Source
SAP ABAP
SAP CRM
Non-SAP
SAP MDM
Source
SAP MDM
SAP ABAP
Non- SAP
Tx. MDGIMG
Tx. DRFIMG
Tx. ESH_COCKPIT
Tx. NWBC
Single Workflow:
REQ
VER
APP
Parallel Workflow:
(Address Verifier)
Basis
Basis
Computer Security
Basis
Basis
Data Model:
Storage Type:
Type 1
1. Referencing
2. Leading
3. Qualifying
4. FK
Reuse Mode
Database table
MDG_BS_MAT_S_<table name>
MDG_BS_MAT_S_<table_name>_UI
MDG_BS_MAT_S_<table_name>_X
MDG_BS_MAT_MAP_2PP
MDG_BS_MAT_MAP_2STA
Genil Model
Process Model:
UI Model:
FPM is a Webdynpro ABAP Application which provides a certain framework for developing a new Webdynpro ABAP applic
a. Guide0G
b. ObjecCustom Object
c. OvervBP/MM/Custom Object/0G
1. Customized Configuration
UI Field Propertities:
1. To maCL_MDG_BS_MAT_FEEDER_FORM_MAT
2. To maCL_MDG_BS_MAT_FEEDER_FORM_MAT
3. To mak
CL_MDG_BS_MAT_FEEDER_FORM_MAT
4. To maCL_MDG_BS_MAT_FEEDER_FORM_MAT
5. To maCL_USMD_CR_GUIBB_GENERAL_DATA
6. To maCL_MDG_BS_MAT_FEEDER_FORM_MAT
7. Deriv CL_USMD_CR_GUIBB_GENERAL_DATA
Adaptation:
Workflow:
Email Notification
Parallel Processing
Enhancement Implementation
BADI Implementation
Class
Methods
Logic
1. To flow the UI field value (Which user enter in CR) to BRF table and Validate it.
Parallel Processing
2. ABAP BADI
Email Notification
2. ABAP BADI
1. To ge CR Status
4. Whom to Send
Hi,
Warm Regards,
MDG Team.
2. ABAP BADI
MDG APIs:
Fuzzylogy Mehodology
1. DataBase Search
2. Key Search
3. Enterprise Search
Tcode: SPRO
Tx. ESH_COCKPIT
Active - Successful
Tx. DBCO
Execute Program : ESH_ADM_SET_TREX_DESTINATION
Step 5: Create Search View
Duplicate Check
Data Replication:
Client - 800 (Source)
Step1: Souce System - client 800 (SEND)
Tx. SM59
https://wiki.scn.sap.com/wiki/display/ABAP/IDoc+Statuses
Multi-Record Processing
Mass Maintenance
1. Export Master Data information from source system into XML/Excel file format. The XML/Excel file will be on Application
2. Copy the XML/Excel file from Application server of source system to Application server of target system.
3. Import Master Data to the target system through Data Import Framework.
Step 1: 1
Step 2: 3
Step 3: 2
Note: 1. Under which directory we need to store the XML file. 2. Need to define the path name.
Step 4: Using Tx. CG3Z to upload a file from the local file system to the application server.
Classification - CLFMAS
https://help.sap.com/viewer/67aa93f9655e4bc88e9541b48b3dcc87/7.31.22/en-US/43d4d0e3df340d87e10000000a1553
https://blogs.sap.com/2018/03/23/how-to-read-write-the-mdg-key-mapping-informations-programmatically-aka-ukms/
https://blogs.sap.com/2018/07/17/key-mapping-in-master-data-management/
MDG Consolidation
SAP FIORI
Case Study:
1. SLA Identification
2. Copy Template
Customer Basic Info, ERP Customer details - Sales Org, Company Code
Vendor Basic Info, ERP Supplier details - Purchase Org, Company Code
UI
Webdynpro
Architecture Overview
(RFC) MDG
1. Data Model
ALE/Idoc, Services
2. Process Model
3. UI Model
PI (Process Integration)
4. Workflow
PI (Process Integration)
5. Data Validation & Derivation
(XML) - (Idoc)
6. Search & Duplicate Check
target
Deployment options
1. MDG as HUB
1. MDG as HUB
RFC MDG
1. Data Model
XML-Idoc (PI)
2. Process Model
ALE/Idoc
3. UI Model
XML-Idoc (PI)
4. Workflow
MDG 7.0
MDG 8.0
Source/MDG
MDG (7.0/8.0/9.0/9.1)
(MDG Business Function)
SAP ABAP (ECC)
MARA/LFA1/KNA1
PP (Persistance Phase)
Active Area
REQ
(Submit)
VER1
(Approve/Reject)
APP
(Approve/Reject)
Final Approver
(Approve/Reject)
Active Area
Type 2 Type 3
Eg: CURR.
MDG_BS_MAT_S_<table_name>_UI
UI field Properties
SMT Mapping
Tx. genil_model_browser
Tx. genil_model_editor
Business Activity
he UI application?
t Type- ZTB1A
b. Rule BADI (Tx. SE18 - USMD_RULE_SERVICE)
xchange Server
has been completed.
k Approved.
This search finds data in a database based on user specific seaBP/0G/Custom Data Model
It can also be used in application such as duplicate Check.
BP/0G/Custom Data Model
TREX_DESTINATION
Security
(Page# 13 to 15)
(Page# 16 to 17)
(Page# 27 to 29)
(Page# 10 to 12)
(Page# 20 to 25)
(Page# 18 to 19)
(Page# 18 to 19)
TREX_DESTINATION
doc)/SOA services
spective client
se 2 systems
/IDoc+Statuses
rce system into XML/Excel file format. The XML/Excel file will be on Application server.
nformation)
4bc88e9541b48b3dcc87/7.31.22/en-US/43d4d0e3df340d87e10000000a1553f7.html
read-write-the-mdg-key-mapping-informations-programmatically-aka-ukms/
pping-in-master-data-management/
Sales Org Company Code
Class/Characteristics Plant
Tx. MM01
1. Data Model
2. Process Model
3. UI Model
4. Workflow
HANA database/oracle
(Idoc) - (XML)
RFC Target
ALE/Idoc ECC
(Inactive Records)
(Active Records)
Staging Area
(Approve/Reject)
https://help.sap.com/viewer/p/SAP_MASTER_DATA_GOVERNANCE
https://help.sap.com/erp_mdg_addon70/helpdata/en/74/facb771972444eae2345e92ec829ee/frameset.htm
https://help.sap.com/viewer/e03fd31a7e094ca99e9296cf6ec80349/MDG90_SP05/en-US/60c8bc19b24f40d4a7a18c0e61
Tx: SU01
Type 4
UoM
Industry Sector
Price Suger%
Density Water%
Color Price
DATA_MODEL
e Data Model
ecific Structure
2355c9dca20ce10000000a44176d/1610%20001/en-US/9baba5519178245de10000000a44176d.html
06/configuring-service-group-in-soamanager/
Supliers
/frameset.htm
8bc19b24f40d4a7a18c0e6109fbe5.html
BP Info
Company Code
Purchase Org
Create Process
Table - A
Field
Data element
domain
REQ
VER
APP
MDG
XML/Excel
Application Server
MDG
ZTEST
Tx. NWBC
Supplier 1
Same
FR01
IT01
NL01
FR01
IT01
NL01
MDG Processes
Create
Change
Block/Unblock
Mark for deletion
Mass Change/Update
Change Request
REQ Submit
VER Approve
APP Approve
(Activation)
Active area
UoM EA (Each)
GUI
Webdynpro
Airline Process:
CARRID
CURR
URL
Short Description
Entity Type
MATERIAL
CLASS
VALUATION
Business Partner
BP ID/BP Group
Search Term
Name
House#/Address
City
Language
Pin
Tax details
Bank Details
ERP Supplier
Company Code
Purchase Org
ZTEST02
Material#
Material Type
Material Group
Industry Sector
UoM
BUS2250
REQ Submit
VER Approve
APP Approve
(Activation)
/MDGMM/_S_MM_PP_MATERIAL
MDG_BS_MAT_S_MARA
Enhancement
BADI
Class
Method
Logic
Sport
Run
Run
Run
Create Master Data
Change Request
Business Activity
UI (User Interface)
Webdynpro Component
(01)
VER2 (12)
(Approve)
(02)
APP (03)
(Approve)
(Activation)
Active Area
Source
XML/Excel
Application Server
Target
YTEST
FIORI (UI5)
Webdynpro Component
X X
Supplier 2
Same
DE01
FR01
DE01
FR01
GUI
Entity/Attribute
Material# 1234
Characteristics
ERP Customer
Company Code
Sales Org
Satgging Table
ZTEST02
1234 3456
AEM AEM
1001 1001
Retail Retail
EA EA
R1 R2
Z1 Z2
stagging table
stagging table
Access Class
PP (Primary Persistance)
Active area
(Attributes)
Material# 1234
UoM Each
B1 B2
Mr. A
Mr. B
Data Model
UI Model
Workflow
Replication
ECC layer
Table - B
Connector Template
Basic Info
Classification
Characteristics
ECC
UoM EA (Each)
SLA
Material
Material Type
Material Group
Industry Sector
UoM
Class ID
Class Type
Class Name
Char ID
Char Name