Skip to Content

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

ALSM_EXCEL_TO_INTERNAL_TABLE not taking null values


I am uploading data from my excel sheet to an internal table. For this purpose i have used ALSM_EXCEL_TO_INTERNAL_TABLE.

The problem with this FM is that it does not consider the blank spaces.

for e.g if there is an Excel sheet with the following data

Name Age

ABC 10

DEF 15

blank blank

XYZ 20

The internal table stores it as

row-001 col-001 value - ABC ; row-001 col-001 value - 10

row-002 col-001 value - DEF ; row-002 col-001 value - 15

row-004 col-001 value - XYZ ; row-004 col-001 value - 20

But i need the blank values as well i.e. values in row3.

Is there a work around for this?

Thank You

Vipin Rajan

Former Member

Helpful Answer

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