Easy getting Spool-ID

[Former Member]

Dear Experts,

I have the name of the job an I try to get the Spool-ID like this (but I need the newest one in the list):

DATA: v_spoolid  type SYSPONO.

DATA: v_spoolid_msg  type SYSPONO.

DATA: v_job_name TYPE btcjob.

DATA: ta_tbtcp TYPE STANDARD TABLE OF tbtcp,

       wa_tbtcp LIKE LINE OF ta_tbtcp.

v_job_name = 'TEST'.

SELECT listident

        INTO CORRESPONDING FIELDS OF TABLE ta_tbtcp

   FROM tbtcp

        WHERE tbtcp~jobname = v_job_name.

v_spoolid_msg = wa_tbtcp.

What do I do wrong?

BR

Denis

[Former Member]

Hi Denis,

At least your abap code have some problems.

v_job_name = 'TEST'.

SELECT listident

        INTO CORRESPONDING FIELDS OF TABLE ta_tbtcp

   FROM tbtcp

        WHERE jobname = v_job_name.

SORT ta_tbtcp BY JOBCOUNT DESCENDING.

READ TABLE ta_tbtcp INTO wa_tbtcp INDEX 1.

v_spoolid_msg = wa_tbtcp.

If you can`t extract data what you wanted, try this dbtable 'TBTC_SPOOLID'.

regards,

Archer