dynamic internal table with dynamic header

[Former Member]

Hi Members,

I have created a dynamic report ie In the selection screen i will give set of GL accounts.

Based on the GL it will separate a col like Sales GL, PF GL , Discount Gl etc. In the header portion first 3 col is constant ie it will show the vendor name and material and text remaining col is based on the GL entered in the screen it will cumulate the Total Amount and display accordingly.

This is working fine in ALV grid display, but i required to download the data to excel , while downloading to excel i am getting only the values without header,

ie title of the each col not getting . kindly guide me to solve this issue.

If i entered only sales GLs (100,101,102 ) then my output should be

vendor material mateial text 100 101 102

-

---

ddddd 11100 Raw salt 2000 1000 2500

Regards,

Mee.S

[Former Member]

Hi Meenakshi,

As per my knowledge two ways of doing it...

1. when u get the final internal table..check for the fields with not initial...again update the header internal table dynamically..

2. if you get GL or PF or any such thing you can hardcode the header and display it on to excel..

Regards,

Vamshi