BAPI for VENDOR initial data upload IN MDG

[former_member314998]

Hi,

  I need to upload VENDOR intial data in  MDG, I only find BAPI_VENDOR_CREATE for that.

Please suggest me the suitable one.

Samrat

[Former Member · Accepted solution]

Hi Samart,

File can be uploaded to MDG using Import Master Data.

To do this you need :

1.Data in an XML file

2. Maintain the logical directory path on an application server

3. You can then upload the file using TA: CG3Z to the application server.

4. Now from MDG side, you can go to Data Transfer--> Import Master Data

5. Specify the object type and the governance settings.

6.  Under Data Sources Add the Object type and the Source directory that you have mapped.

7. Check the Directory Content by clicking on show directory content and check the XML file should be available.

8. Simulate Import and Click on Import.

9. This will create a Change Request.

Hope this will help you.

Regards,

Reema

[former_member206605]

Hello Samrat

I have used USMD_DATA_TRANSFER_BACKEND program extensively to load initial data into mdg.

Steps -

1. Create a variant through NWBC - for loading the data for the entity type - Distribution monitor - Upload data

2. Create the layout and save the variant

3. Create a blank CR and assign it to your name - this is required and you can create separate data upload CR types

4. Run program - USMD_DATA_TRANSFER_BACKEND (SE38), give the entity type and the variant name created through nwbc.

5. Give the file path and execute the program.

6. Data will be saved in the CR

7. Approve the CR so that data is stored in the tables

8. Make sure that the replication model is deactivated for initial load.

Try it and let me know.

Kiran

[michael_theis]

Hi Kiran,

this is not the recommended way for MDG-BP/C/S. Please see Reema's reply for the general recommendation.

Best regards

Michael

[former_member206605]

Thanks Michael....I have used it for Finance and worked well.

Kiran

[former_member314998]

Hi Michael,

       Thanks for your valuable reply. I also have another query that

HOW to DOWNLOAD DATA FROM CLIENT SYSTEM IN XML Format?

Regards,

Samrat

[former_member206605]

Hello Michael

Can we use similar approach as suggested by Reema for Finance too? Is there any disadvantage if we use the the back end program for Material or Customer or Vendor?

Thanks

Kiran    

[Former Member]

Hi Kiran,

For MDGF please follow below steps:

• Use File Upload from NWBC
• Select the entity type, Type of transfer,and Edition.
• Remember to have a open Change request
• Create the Structure
• Create the File in the Notepad, with the same pattern the structure has been created in the File upload seperated by " ;".
• Now upload the File.
• Once file is successfully uploaded.You can then process the Change request.

Note: Before uploading hierarchies, Kindly replicate the attributes or else it will show error " Entity does not exist".

Also for more easy convenience, you can download the sample data from an existing Change Request and use it as a reference to create the structure.

Regards,

Reema

[former_member206605]

Hello Reema

I have used the same way and loaded huge data including hierarcies. Just wanted to understand what is the difference in 2 approach?

Kiran

[Former Member]

Hi Samrat,

Kindly check this function module " SAP_CONVERT_TO_XML_FORMAT".

Regards,

Reema

[michael_theis]

Hi Samrat,

please refer to SAP Note 1035601 for details.

Best regards

Michael

[michael_theis]

Hi Kiran,

only partially, starting with MDG 7.0. Please refer to http://scn.sap.com/docs/DOC-7858 for details on the refined initial load for MDG-F entities.

Best regards

Michael

[former_member206605]

Thanks a lot Michael. This link is very useful....

Kiran

[former_member314998]

Thanks for your quick and valuable reply.

Again I want to download mass data from client system in XML format,

How can I do this. Pls guide me.

Thanks

Samrat

[Former Member]

Hi Samrat,

I was searching for the same.I have found one link.Kindly check if it helps you.

Exporting data to Excel - XML to the rescue - ABAP Development - SCN Wiki

Regards,

Reema

[Former Member]

Hi Samrat,

Below thread describes the details to download dictionary table.Kindly check.

This is working for me.

Regards,

Reema