GUI patch 55 changed output of FM ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Hello all,

When uploading an Excel file using function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' the internal table that is returned is populated differently with GUI patch 54 that it is with GUI patch 55.

Patch 54 creates a row for each column in the each row of the input file . If the input file had 5 rows and 10 columns, the internal table would have 50 rows. This is the way we expect the function module to work and the way it has been working since version 4.5. We are currently on version 4.7.

Patch 55 creates a single row in the internal table for each row in the input file. If the input file had 5 rows and 10 columns, the internal table would have only 5 rows.

Has anyone else applied GUI patch 55 and seen this same behavior? If you have, have you found a workaround? We notified SAP via OSS a couple of days ago and we are waiting for an answer.

Thanks

Bruce

[athavanraja]

I just checked in my system (WAS6.4 SP11) and it looks fine.

whats the tables parameter reference structure?

is it using ALSMEX_TABLINE or something else.

(it should have fields ROW,COL & VALUE)

Regards

Raja

[Former Member]

SAP has created a note to address this problem, 852709. This problem will be corrected by applying patch 56 when it becomes available.

Thanks

Bruce