Mass upload of Profit/Cost center Alternate hierarchies in MDG

[chetan_kumar6]

Hi Experts,

We are in process of Finance master data migration for Profit center and Cost center and their hierarchy assignments. We have already uploaded PC, CC and respective standard hierarchy assignments using standard tool File upload and report USMD_DATA_TRANSFER_BACKEND and have no issues. We have used standard report KBAS_MDGF_SET_DOWNLOAD to extract the hierarchy data from source systems.

Now, the challenge is to upload Alternate hierarchies, as there are around 100 PC alternate hierarchies and 1700 CC alternate hierarchies.

Questions:

1. Is there a better approach or a way to extract the hierarchy data for all the sets at a time other than report KBAS_MDGF_SET_DOWNLOAD as we can extract for one set at a time using this report. We need to extract data from 6 ECC source systems

2. Is there a best approach to do the bulk upload for all SETS in MDG?

Appreciate your quick help!

Thanks,

Chetan Bappankar

[laurentpayan]

Hi Chetan,

if KBAS_MDGF_SET_DOWNLOAD doesn't work for you, you can try to manually download the following tables via SE16:

- SETHEADER / SETHEADERT -> those tables will give the top level of each hierarchy

- SETNODE -> this will provide the hierarchy assignment between nodes. I recommend you run it in iterations from parent nodes to children

- SETLEAF -> this is for the cost center or profit center assignment

Good luck.

[laurentpayan]

To answer your second item about a bulk upload, you will need to use the standard MDG file upload function with 3 steps:

1. load all alternate hierarchies via entity type CCTRH / PCTRH, with type of transfer = attributes

2a. load all lower level groups via entity types CCTRG / PCTRG, with type of transfer = attributes

2b. optional - if hierarchies exist in multiple languages, repeat 2a. for each language with type of transfer = language-dependent texts

3. load all groups and cost center / profit center assignment via entity types CCTRG / PCTRG, with type of transfer = hierarchies