Initial Migration of Financial Master Data in SAP Master Data Governance HUB

[former_member517519]

Hello MDG Experts,

We are in the process of start implementing the SAP MDG-F solution and for that we need to do initial data migration of historical data present in the client's respective S4/HANA systems to MDG HUB system

Queries:-

1. What would be the best approach in loading data to MDG(G/L account, Cost Center, Cost Center Hierarchy, Profit Center, Profit Center Hierarchy, Cost Element, Cost Element Hierarchy, Company, Company Code etc.)

2. Whether we need to create only one Edition in MDG for initial data load or Can we create multiple Editions(if yes, what precautions we need to Consider)

3. Is there any particular precaution we need to take or point to need to consider while doing Initial data migration into SAP MDG HUB for Financial data?

Any inputs will be highly appreciated.

Thanks

[former_member106]

Hello

1) Is your MDG hub system is also S4 Hana system? In any case use S4hana migration cockpit, whictis the best tool for your initial migration. Use the data transfer approach which will be very handy.

2) edition is a business decision. If all your data is ready for use in upcoming FI period please create a single edition and transfer the records. If not then create the editions accordingly

3) if you are using S4 Hana migration cockpit or any other tool, the configuration is a prerequisite. So ensure th chart of accounts, company code etc are available in th hub system, other wise you will run into problems during the data load. Do as much as test migration as possible to find th errors at earliest.

Regards

Senthilkumar

[former_member360870]

Hi Ashu,

please refer to the How to document Using the Master Data Management Generic Extractor (MDMGX) for Initial Load in MDG - F under our How to Documents for MDG-F at our Community page under https://wiki.scn.sap.com/wiki/display/SAPMDM/Documentation%3A+Financial+Data .

For time-dependent master data please also consider the following section from the SAP note

2106479 as well:

"Initial Load of Master Data to your MDG System

If you configure your MDG system into an existing SAP ERP system landscape, you have to ensure that MDG is aware of all existing master data that shall be used for governance processes. Especially for time dependent master data it is important to load all existing time slices into the MDG system. You need to translate existing valid from dates into related MDG editions. If you do not import everything correctly, MDG cannot guarantee that existing time slices are not overwritten in SAP ERP systems during data replication."

Best regards,
Attila Toth
SAP Product Support

[chahoud]

Hi Ashu,

Additional to Comments from semkum.

Please check the following Note/How To Guide

1. SAP Note 1573223 - Hierarchy Initial Load in Master Data Governance Financials
2. Using the Master Data Management Generic Extractor (MDMGX) for Initial Load in MDG - F (https://www.sap.com/documents/2015/07/34d1a653-5b7c-0010-82c7-eda71af511fa.html)

Regarding to your Questions:

1. What would be the best approach in loading data to MDG(G/L account, Cost Center, Cost Center Hierarchy, Profit Center, Profit Center Hierarchy, Cost Element, Cost Element Hierarchy, Company, Company Code etc.)

Please check the How To Guide and Note from above

2. Whether we need to create only one Edition in MDG for initial data load or Can we create multiple Editions(if yes, what precautions we need to Consider)

It depends on your business requirements. Easier if you create one with validate to eq 31.12.9999

3. Is there any particular precaution we need to take or point to need to consider while doing Initial data migration into SAP MDG HUB for Financial data?

To Check: Customizing if not MDG co-deployed.

Company Codes T001 Directory of Charts of Accounts T004 Field status definition groups T004F Field Status Definition Group Texts T004G Chart of Account Names T004T Field Status Variant T004V Countries T005 Tax Keys T007A Tax Code Names T007S Financial Statement Versions T011 G/L account groups T077S Global Company Data (for KONS Ledger) T880 Currency Codes TCURC Functional areas TFKB Control parameters for controlling areas TKA00 Controlling Areas TKA01 Controlling area assignment TKA02 Cross-System Comapny Codes T001O, V_001O_B Define retained earning accounts, Transaction BIL, Local Currencies for Company Code T001A Maintain Transaction Types for Consolidation T856

......... 🙂

Best regards

Sam

[former_member184753]

Is there any KBA/PDF for Financial data upload from ECC to MDG in 1909 environment. Thanks

Regards,

Dibakar Ghosh.

[Mark63]

You may fnd the blog series on data loads to MDG helpful.