ALV layout issue in excel sheet

[Former Member]

Hi all,

When i executed my report, it will send the output data in excel format to my email id.

It is ALV report. When i changed the layout , the layout change is happening in report output, but in my excel sheet chagned layout set was not coming. It is coming old format only.

Is there any FM to handle the dynamic layouts

please help me in this.

regards,

Ajay Ram

[Former Member]

Hi all,

When i executed my report, it will send the output data in excel format to my email id.

It is ALV report. When i changed the layout , the layout change is happening in report output, but in my excel sheet chagned layout set was not coming. It is coming old format only.

Is there any FM to handle the dynamic layouts

please help me in this.

regards,

Ajay Ram

[Former Member]

Hi Ajay

When you change the layout, its done in the ALV o/p or rather in foreground.

You can't make this layout change be reflected in the excel sheet that is made thru background job.

One option is to save the layout you want and then before executing the ALV report, load the layout you want by using FMs

REUSE_ALV_VARIANT_DEFAULT_GET

REUSE_ALV_VARIANT_F4

REUSE_ALV_VARIANT_EXISTENCE

You can get the sample codes in sdn by searching for these FMs

Reward points if useful

Cheers

~Arun