Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel to internal table upload 'ALSM_EXCEL_TO_INTERNAL_TABLE'

I need to upload an excel that has data in two formats inside.

First 4 rows have 2 columns each- 1 column with the headings and the second column with the data

Billing Co xxxx

Invoice no. xxxxx

Invoice date 5/31/2011

PO NO. 2100002

5th row is blank

from the 6th row a table with 10 fields of invoice related data and line items

Store Number Store Name Store Address City State Zip code QTY Cost Tax rate Tax

4900 Albertville 6415 Labeaux Ave Albertville MN 55301 1 310 75% 10.68

Initially the excel format was just with the table above and I was using the 'ALSM_EXCEL_TO_INTERNAL_TABLE' fm to upload and performing case statements inside the loop. But, now since the row-column and column-row differs for the two sections, I am unable to differentiate them inside the code. Any suggestions please?

Not what you were looking for? View more on this topic or Ask a question