Skip to Content

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



Iam using 'ALSM_EXCEL_TO_INTERNAL_TABLE to get data frm excel sheet to internal table.its working fine if it has fixed columns.

But my problem is fst five columns of my excel sheet have header records and rest of the columns have item records of that header record. this is repated for each row. i.e, my each row have differnt set of new records.

For example

A B C D E 1 2 3 4 5 6 7 8 9 10

in these ABCDE are header records and others are item records.

we need to store in internal table as

A B C D E 1

A B C D E 2

A B C D E 3

A B C D E 4

A B C D E 5

A B C D E 6

A B C D E 7

A B C D E 8

A B C D E 9

A B C D E 10

any inputs how to get data in to internal tables for these types of excel sheets.

Helpful Answer

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