Excel to internal table upload 'ALSM_EXCEL_TO_INTERNAL_TABLE'

[Former Member]

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?

[Former Member]

I think you simply need different logic based on the row number.

Rob

[sanath1]

Hi Kiran,

May be you can use the same function mnodule.

The thing is that after getting into an internal table May be you can edit that internal table and prepare the contents in it according to your requirement and may be you can copy this into another internal table as per your convenience.

Thanks,

sanath.

[Former Member]

a

Edited by: kiransap123 on Jun 1, 2011 8:37 PM

[Former Member]

Accidentally hit the answered button

[Venkat_Sesha]

Hi Kiran,

You Catch up the right function Module...

if the first row of the column is common field i.e., VBELN then it is very simple we can use a Control Break Statements.

Try it first if you dont found a solution then I will send the code.

Thanks & regards,

Bhargav.