TBTCO

Job-Zustandsübersichtstabelle

1 SELECT

1.1 z_sysp_sap_adapter.abap

9476  SELECT j~jobcount 
9477  j~jobname 
9478  j~jobgroup 
9479  s~stepcount 
9480  s~progname 
9481  j~lastchname 
9482  j~periodic 
9483  j~strtdate 
9484  j~strttime 
9485  j~strtdate 
9486  j~strttime 
9487  j~prdmonths 
9488  j~prdweeks 
9489  j~prddays 
9490  j~prdhours 
9491  j~prdmins 
9492  j~btcsystem 
9493  j~status 
9494  j~succnum 
9495  j~prednum 
9496  j~jobclass 
9497  j~priority 
9498  e~eventid 
9499    FROM tbtco AS j 
9500    INNER JOIN tbtcp AS s 
9501    ON j~jobname = s~jobname AND j~jobcount = s~jobcount 
9502    LEFT JOIN btcevtjob AS e ON j~jobname = e~jobname AND j~jobcount = e~jobcount 
9503    INTO CORRESPONDING FIELDS OF TABLE it_datatab 
9504    WHERE j~status = 'S' OR j~status = 'Y' OR j~status = 'Z' OR j~status = 'R' 
9505    ORDER BY j~jobname DESCENDING.

z_sysp_sap_adapter.abap:9476