topic Re: Getting spool number after SUBMIT report statement in Application Development and Automation Discussions

Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:08:56 GMT

Hello Everyone,

Suppose there is a scenario, when 3 users are sharing same session and executing a program simultaneously.

In the program, the users are submitting a program to sap spool such that a spool no is generated.

and based on that spool no, the users read its log...

How will we identify that which spool no belongs to which particular session so that the the user will read its own loag and not the other person/'s log...

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:11:46 GMT

Hi,

The program can be submitted as a job which has a unique job number and accordingly spool number will be generated which can read.

See code e.g below:


DATA: number TYPE tbtcjob-jobcount, 
      name TYPE tbtcjob-jobname VALUE 'JOB_TEST', 
      print_parameters TYPE pri_params. 

... 

CALL FUNCTION 'JOB_OPEN' 
  EXPORTING 
    jobname          = name 
  IMPORTING 
    jobcount         = number 
  EXCEPTIONS 
    cant_create_job  = 1 
    invalid_job_data = 2 
    jobname_missing  = 3 
    OTHERS           = 4. 
IF sy-subrc = 0. 
  SUBMIT submitable TO SAP-SPOOL 
                    SPOOL PARAMETERS print_parameters 
                    WITHOUT SPOOL DYNPRO 
                    VIA JOB name NUMBER number 
                    AND RETURN. 
  IF sy-subrc = 0. 
    CALL FUNCTION 'JOB_CLOSE' 
      EXPORTING 
        jobcount             = number 
        jobname              = name 
        strtimmed            = 'X' 
      EXCEPTIONS 
        cant_start_immediate = 1 
        invalid_startdate    = 2 
        jobname_missing      = 3 
        job_close_failed     = 4 
        job_nosteps          = 5 
        job_notex            = 6 
        lock_failed          = 7 
        OTHERS               = 8. 
    IF sy-subrc <> 0. 
      ... 
    ENDIF. 
  ENDIF. 
ENDIF.

Hope it helps.

Regards,

Mansi.

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:21:59 GMT

Hey Thanks for quick Reply....

But my requirement is i cant submit the program as a Job.

because i am calling 3 programs in my Zprogram which are dependent on each other.

So i am calling 3 submit statements, each generating the spool number.

If i scheedule a job, then the other programs which are dependent on the first one wont be executed successfully.

Any other suggestion....

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:22:33 GMT

Each user can chech the same with 'Own spool requests' right ?Executed by their user id..

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:24:50 GMT

But the user id is same in all the cases.

The users are sharing sessions.

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:29:39 GMT

Go to sm37 and check the job is triggered there..if yes,go to push button -> step ..then you will be able top see all program names executed and corresponding spool numbers for each program.

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 05:38:38 GMT

I am not submitting my program as a job so no job is created in SM37.

Re: Getting spool number after SUBMIT report statement

former_member404244 — Thu, 26 May 2011 05:52:08 GMT

Hi,

I don't think this is a valid scenario.. as the persons are sahring same user id , and in SAP one user id will have one first and last name(bname). so always get one user name only.

one more thing we can do, not sure how much it is helpful.

create a custom table with the following fields

userid,firstname, lastname, username. the custom table should be updated for all the users who will be executing the program.

so for same user id , the first name and last name is same but we can have multiple usernames.Once it is done.

also in the program selection screen have one more field as USER (give F4 help getting data from custom table) and every user should enter his / her name . Now while you submit to spool , add the USER to the submit program.

Regards,

Nagaraj

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 06:07:16 GMT

Hi Suruchi,

if you're submitting the reports within a Z program, you can try to get the spool number right after submitting:


  SUBMIT (report)
    TO SAP-SPOOL ... "and so on.

  DATA: l_spool_c LIKE tsp01_sp0r-rqid_char.
  GET PARAMETER ID 'SPI' FIELD l_spool_c.
  " now l_spool_c contains the spool number

I hope it helps.

Kind regards,

Alvaro

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 06:11:43 GMT

Hi,

Try this one,

Once the user is executing the program just before the submit command store system time in some variable,

after the program creates a spool go to TSP01 table give the username and time of creation.

This will give them the spool req number pass this as a message or write this in output.

I think there will be slit difference in the time so that we can identify.

Submit your program in background.

Check if 1st program is finished and successfull then run the other 1.

You can use FM 'BP_JOB_STATUS_GET" to get the status.

Thanks,

Anmol.

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 09:18:16 GMT

Thanks for all the replies.. My problem has been resolved

Edited by: Suruchi Razdan on May 26, 2011 11:18 AM

Re: Getting spool number after SUBMIT report statement

SuhaSaha — Thu, 26 May 2011 09:54:42 GMT

My 2 cents ...

Although you're have marked Alvaro's solution as "Correct", but i have some apprehensions about it! If there is a case where you've spool creation simultaneously in different user sessions, can you rely on the GET PARAMETER? Since SPA/GPA are valid across all the user sessions, i think this solution can be dicey.

On the other hand, since you're SUBMIT'ting the program as BG job, you can query the table TBTCP for the field LISTIDENT (which stores the spool id for the BG job step) using JOBNAME & JOBCOUNT.

Let me know your comments.

BR,

Suhas

PS: Since you're SUBMIT'ting only one program in the Job, you can ignore the field STEPCOUNT !

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 09:59:05 GMT

May be you r right that i shudnt use Get Parameter,

but i asked my seniors and they said its ok to use Get parameter

I cant create job. Yuo can say its a requirement

Re: Getting spool number after SUBMIT report statement

former_member404244 — Thu, 26 May 2011 10:06:17 GMT

Hi Suruchi,

Suhas is correct and you won't get the desired result. Also even if you get the spool how will you know which user's spool.Are you giving the spool number in the output or checking SP01. as you have said the userid is shared.

Can you please let us know about this..

Regards,

Nagaraj

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 10:19:23 GMT

Actually as soon as the spool is generated i write statement

Get Parameter id SPI.....

whatever the spool number i get, i store it in my Ztable

and later on i can use it...

I dont know any other way...

Can you suggest me any alternative solution?

Re: Getting spool number after SUBMIT report statement

former_member404244 — Thu, 26 May 2011 10:25:45 GMT

Hi,

that should be 'OK' if you are storing.in ztable.. What is the structre of the ztable?

Regards,

Nagaraj

Re: Getting spool number after SUBMIT report statement

Former Member — Thu, 26 May 2011 10:52:33 GMT

Well it consists of spool numbers for each submit statement plus some job names.

Actually based n my reuirement i hav created it...

Edited by: Suruchi Razdan on May 26, 2011 12:52 PM