How to upload Finance data in MDG – Hub
SAP has provided a note to load initial data in MDG from FI but while implementing MDG, I found many points needs to be added in the note.
Prepared a detail step by step document which will be useful for loading the finance data from ECC to MDG.
Attaching the document – Reference is – SAP note – 0001573223_initial_load – added various steps in the document and how to work on some of the errors which one may come across while loading the data.
Added the program name as well and table names.
Kiran Bapat
Hi Kiran
Thank you for sharing useful information.I need some clarification for below points
For Time depentdent CO objects (Cost Center/Profit Center/Cost Element) there is validity period against each value.
Example: Suppose I Have 2 CC in ECC with validity dates as 01.01.2013 to 31.12.2013 for C1 and 01.01.2014 to 31.12.2014 for C2. For File upload process
Hello Sanjay
1. You have to analyze your data first. Take all the cost centers and its validity date. Depending upon the date, create the edition.
2. In your example, take all the CC valid from 01.01.13 to 31.12.13. Load the data. Release the edition. Create new one with 01.01.2014.....and so on
On your 2nd query - Uploaded data won't get replicated in ECC unless you change it. If you are loading the data then please de-activate the replication model. Activate it once data load is complete.
Kiran
Hi Kiran
Thank you for confirmation!
Hi Kiran
Needed one more.
CCTRH is time indepdent but for that also we have to consider controlling area validity for defining edition, is this correct? Then what about CCTRG?
For intitial load of CCTR I am facing ABAP dump Message USMD1A 000 (Program error)
My ECC CCTR validities range from 01.01.2013 upto 31.12.9999 so I created edition with Validity 01.0.2010 to 31.12.9999. But in excuting upload it gives ABAP Dump.
Should I delete completed CCTR in ECC?
Start date won't be much issue. The dump you are getting is due to some other reason. What exactly is the message? Please check and let me know.
Kiran
Hi Kiran
In this blog for intial data upload for CC/PC you mentioned that
Can you explain how to do this as I tried with File Download but can't see any structure in generated file?
Can you explain me as tried to do by generating batach varaint in SE16N under EXTRA tab and but able to save in Excel as no option for Export as Spreadsheet?
Hi Kiran,
I have separate box for MDG and ERP ECC. So program KBAS_MDGF_SET_DOWNLOAD for hierarchy download is not available in ERP ECC system.
Kindly let me know if any other way for hierarchy download.
Thanks,
Dharamveer
Kiran Bapat Thanks for sharing this document.
But I presume this document is only useful when we have MDG Hub scenario?
How do we import finance data from ECC to MDG if the same instance is used?
Is there a standard program for this initial load?
Thanks.
Hello Zubin
Since MDG-F is based on Flex mode, you have to use same method to upload the data in MDG tables. Finance data is stored first in MDG tables and then transferred to ECC - though its same instance.
Kiran
Hi Kiran,
1. How does the upload functionality work in MDG-F to do the initial load of GL, Cost Centers?
2. I assume that master data is first created in ECC and this is used (SKA1, SKB1) to do the load into MDG-F (?)
Thanks.
Hello Zubin
1. You can load GL / CC using MDMGX or downloading the data in file and uploading in MDG. MDMGX is the best tool you can explore for GL / CC and PC
2. For hierarchy you can't use MDMGX. You have to load the data in file from ECC and upload it in MDG.
3. Before MDG-F implementation, the master data is created in ECC and then you need to load the data in MDG. Once MDG is implemented then you can use MDG and replicate the data to ECC.
Kiran
Hi Kiran,
It says MDMGX is to be used for MDM.
But my question is about MDG - does MDMGX help here as well?
Hi Kiran,
We are using the File Upload method to do mass change.
Changes happened successfully but Date of Creation of Cost Center is changed to Mass upload change date and has overwritten the old date.
Can you please confirm, if we are missing something here.
We have used the Overwrite Attributes option while uploading.
Thanks and Regards
Karan Arya
Hello All,
Where I can find this document?
I am unable to see any links to the same.
Thanks,
Dinesh
Not sure why I can't view the attachment...let me paste the details here...
DATA UPLOAD PROCESS IN MDG FROM ERP
Data upload is one of the critical activity in any MDG project. Before Go-Live one has to upload entire master data from ERP system to MDG hub.
This process has many steps and outlining the steps below for Financial master data upload for following objects
General Ledger Master Data upload Process – Group accounts and Extension to company code
Upload all the Group accounts and then upload all GL at company code level
Data upload process for loading Profit / Cost center master data
Before we load the hierarchy structure for CC and PC, we have to load all the PC and CC from ECC to MDG. The process is –
Data upload process for loading Hierarchy – CC and PC
The CC and PC hierarchy data is stored in Sets and Set class. SAP has provided a program to download entire hierarchy data in text file from ECC system and load these files in MDG.
Data upload process for loading Hierarchy – Cost Element
For Cost element data upload the process is exactly same as Cost center and Profit center but we have to make sure on few points
Data upload process for Financial Statement version
Data upload process for FSV is slightly different then CC / PC and CE. First we have to load the data from ECC for all Financial statement versions. Upload them in MDG through the upload program. Listing down all the steps here
Thanks a ton!!!!!
Also would it be possible for you to advice on Reference data load. We need to set that up before we do the master data load.
I know of a methodology using SOLMAN where we can sync the configurations from ECC to MDG but for that ERP Systems have to of same version.
In our scenario we have 9-10 legacy systems, from where we do need the reference data. Usually the are similar but still want to understand the possible options.
Thanks!
Thanks a lot Kiran.....!
I was confused about PC/CC Hierarchy and Group. After reading this blog my doubt has been cleared.
Thanks and Regards,
Shriniwas Mogarge
Hi
If there are 9-10 legacy systems, then you have to prepare a golden record which you can transfer to SAP ECC. Once the records are moved to ECC, you can transfer them to mdg hub - using SOLMAN or directly moving table data through transport requests.
Kiran
Hello Kiran,
Thanks for your help. It has helped a lot. Now i have another issue.
We need to load groups and Hierarchies into MDG Hub. I can upload the Hierarchy using the methodology mentioned in document. but the issue is that it allows to upload only 1 at a time.
In my case i have around 800 groups as top nodes in one Controlling area. I cannot create 800*3 files and upload them. Pus i need to manually pick which all are the top nodes whic need to be treated as Hierarchy in MDG.
Is there a way to pick all top nodes? If i have that then i might be able to run the program in loop and figure out something but not sure.
Let me know your thoughts on this.
Thanks,
Dinesh
Hi Kiran,
The File Upload Variant does not saves the file location.
In NWBC -> File Upload -> I completed steps 1, 2, and 3. Assigned Load file in the step 3 and saved the variant.
Now, I run the USMD_DATA_TRANSFER_BACKEND and enter Data Model, Entity Type, Variant, Type of Transfer and execute (assuming file location will be fetched from variant), but system gives error “File could not be opened”
When I check the File upload variant in NWBC, the file location is not saved.
I want to run this in background as I have 10K+ records in a file.
I am looking forward for your suggestion.
Thanks.