topic Re: BDC uploading (from excel sheet ) in Application Development and Automation Discussions

BDC uploading (from excel sheet )

Former Member — Tue, 15 Jan 2008 06:38:27 GMT

Dear All,

I have data in excel sheet format in my desktop. I need to upload that file into SAP through BDC. As I am new and first time going to work on this. Can anybody show me the way or steps that How I will proceed on the same.

Best regards.

Re: BDC uploading (from excel sheet )

Former Member — Tue, 15 Jan 2008 06:47:48 GMT

hi,

For a BDC upload you need to write a program which created BDC sessions.

Steps:

1. Work out the transaction you would use to create the data manually.

2. Use transaction SHDB to record the creation of one material master data.

Click the New recording button or the Menu - Recording - Create

3. Save the recording, and then go back a screen and go to the overview.

4. Select the recording and click on Edit - Create Program. Give the program a Z name, and select transfer from recording.

5. Edit the program. You will see that all the data you entered is hard-coded into the program. You need to make the following changes:

5.1 After the start-of-selection, Call ws_upload to upload the file (the excel file needs to be saved as TAB separated).

Or else you can use GUI_Upload, which asks for type of file.

Then you can select spredsheet as you option.

5.2 After the open-group, Loop on the uploaded data. For each line, perform validation checks on the data, then modify the perform bdc_field commands to use the file data.

5.3. After perform bdc_transaction, add the endloop.

Execute the program. It will have options to create a batch session or to process directly.

Hope this is helpful, Do reward.

Re: BDC uploading (from excel sheet )

Former Member — Tue, 15 Jan 2008 06:54:33 GMT

You can use this FM ALSM_EXCEL_TO_INTERNAL_TABLE

Check this thread for sample code.

Regards,

Maha

Re: BDC uploading (from excel sheet )

former_member404244 — Tue, 15 Jan 2008 06:57:17 GMT

Hi,

Check the below link for sample program on BDC using call transaction and session method

http://www.sapdev.co.uk/bdc/bdchome.htm

check the file upload sampleprograms in the below link

http://www.sapdev.co.uk/file/file_updown.htm

Regards,

nagaraj