Simple Transformation using Dynamic internal table

Former Member — Wed, 06 Jan 2016 13:06:50 GMT

Hi Experts ,

Please help .

I have a requirement to export alv grid data to excel . the data has some custom stuff hence im using simple transformation ,

The field catalog was build dynamically and the internal table containing the data was built dynamically and is passed to the simple transformation .

"LOOP ONE"

to get the column text in xml , im passing the field catalog table to the simple transformation as one of the parameters and loop through it using using field "coltext" as my column text .

"LOOP TWO"

My problem is how can i loop through the dynamic internal table that contains the data . to the corresponding columns - i only know 17 columns , the rest are created dynamically .

You help will be highly appreciated .

Thank you.

Re: Simple Transformation using Dynamic internal table

Former Member — Wed, 06 Jan 2016 14:00:38 GMT

Hi Mulamuli,

Is using simple transformation a must in your situation?

I have seen custom modules done by others and even a blog http://wiki.scn.sap.com/wiki/display/ABAP/Excel+with+SAP+-+An+overview that mention new standard FM's depending on your version of SAP that simplify the entire process of generating excel documents and make them compatible with the newer excel types.

However if you are required to use simple transformation look at the FM GET_COMPONENT_LIST this FM will return all the details about your ITAB including field names and stuff of that nature that you do not already know.

Hope this helps,

Geoffery

topic Simple Transformation using Dynamic internal table in Application Development and Automation Discussions

Simple Transformation using Dynamic internal table

Re: Simple Transformation using Dynamic internal table