TBTCO

Transparent Table Temporary Data
58 Fields 29 CDS Views

Job Status Overview Table

TBTCO is an SAP database table in S/4HANA. Job Status Overview Table. It contains 58 fields. 29 CDS views read from this table.

CDS Views using this table (29)

ViewTypeJoinVDMDescription
/APE/I_ApplProcgEngnBckgndJob view_entity from BASIC Background Job
AJM_METADATA_INFO view from AJM: metadata info to central system
AJM_METADATA_INIT view inner AJM : Join init to central system
APJ_V_JOB_RUN_AB_FIN_ENDDATE view inner All aborted or finished application jobs
Apj_V_Job_Run_Aborted_Finished view inner All aborted or finished application jobs
APJ_V_JOB_RUN_OVERVIEW view inner Job overview
CNV_2010C_JOB_STATUS view inner Get job status of background activity
dd_chk_act_health_job view_entity from
DHADM_MON_AccessPlanJobsBase view_entity left_outer Access Plan Jobs
DHADM_MON_Observer_Job view_entity from Observer Queue View Entity
FINS_MP_PACKAGE view left_outer Mass packages of project
hrpy_pcc_step_job view left_outer Step Recurrence Job Data
I_APJ_JOB_USR_OVERVIEW view_entity inner Application Job Users Overview
I_AprvBkPaytBatchInBckgndJob view_entity inner COMPOSITE Payment Batch In Background Job
I_CAMassRunJob view_entity from COMPOSITE Mass Run Job Overview
I_OrganizationalChangeActivity view left_outer BASIC Organizational Change Activity
I_RFM_OrdFlfmtApplJobHdr view inner BASIC Ord Flfmt Appl Job Hdr
I_SLT_MasterJobStatus view from BASIC SLT Master Job Status
I_SrvcPrtsMassProcJobStatus view_entity from BASIC Service Parts Mass Process Job Status
IUUC_DHADM_Mon_AccessPlanJobsJ view_entity left_outer Access Plan Jobs
P_AppJobStatus view inner CONSUMPTION Application Job Status
P_Arbankstatementjob view inner COMPOSITE
P_JOB_Overview_Analytics view inner BASIC
P_JobStatus view from BASIC
P_POCntrlAnlytsFailedJob view inner BASIC
P_SBTI_APJ_PARAMETERS_DYNAMIC view inner APJ Params with dynamic dates conversion
P_SLT_MaxMasterJobReleaseDate view from BASIC
P_SLT_MaxMasterJobReleaseTime view from BASIC
SBTC_V_PREDECESSORS view inner Predecessor jobs

Fields (58)

KeyField Data ElementDescription DomainTypeLength
KEY jobname BTCJOB Job Name
KEY jobcount BTCJOBCNT Job No.
jobgroup BTCJOBGRP Job group
intreport BTCREP Report
stepcount BTCSTEPCNT Step no.
sdlstrtdt BTCSDATE Start Date
sdlstrttm BTCSTIME Start Time
btcsystem BTCTGTSYS Tgt System for Job
sdldate BTCSDLDATE Schedule date
sdltime BTCSDLTIME Schedule date
sdluname BTCSDLNM Job scheduler
lastchdate BTCJCHDATE Last job change
lastchtime BTCJCHTIME Last job change
lastchname BTCJCHNM Last job change by
reldate BTCRELDT Scheduled release
reltime BTCRELTM Scheduled release
reluname BTCRELNM User that released scheduled batch job
strtdate BTCXDATE Execution Date
strttime BTCXTIME Execution Date
enddate BTCXDATE Execution Date
endtime BTCXTIME Execution Date
prdmins BTCPMIN Periodic job
prdhours BTCPHOUR Periodic job
prddays BTCPDAY Periodic job
prdweeks BTCPWEEK Periodic job
prdmonths BTCPMNTH Periodic job
periodic BTCPFLAG Periodic job
delanfrep BTCDELFLAG Delete Job
emergmode BTCEFLAG Emergency
status BTCSTATUS Job status
newflag BTCNEWFLAG New job ID
authcknam BTCAUTHNAM Background User
authckman BTCAUTHMAN Authorization check
succnum BTCSNUM Successor job
prednum BTCPNUM Previous job
joblog RSTSONAME Name
laststrtdt BTCLSDATE Latest Date
laststrttm BTCLSTIME Latest Time
wpnumber BTCWPNO Work process no
wpprocid BTCWPPID Work process ID
eventid BTCEVENTID Event
eventparm BTCEVTPARM Bkgrd event param.
btcsysreax BTCTGTSYS Tgt System for Job
jobclass BTCJOBCLAS Job class
priority BTCJOBPRIO Job priority
eventcount BTCEVTCNT Event number
checkstat BTCCKSTAT Job status check
calendarid BTCCALID Calendar
prdbehav BTCPRDBHV Behavior
execserver BTCSRVNAME Server
eomcorrect BTCEOMCORR Correction job exec.
calcorrect BTCEOMCORR Correction job exec.
reaxserver BTCSRVNAME Server
reclogsys LOGSYS Logical system
recobjtype SWO_OBJTYP Object Type
recobjkey SWO_TYPEID Key
recdescrib SWO_DESCRB Describe flag
tgtsrvgrp BPSRVGRPN Server Group Name

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Job Status Overview Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBTCO (
    JOBNAME,     -- Job Name [BTCJOB]
    JOBCOUNT,    -- Job No. [BTCJOBCNT]
    JOBGROUP,    -- Job group [BTCJOBGRP]
    INTREPORT,   -- Report [BTCREP]
    STEPCOUNT,   -- Step no. [BTCSTEPCNT]
    SDLSTRTDT,   -- Start Date [BTCSDATE]
    SDLSTRTTM,   -- Start Time [BTCSTIME]
    BTCSYSTEM,   -- Tgt System for Job [BTCTGTSYS]
    SDLDATE,     -- Schedule date [BTCSDLDATE]
    SDLTIME,     -- Schedule date [BTCSDLTIME]
    SDLUNAME,    -- Job scheduler [BTCSDLNM]
    LASTCHDATE,  -- Last job change [BTCJCHDATE]
    LASTCHTIME,  -- Last job change [BTCJCHTIME]
    LASTCHNAME,  -- Last job change by [BTCJCHNM]
    RELDATE,     -- Scheduled release [BTCRELDT]
    RELTIME,     -- Scheduled release [BTCRELTM]
    RELUNAME,    -- User that released scheduled batch job [BTCRELNM]
    STRTDATE,    -- Execution Date [BTCXDATE]
    STRTTIME,    -- Execution Date [BTCXTIME]
    ENDDATE,     -- Execution Date [BTCXDATE]
    ENDTIME,     -- Execution Date [BTCXTIME]
    PRDMINS,     -- Periodic job [BTCPMIN]
    PRDHOURS,    -- Periodic job [BTCPHOUR]
    PRDDAYS,     -- Periodic job [BTCPDAY]
    PRDWEEKS,    -- Periodic job [BTCPWEEK]
    PRDMONTHS,   -- Periodic job [BTCPMNTH]
    PERIODIC,    -- Periodic job [BTCPFLAG]
    DELANFREP,   -- Delete Job [BTCDELFLAG]
    EMERGMODE,   -- Emergency [BTCEFLAG]
    STATUS,      -- Job status [BTCSTATUS]
    NEWFLAG,     -- New job ID [BTCNEWFLAG]
    AUTHCKNAM,   -- Background User [BTCAUTHNAM]
    AUTHCKMAN,   -- Authorization check [BTCAUTHMAN]
    SUCCNUM,     -- Successor job [BTCSNUM]
    PREDNUM,     -- Previous job [BTCPNUM]
    JOBLOG,      -- Name [RSTSONAME]
    LASTSTRTDT,  -- Latest Date [BTCLSDATE]
    LASTSTRTTM,  -- Latest Time [BTCLSTIME]
    WPNUMBER,    -- Work process no [BTCWPNO]
    WPPROCID,    -- Work process ID [BTCWPPID]
    EVENTID,     -- Event [BTCEVENTID]
    EVENTPARM,   -- Bkgrd event param. [BTCEVTPARM]
    BTCSYSREAX,  -- Tgt System for Job [BTCTGTSYS]
    JOBCLASS,    -- Job class [BTCJOBCLAS]
    PRIORITY,    -- Job priority [BTCJOBPRIO]
    EVENTCOUNT,  -- Event number [BTCEVTCNT]
    CHECKSTAT,   -- Job status check [BTCCKSTAT]
    CALENDARID,  -- Calendar [BTCCALID]
    PRDBEHAV,    -- Behavior [BTCPRDBHV]
    EXECSERVER,  -- Server [BTCSRVNAME]
    EOMCORRECT,  -- Correction job exec. [BTCEOMCORR]
    CALCORRECT,  -- Correction job exec. [BTCEOMCORR]
    REAXSERVER,  -- Server [BTCSRVNAME]
    RECLOGSYS,   -- Logical system [LOGSYS]
    RECOBJTYPE,  -- Object Type [SWO_OBJTYP]
    RECOBJKEY,   -- Key [SWO_TYPEID]
    RECDESCRIB,  -- Describe flag [SWO_DESCRB]
    TGTSRVGRP,   -- Server Group Name [BPSRVGRPN]
    PRIMARY KEY (JOBNAME, JOBCOUNT)
);

Learn More