TBTCP

Transparent Table Temporary Data
31 Fields 6 CDS Views

Step-Uebersicht eines Batch-Jobs

TBTCP is an SAP database table in S/4HANA. Step-Uebersicht eines Batch-Jobs. It contains 31 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
AJM_METADATA_INFO view inner AJM: metadata info to central system
AJM_METADATA_INIT view inner AJM : Join init to central system
aps_iam_busr_app_job view inner Business User Application Jobs
P_SBTI_APJ_PARAMETERS view inner APJ Parameters
P_SBTI_APJ_PARAMETERS_DYNAMIC view inner APJ Params with dynamic dates conversion
XAJ_JOB_RUN_CHAIN view inner multistep application jobs

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY jobname btcjob Job Name
KEY jobcount btcjobcnt Job No.
KEY stepcount btcstepcnt Step no.
progname btcprog Report
progfromln btcsrcline Line number
progtoln btcsrcline Line number
sdldate btcsdldate Schedule date
sdltime btcsdltime Schedule date
sdluname btcsdlnm Job scheduler
variant btcvariant Variant
authcknam btcauthnam Background User
listident btclistid List ID
xpgpid btcxpgpid Program ID
xpgtgtsys btctgtsys Tgt System for Job
xpgrfcdest rfcdest Destination
xpgprog btcxpgpgm External program
xpgparams btcxpgpar Parameters
xpgflag btcsteptyp Step type
conncntl btcxpgcntl Control flag
stdincntl btcxpgcntl Control flag
stdoutcntl btcxpgcntl Control flag
stderrcntl btcxpgcntl Control flag
tracecntl btcxpgcntl Control flag
termcntl btcxpgcntl Control flag
status btcpstatus Status
exitcode btcxpgexit XPG exit code
language spras Language
extcmd sxpglogcmd Command name
opsystem syopsys Operating system
priparkey syprkey Key
convid gwy_convid Conversation ID

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.

-- Step-Uebersicht eines Batch-Jobs
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBTCP (
    JOBNAME,     -- Job Name [btcjob]
    JOBCOUNT,    -- Job No. [btcjobcnt]
    STEPCOUNT,   -- Step no. [btcstepcnt]
    PROGNAME,    -- Report [btcprog]
    PROGFROMLN,  -- Line number [btcsrcline]
    PROGTOLN,    -- Line number [btcsrcline]
    SDLDATE,     -- Schedule date [btcsdldate]
    SDLTIME,     -- Schedule date [btcsdltime]
    SDLUNAME,    -- Job scheduler [btcsdlnm]
    VARIANT,     -- Variant [btcvariant]
    AUTHCKNAM,   -- Background User [btcauthnam]
    LISTIDENT,   -- List ID [btclistid]
    XPGPID,      -- Program ID [btcxpgpid]
    XPGTGTSYS,   -- Tgt System for Job [btctgtsys]
    XPGRFCDEST,  -- Destination [rfcdest]
    XPGPROG,     -- External program [btcxpgpgm]
    XPGPARAMS,   -- Parameters [btcxpgpar]
    XPGFLAG,     -- Step type [btcsteptyp]
    CONNCNTL,    -- Control flag [btcxpgcntl]
    STDINCNTL,   -- Control flag [btcxpgcntl]
    STDOUTCNTL,  -- Control flag [btcxpgcntl]
    STDERRCNTL,  -- Control flag [btcxpgcntl]
    TRACECNTL,   -- Control flag [btcxpgcntl]
    TERMCNTL,    -- Control flag [btcxpgcntl]
    STATUS,      -- Status [btcpstatus]
    EXITCODE,    -- XPG exit code [btcxpgexit]
    LANGUAGE,    -- Language [spras]
    EXTCMD,      -- Command name [sxpglogcmd]
    OPSYSTEM,    -- Operating system [syopsys]
    PRIPARKEY,   -- Key [syprkey]
    CONVID,      -- Conversation ID [gwy_convid]
    PRIMARY KEY (JOBNAME, JOBCOUNT, STEPCOUNT)
);

Learn More