bdc table control using excel file

[Former Member]

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

i100 a

how to map using excel file.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.