Master Data Consolidation : Export Master Data

[Former Member]

Dear All,

For master data consolidation sap has given standard export/import apps(BP/REL/Products) for downloading master data and uploading to target system.

But incase source system of data is not mdg system, in such scenario how we can use export data app for downloading the master data into excel? bec in export data app there is no provision to explicitly maintain system details for fetching the data(its dedicatedly linked to base system where fiori app is deployed).

For example.

Our source system is ECC(say Source_1) and our MDG is running on separated system say (MDG_1). and we would like to download data from Source_1 and upload to MDG_1 but export data app is only downloading MDG_1 data.

Does Export data app is only of consolidation of active data and not for source data.

Best Regards Vikrant Sharma

[moshenaveh]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful). The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question. Should you wish, you can revise your question by selecting Actions, then Edit. Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

[former_member206605]

Hi

If your source system is ECC then then you can download the data directly from tables. Create a layout exactly as per the exported excel sheet and later you can copy-paste and load it in consolidation.

kiran