on 07-30-2008 4:24 PM
Hi All,
Is it possible to download and upload vendors from my desktop?
Thanks,
Ravi
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can but need a custom program or customize the report BBP_VENDOR _SYNC.
Regards, IA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.