topic Re: Easy getting Spool-ID in Application Development and Automation Discussions

Easy getting Spool-ID

Former Member — Tue, 02 Sep 2014 10:12:27 GMT

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

Re: Easy getting Spool-ID

Former Member — Tue, 02 Sep 2014 10:52:54 GMT

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