How to find the data updated by a spool request no?

[Former Member]

Hi friends,

I have a request to fetch the data's updated using back round job scheduling on a regular basis.

A spool number is generated for every update.

So pl do help me with how to find the line item behind a spool number.

Thanks and regards,

Vinodh

[atul_mohanty]

Hi Vinodh -

Your query is not very clear. Does the spool contains the log of what is being updated ?

Regards,

Atul Mohanty

[Former Member]

yes Atul, it does.

I have been asked to check the material serial no which has no customer serial no and update it using background job.

[atul_mohanty]

If you have all the details in the spool log, then you can read the spool.

Use Function module 'RSPO_RETURN_ABAP_SPOOLJOB' for that.

Example-

     CALL FUNCTION 'RSPO_RETURN_ABAP_SPOOLJOB'

        EXPORTING

          rqident              = <spoolno>

        TABLES

          buffer               = <i_spool>

        EXCEPTIONS

          no_such_job          = 1

          not_abap_list        = 2

          job_contains_no_data = 3

          selection_empty      = 4

          no_permission        = 5

          can_not_access       = 6

          read_error           = 7

          OTHERS               = 8.

Here <spoolno> is the spool you want to read and <i_spool> is the internal table which will have the details of log.

To track the spool no for back ground job there are two table TBTCO, TBTCP you can use them as well.

Let us know, if it helps.

Regards,

Atul Mohanty

[Former Member]

Will get back to u after trying.

Thank you

[thanga_prakash]

Hello Vinodh,

If you want to read the SPOOL of the job, try using the below function module.

And you can read the spool using the function module "Y_SCO_GET_SPOOL_DATA_TAB_6X".

There are lot more function modules, please try with it

Regards,

Thanga

[Former Member]

Will get back to u after trying.

Thank you