topic Re: Reading data from Spool in Application Development and Automation Discussions

Reading data from Spool

Former Member — Thu, 16 Jul 2009 06:11:20 GMT

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

Re: Reading data from Spool

Former Member — Thu, 16 Jul 2009 06:28:21 GMT

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

Re: Reading data from Spool

Former Member — Fri, 17 Jul 2009 10:24:44 GMT

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...

Re: Reading data from Spool

Former Member — Fri, 17 Jul 2009 13:45:40 GMT

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.