FM ALSM_EXCEL_TO_INTERNAL_TABLE

[former_member640793]

I HAVE USING THIS FM ALSM_EXCEL_TO_INTERNAL_TABLE

HOW I CAN MOVE THE FIELD "VALUE" OF TABLE OUTPUT OF FM ALSM_EXCEL_TO_INTERNAL_TABLE INTO IN A INTERNAL TABLE WITH CORRECT POSITION?

[former_member1716]

Hello luca treva,

You have to basically extract out the data from the VALUE field.

For example:

If VALUE holds the value as 20191105TESTUSER , consider the field VALUE holds both the date and user name in concatenated format as above. Now you need to understand the values and its field names and extract the data into the fields as below:

lv_date = VALUE+0(8). --> Retrieves date into LV_DATE

lv_user = VALUE+8(8). --> Retrieves user into LV_USER

Note: LV_DATE and LV_USER are the local variables declared for date and user respectively.

Regards!

[former_member640793]

thanks for your answer.

but I have to fill an internal table with various fields, and the values of these fields are contained in "VALUE" filed.

how do I assign field values within the corresponding fields of the internal table?

[former_member1716]

luca trevaAs i have explained above you have to extract the data for each field from VALUE field and feed it to the corresponding fields of work area and finally append to the internal table.Note: Work area and internal Table should be declared by you based on the data you receive.Regards!

[Sandra_Rossi]

Please don't write in upper case, it's understood like "shouting".

There are lots of questions and answers about ALSM_EXCEL_TO_INTERNAL_TABLE in the forum. Did you search first?