How to upload Finance data in MDG – Hub

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

 

1. Group Accounts
2. GL accounts
3. Extend GL at company code
4. Company – Trading partners
5. Profit Center / Cost center hierarchy
6. Profit center / Cost center master data
7. Cost element hierarchy and master data
8. Financial Statement versions

 

 

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

 

1. Create a Change request type in MDG for data upload. Do not select single object or collective processing option.
2. In MDG – using Distribution monitor – File upload method create the structure for Account
3. Create a layout for Account object and save the variant
4. Take the SKA1 dump in your ECC system and create a layout similar to your MDG layout
5. Take the data from ECC in excel
6. Save the excel file in tab delimitated Txt format. Make sure to use Unicode if you have different language data
7. Go back to MDG and create a change request for Account data upload so that we can start loading the data
8. In 1 CR, we can accommodate maximum 5000 records. We can write a Z program to approve the CR from backend.
9. Now execute the USMD_DATA_TRANSFER_BACKEND program
10. Give the required details and the entity type to upload the data
11. We can run this program in background or in foreground. For background processing we have to create a logical path, upload the file on AL11 and update the path name in variant created in NWBC
12. If the file is in proper format and with proper records, data will get uploaded in the CR
13. Approve the CR through NWBC
14. Account data is loaded in MDG tables – Table name – /1MD/MD______001 and /1MD/MD______009

 

 

 

 

 

 

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 –

 

1. Create the file structure in MDG – NWBC for CC and PC
2. Create a layout and save it as variant in NWBC which will be used in the upload program
3. Take the table dump from ECC – for PC the table is CEPC and Cost center its CSKS
4. Create similar variant in ECC (same as your NWBC variant as we may not have all the fields in MDG) and take the dump in excel
5. Save the file in text format
6. Create a CR for data upload
7. Now use the data upload program – USMD_DATA_TRANSFER_BACKEND to upload CC and PC master data
8. Choose the proper entity type. For e.g for CC – its CCTR and for PC its PCTR.
9. Execute the program – either in foreground or background depending upon no of records. At a time only 1 person can execute this program as it locks the entity type and we can load the data in 1 CR only. We can’t run this program in batch
10. Once data upload finishes, approve the CR and data is in MDG tables

 

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.

 

1. Execute the KBAS_MDGF_SET_DOWNLOAD program
2. For Profit center Group Set class is – 0106 / For Cost center group – 0101
3. Give all the required parameters – like controlling area and the other values
4. Execute the program
5. The program generates 3 files – Hierarchy name / Groups / Assignment of groups under each groups and assignment of PC or CC under the respective groups
6. Once these files are created, go to NWBC and create a structure for PC / CC hierarchy / PC and CC Group and assignment separately
7. Create a Change request to load the PC / CC group / hierarchy. The CR should have all the entity types like – Hierarchy – group and PC or CC in it and don’t tick single processing or object required
8. Create a CR in NWBC
9. Make sure that all the profit center data is loaded before we start hierarchy load and make it available in table in MDG
10. Create proper layout for each file in NWBC and save it as variant
11. Load the hierarchy name file first – using USMD_DATA_TRANSFER_BACKEND
12. Load the group file after hierarchy – using USMD_DATA_TRANSFER_BACKEND
13. Load the assignment file at last – using USMD_DATA_TRANSFER_BACKEND
14. Once done, we can check the entire hierarchy with all the assignment through Collective processing

 

 

 

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

 

1. Make sure that all the General ledger accounts are in system
2. Cost element table – CSKU and CSKB
3. Load the cost element group using the same program in ECC – using KBAS_MDGF_SET_DOWNLOAD program – Set 0102 and 0109 for account group
4. Follow the steps as mention for CC and PC above

 

 

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

 

1. Execute program – FBS_MDGF_FRS_DOWNLOAD in ECC
2. Fill up all the required fields and save the files on presentation server
3. In MDG, create a CR to load the FSV.
4. Make sure that the CR is in process – Changes to be executed status
5. In MDG, create a variant through NWBC – Distribution monitor – Data upload
6. Save the layout for Financial statement Version and Financial statement Item
7. Then execute program – USMD_DATA_TRANSFER_BACKEND in MDG
8. Give the variant name saved through NWBC and fill up all the required fields.
9. Execute the program. If data is fine and everything is in place, data will be uploaded in the Change request assigned to you
10. Approve the CR and the data is in MDG tables
11. You can view the FSV using collective processing.