Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find a report output - URGENT

Former Member
0 Kudos
195

Hi all,

We have an ABAP program and its basically a report, how can I see the output of the report ie the list.

Please let me know

thanks

Sabrina.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
117

are you talking about viewing some previous report output? if yes then SM37 is one option if this report was run as a background job previously. There u can see the output that was generated.

you need to execute the report program to view the output, if your query is not as simple as it seems, Please elaborate a bit more on exactly what you are looking for.

regards,

PJ

10 REPLIES 10

Former Member
0 Kudos
118

are you talking about viewing some previous report output? if yes then SM37 is one option if this report was run as a background job previously. There u can see the output that was generated.

you need to execute the report program to view the output, if your query is not as simple as it seems, Please elaborate a bit more on exactly what you are looking for.

regards,

PJ

0 Kudos
117

thanks Priyank for your reply.

Well we have an ABAP program in BW that outputs a flat file of data. It is basically a report, it runs every morning and I need to find out the output of the report. In SM37 when I select the job and click the button SPOOL, I get the following message that I don't have authorization to view the list.

No authorization to select from spool request 24,323 in system CBP

and then it says list contains no data.

What should I do? Please let me know.

thanks

Sabrina.

0 Kudos
117

From what you say, it obviously seems to be an authorization issue. get in touch with basis for the same. if u have enough authorizations, it should work...barring any further issues in it (which does not seem likely at the moment).

Try and get the authorization to view the list and take it from there...

gud luck

PJ

0 Kudos
117

OK, here is the thing. The abap program has many write statements, I want to see the output of the write statements. Is that displayed in a list, if so where can I find it. Am I looking in correct place ie SM37- SPOOL. Please let me know.

If am correct then I can go ask for authorization from Basis.

thanks

Sabrina.

0 Kudos
117

yes

for reports that are executed in background and produce a list using write statements, the output can be viewed in SPOOL in SM37.

regards,

PJ

0 Kudos
117

how about if the job is not scheduled as a background job, where do I need to look?

0 Kudos
117

i think u will need to execute it again in foreground to view the output....but if u execute it and see the output in the morning....it must be running as a job scheduled in background?? if not then how is it scheduled??

0 Kudos
117

If you run it in the foreground and do a print against the list, and have "delete after output" print parameter not checked, you can find the list in SP01 under your user id.

Regards,

Rich Heilman

0 Kudos
117

Hi Priyank,

Can you please tell me what exactly SPOOL is used for, on a high level. I need to find out information about how we can get authorization.

thanks

Sabrina.