ALV Question

[Former Member]

I have a report with ALV output. When i run the report in the foreground it works fine.

But when i run in the background it truncates last 4 columns( may be i have too many colums, I get a scross bar in the foreground). I tried to increase the width of the report but that did not help. even if download the spool to excel it still downloads without last four colums.

Do you guys have any idea how i can download all the fields in the report to excel through spool.

thanks in advance

Shammi

[Former Member]

I have a report with ALV output. When i run the report in the foreground it works fine.

But when i run in the background it truncates last 4 columns( may be i have too many colums, I get a scross bar in the foreground). I tried to increase the width of the report but that did not help. even if download the spool to excel it still downloads without last four colums.

Do you guys have any idea how i can download all the fields in the report to excel through spool.

thanks in advance

Shammi

[former_member194669]

Hi,

Use the following fm

RSPO_RETURN_ABAP_SPOOLJOB

RSPO_RETURN_ABAP_SPOOLJOB_RAW

RSPO_RETURN_SPOOLJOB

then use OLE for excel or fm

EXCEL_OLE_STANDARD_DAT

a®

[Former Member]

hi u cannot have more than 70 columns..it will truncate 71th column..can u tell me hw many columns do u have in dat...

[Former Member]

Hi ,

use col_width_optimize = 'X' of layout. and check it. it is because of width problem. may be you have exceeded the maximum width.

Best Regards

Vijay