hi experts 1 query regarding alv report running in background

[Former Member]

when i run my alv report with 40 columns in background in spool when i get output disturbed 20 lines of first row is moving to second row so when i download to excel the o/p is completely disturbed and no use for me is there any way to solve this problem.please reply

[Former Member]

Hi

Please check yr table name in fieldcatlog-tabname.

If u define wrong table name in any of one column

fieldcatlog-tabname then this problem occurs.

I hope this is helpful for u.

[former_member182354]

When you run the report in background please recheck the format that you are selecting .

Raghav

[former_member182354]

Run with X_65_80 format ...Then you will get the desired output...

Raghav

[Former Member]

hi ,

this will solve your problem

http://www.saptechnical.com/Tutorials/ALV/Spool/width.htm

Increasing the width of the spool when using ALV List

By Aafaque Husain, YASH Technologies

Whenever an ALV report (with more number of columns) is scheduled in background, the output will be displayed in a zigzag fashion as shown below:

If we try to download the output from the spool or try to view the output, then we observe that the output is not in an appropriate fashion.

To get the right format of output in the spool we generally increase the u201Cno. of columns fieldu201D in the Format typesu201D. Have a look at the following screenshot:

Sometimes even when we change this field, we get the output truncated at the end, like last few columns are not displayed. There is certain limitation for this field, so that even if increase this value again, we find no change in the output display in spool.

This value is effective only when we check the check box u201CNumber of columns from list display formatu201D in the SPAD transaction.

Ø GO to SPAD Transaction code

Ø In the menu Settings -> Spool System as shown belowu2026

Ø In the others tab check the first check box in the Output Controller block, SAVE and exit.

Now Schedule the ALV report again by providing the output device and format, and then we get the full output in the spool as shown below:

Regards,

Madhavi

[Former Member]

U create the fld catalog with row col method....mean...

row =1

col =1

row =1

col =2

row =1

col =3

row =2

col =1

row =2

col =2

row =2

col =3

in this way u can distribute out o/p flds....

Reward point if helpful