Home > ABAP, API > ALSM_EXCEL_TO_INTERNAL_TABLE

ALSM_EXCEL_TO_INTERNAL_TABLE

April 29th, 2010 Leave a comment Go to comments

Many customers need a function that allows them to transfer values from an Excel table to the SAP system. Up to now there has been no formally released interface for this.

For the Asset Accounting legacy data transfer, a module was written to transfer the Excel data using the clipboard of the Windows system by OLE (Object Linking and Embedding. This module is called ALSM_EXCEL_TO_INTERNAL_TABLE. The module was only designed for the requirements of the Asset Accounting legacy data transfer. This leads to some restrictions, including the following:

1. The module is not released for customers.

2. The module is only available in a SAP_APPL system.

3. The output structure is limited to 9999 rows and columns.

4. The output structure is limited to 50 characters per cell.

If you use the module in spite of this and want to get around the restrictions from points 2 to 4, we recommend that you proceed as follows:

1. Copy the module into your customer namespace.

2. As Associated Type for the table parameter INTERN, use your own structure that has the same components as the original structure ALSMEX_TABLINE. By using your own component types, you can get around the restrictions on rows, columns or cell length.

  1. SAPSecure
    May 4th, 2010 at 04:55 | #1
    Reply | Quote

    Thanks for identifying this function. However, the pitfall of such tools is, that these are limited to specific applications. “The module was only designed for the requirements of the Asset Accounting legacy data transfer.”

    Visit the article below for a very flexible way to load data into a system, without the need for programming or disclaimers “Valid only….”.

    http://home4sap.com/Blog/2010/01/is-your-data-moving-in-a-limo/

    Keep up the great work with your blog!

  1. No trackbacks yet.