Reading data from Spool

[Former Member]

Hi All,

I have a requirement to read data from spool. I have used few function modules but those function modules do not return the complete data in the spool. The number of fields in the output is 44 but I receive only 30 fields from the spool. in SP01 if I choose the (Display in Maximum Width) I can download the full data. But is there any FM that can help me....

Thanks ,

Sarath.C

[Former Member]

I think You can read data only upto 255 charecters..

[Former Member]

Sarath in addition to that u can do this..

lets say ur report is ALV and it contains 44 fields.. u said only 30 are visible

out of the 44 fields say 14 fields are primary keys..

now save two layouts one layout containing 14 primary keys and 15 non primary keys.. other layout containing 14 primary fields and the remaining 15 non primary fields.

now. if you run report with layput 1 you can see the o/p with 29 fields out of which 14 are primary and 15 are non primary...

if you run report with layput 2 you can see the o/p with 29 fields out of which 14 are primary and 15 remaining non primaryfields

you can schedule bo the reports in background..

read both the spools .. now both spools have primary keys in common...

now.. read 2nd internal table with primary kesy of 1st internal table..

hope it helps...

[Former Member]

HI Sarath,

The row_pos col_pos properties in fieldcat can be used for this. u can set the row_pos as 1 for first 15 columns and 2 for the rest.

In spool u see the list in two lines for each line.. that shud fit in the constrained size of 255 also.

U may give it a try and it shall work.