Simple Transformation using Dynamic internal table

[Former Member]

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.

[Former Member]

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