topic bdc table control using excel file in Application Development and Automation Discussions

bdc table control using excel file

Former Member — Wed, 19 Dec 2007 13:57:47 GMT

hi friends ,

i am trying to upload production order using bdc

program is working fine in notepad but i want to

upload using excel sheet.

my pboplem is i am using two table

one for header and 2nd for item

in that i used identifier h for header

and i for item.

h1000 261 2000 3000

i100 a

how to map using excel file.

Re: bdc table control using excel file

Former Member — Wed, 19 Dec 2007 14:07:44 GMT

Hi,

Are you using FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload the data to internal table?

Use it and do the process in the same way what you did for Notepad.

Regards,

Satish

Re: bdc table control using excel file

Former Member — Wed, 19 Dec 2007 15:58:29 GMT

Hi Sonu,

First upload data from excell file to internal table by using above answer FM. After that loop at that internal table. Use if condition lile If itab-f1 = 'H' move another header internal table else move to item internal table. Now process your data and populate final internal table,,

Hope this helps you and if aconcerns get back me.....we will update you..

Regards,

Kumar.

Re: bdc table control using excel file

Former Member — Wed, 19 Dec 2007 22:26:31 GMT

Dear Sonu,

I understand that you want to upload excel sheets into bdc table control. You can do the same using function module GUI_UPLOAD, but we need to give file type as 'wxi'. OR use alsm_excel_internal_table.

Best Regards,

Rajesh.

Please reward points if found helpful.