Skip to Content

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

Uploading Data From Excel Sheet to SAP Database Tables

Dear Friends,

We are having an Excel Sheet with 90 different columns. Now we want only 2 of the columns to be uploaded in the database tables. So, Plz tell me which function module will be suitable for this. And plz help me with the code also.

Thanks,

Nishant Jain

Tags:
replied

HI Nishu,

As suggested you can use ALSM_EXCEL_TO_INTERNAL_TABLE..

specify the filename..

the return internal table of type ALSMEX_TABLINE

WHICH HAS A FIELD <b>COL</b> which indicates the column

just loop at that itab chack if COL is <= 2 and put it into another itab..

this will have only first 2 columns from the excel..

if you dont get it .. just reply i'll get some sample code..

regards

satesh

0 View this answer in context

Helpful Answer

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