cancel
Showing results for 
Search instead for 
Did you mean: 

Upload vendors from Excel

Former Member
0 Kudos

Hi All,

Is it possible to download and upload vendors from my desktop?

Thanks,

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can download the data from individual database tables directly from Data Browser or Data Dictionary.

1. Using Data Dictionary:

Go to transaction SE11 -> Choose "Database table" radio-button -> enter table name -> Choose "Display" or press F7 -> Choose "Contents" option in application toolbar or press "CtrlShiftF10" -> enter selection parameters if you want to filter data -> choose "Execute icon" or press F8 -> You will be displayed with records -> Now choose System - List - Save - Local File from menu bar -> choose the format and enter file directory and file name.

2. Using Data Browser:

Go to transaction SE11 -> Choose "Contents" option in application toolbar or press "F7" -> enter selection parameters if you want to filter data -> choose "Execute icon" or press F8 -> You will be displayed with records -> Now choose System - List - Save - Local File from menu bar -> choose the format and enter file directory and file name.

To download data from multiple database tables based on specific logic, you need to write a program to do so.

Upload:

Where do you want to upload the data. If you want to create vendors from your excel file, you will have to use LSMW, BDC, BAPI, or IDOC to do so.

If you just want to display the data from your local file in SAP program, develop a report for the same.

Visit following link:

http://it.toolbox.com/wiki/index.php/How_can_I_upload_data_to_SAP_and_download_data_to_Excel%3F

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

Regards,

Srilaha.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Try using the FM "BAPI_BUPA_CREATE_FROM_DATA" and then "BP_BUPA_CREATECENTRALPERSON" in the custom program for creating vendors and their contact persons.

BR,

Disha.

imthiaz_ahmed
Active Contributor
0 Kudos

You can but need a custom program or customize the report BBP_VENDOR _SYNC.

Regards, IA