Possible values for Status in TBTCO
SELECT SAPSR3.TBTCP."JOBNAME", SAPSR3.TBTCP."JOBCOUNT", SAPSR3.TBTCP."STEPCOUNT", SAPSR3.TBTCP."PROGNAME", SAPSR3.TBTCP."VARIANT", SAPSR3.TBTCP."STATUS", SAPSR3.TBTCP."EXITCODE", SAPSR3.TBTCO."LASTCHDATE", SAPSR3.TBTCO."LASTCHTIME", SAPSR3.TBTCO."LASTCHNAME", SAPSR3.TBTCO."RELDATE", SAPSR3.TBTCO."RELTIME", SAPSR3.TBTCO."RELUNAME", TO_CHAR(TO_DATE(SAPSR3.TBTCO."SDLSTRTDT", 'YYYYMMDD'),'DD.MM.YYYY') AS SDLSTRTDT_JOB_PLAND_ST_DT, TO_CHAR(TO_DATE(SAPSR3.TBTCO."SDLSTRTTM", 'HH24MISS'),'HH24:MI:SS') AS SDLSTRTTM_JOB_PLAND_ST_TM, TO_CHAR(TO_DATE(SAPSR3.TBTCO."STRTDATE", 'YYYYMMDD'),'DD.MM.YYYY') AS STRTDATE_JOB_REAL_ST_DT, TO_CHAR(TO_DATE(SAPSR3.TBTCO."STRTTIME", 'HH24MISS'),'HH24:MI:SS') AS STRTTIME_JOB_REAL_ST_TM, TO_CHAR(TO_DATE(SAPSR3.TBTCP."SDLDATE", 'YYYYMMDD'),'DD.MM.YYYY') AS SDLDATE_STE_PLAND_ST_DT, TO_CHAR(TO_DATE(SAPSR3.TBTCP."SDLTIME", 'HH24MISS'),'HH24:MI:SS') AS SDLTIME_STE_PLAND_ST_TM, TO_CHAR(TO_DATE(SAPSR3.TBTCO."ENDDATE", 'YYYYMMDD'),'DD.MM.YYYY') AS ENDDATE_JOB_REAL_EN_DT, TO_CHAR(TO_DATE(SAPSR3.TBTCO."ENDTIME", 'HH24MISS'),'HH24:MI:SS') AS ENDTIME_JOB_REAL_EN_TM, SAPSR3.TBTCO."PERIODIC", SAPSR3.TBTCO."STATUS", SAPSR3.TBTCO."WPNUMBER", SAPSR3.TBTCO."WPPROCID", SAPSR3.TBTCO."JOBCLASS", SAPSR3.TBTCO."TGTSRVGRP", SAPSR3.TBTCO."NEWFLAG", SAPSR3.TBTCO."JOBCOUNT", SAPSR3.TBTCO."JOBNAME" FROM SAPSR3.TBTCP INNER JOIN SAPSR3.TBTCO ON SAPSR3.TBTCO."JOBCOUNT"=SAPSR3.TBTCP."JOBCOUNT" AND SAPSR3.TBTCO."JOBNAME"=SAPSR3.TBTCP."JOBNAME" WHERE SAPSR3.TBTCO."STATUS" = 'F';
Values for TBTCO-STATUS:
A - Cancelled
F - Completed
P - Scheduled
R - Active
S - Released
comments powered by Disqus