topic Re: ABAP Function Module in Application Development and Automation Discussions

ABAP Function Module

Former Member — Thu, 17 Jul 2008 09:20:46 GMT

Hello Experts,

I am working on requirement in which i m facing problem.

I have an excel sheet with 5000 records.

In which i shud retreive only last 2 charecters of a particular column.

can anyoen help me what to write..?

Thanks,

varun.

\[removed by moderator\]

Edited by: Jan Stallkamp on Jul 17, 2008 12:34 PM

Former Member — Thu, 17 Jul 2008 09:24:08 GMT

Hi!

1. use the ALSM_EXCEL_TO_INTERNAL_TABLE fm to upload the excel table into an internal table

2. make a LOOP at the internal table and process it to your needs.

Regards

Tamá

former_member125931 — Thu, 17 Jul 2008 09:24:29 GMT

resize the particular field length for char2 while you r uploading or downloading as per your requirement.

Former Member — Thu, 17 Jul 2008 09:26:33 GMT

Hi,

Use ALSM_EXCEL_TO_INTERNAL_TABLE Function moule : it will transfer data in a flat file of .csv or .xls format to an internal table.

After that process your internal table to get the last two characters.

like:

loop at itab.

length = strlen ( itab-field2 ).

length = length - 2.

two_char = itab-field2+length(2).

endloop.

regards,

rama.

former_member200872 — Thu, 17 Jul 2008 09:32:22 GMT

Hi,

Upload the data in spread sheet to an internal table.

Get the last two digits of required column in loop.

Try out the sample given below.

Regards,

Wajid Hussain P.

loop at itab into wa.

move: col4+10(2) to v_data.

endloop.