TBTCP

Transparent Table Temporary Data
71 Fields 6 CDS Views

Background Job Step Overview

TBTCP is an SAP database table in S/4HANA. Background Job Step Overview. It contains 71 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
hrpy_pcc_step_job view left_outer Step Recurrence Job Data
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 (71)

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
pdest SYPDEST Output Device
prcop SYPRCOP Copies
plist SYPLIST List Name
prtxt SYPRTXT Cover Page Text
primm SYPRIMM Print Now
prrel SYPRREL Delete After Output
prnew SYPRNEW New Spool Request
pexpi SYPEXPI Spool Retention
linct SYLINCT Page Length
linsz SYLINSZ List Width
paart SYPAART Format
prbig SYPRBIG Print Big Letters
prsap SYPRSAP SAP cover page
prrec SYPRREC Recipient
prabt SYPRABT Department
prber SYPRBER Authorization
prdsn SYPRDSN File Name
ptype SYPTYPE Print: Type of spool request
armod SYARMOD Storage Mode
footl SYFOOTL Footer
prchk SYCHECK Print: Check sum for print and archiving parameters
sap_object SYARC_SAP_OBJECT Object Type
ar_object SYARC_AR_OBJECT Document Type
archiv_id SYARC_ARCHIV_ID Archive ID
doc_type SYARC_DOC_TYPE Document Type
rpc_host SYARC_RPC_HOST RPC Host
rpc_servic SYARC_RPC_SERVIC RPC service/RFC dest
interface SYARC_INTERFACE Connection Name
mandant SYARC_MANDANT Client
report SYARC_REPORT Report Name
info SYARC_INFO Info.
arctext SYARC_ARCTEXT Archiving Parameter: Text Information Field
datum SYARC_DATUM Storage Date (ext.)
arcuser SYARC_ARCUSER Processors
printer SYARC_PRINTER Archiving Parameter: Target Output Device
formular SYARC_FORMULAR Archiving Parameter: Output Format
archivpath SYARC_ARCHIVPATH Archive Path
protokoll SYARC_PROTOKOLL Log
version SYARC_VERSION Version No.
acheck SYARC_CHECK Archiving Parameter: Check Total
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.

-- Background Job Step Overview
-- 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]
    PDEST,       -- Output Device [SYPDEST]
    PRCOP,       -- Copies [SYPRCOP]
    PLIST,       -- List Name [SYPLIST]
    PRTXT,       -- Cover Page Text [SYPRTXT]
    PRIMM,       -- Print Now [SYPRIMM]
    PRREL,       -- Delete After Output [SYPRREL]
    PRNEW,       -- New Spool Request [SYPRNEW]
    PEXPI,       -- Spool Retention [SYPEXPI]
    LINCT,       -- Page Length [SYLINCT]
    LINSZ,       -- List Width [SYLINSZ]
    PAART,       -- Format [SYPAART]
    PRBIG,       -- Print Big Letters [SYPRBIG]
    PRSAP,       -- SAP cover page [SYPRSAP]
    PRREC,       -- Recipient [SYPRREC]
    PRABT,       -- Department [SYPRABT]
    PRBER,       -- Authorization [SYPRBER]
    PRDSN,       -- File Name [SYPRDSN]
    PTYPE,       -- Print: Type of spool request [SYPTYPE]
    ARMOD,       -- Storage Mode [SYARMOD]
    FOOTL,       -- Footer [SYFOOTL]
    PRCHK,       -- Print: Check sum for print and archiving parameters [SYCHECK]
    SAP_OBJECT,  -- Object Type [SYARC_SAP_OBJECT]
    AR_OBJECT,   -- Document Type [SYARC_AR_OBJECT]
    ARCHIV_ID,   -- Archive ID [SYARC_ARCHIV_ID]
    DOC_TYPE,    -- Document Type [SYARC_DOC_TYPE]
    RPC_HOST,    -- RPC Host [SYARC_RPC_HOST]
    RPC_SERVIC,  -- RPC service/RFC dest [SYARC_RPC_SERVIC]
    INTERFACE,   -- Connection Name [SYARC_INTERFACE]
    MANDANT,     -- Client [SYARC_MANDANT]
    REPORT,      -- Report Name [SYARC_REPORT]
    INFO,        -- Info. [SYARC_INFO]
    ARCTEXT,     -- Archiving Parameter: Text Information Field [SYARC_ARCTEXT]
    DATUM,       -- Storage Date (ext.) [SYARC_DATUM]
    ARCUSER,     -- Processors [SYARC_ARCUSER]
    PRINTER,     -- Archiving Parameter: Target Output Device [SYARC_PRINTER]
    FORMULAR,    -- Archiving Parameter: Output Format [SYARC_FORMULAR]
    ARCHIVPATH,  -- Archive Path [SYARC_ARCHIVPATH]
    PROTOKOLL,   -- Log [SYARC_PROTOKOLL]
    VERSION,     -- Version No. [SYARC_VERSION]
    ACHECK,      -- Archiving Parameter: Check Total [SYARC_CHECK]
    PRIPARKEY,   -- Key [SYPRKEY]
    CONVID,      -- Conversation ID [GWY_CONVID]
    PRIMARY KEY (JOBNAME, JOBCOUNT, STEPCOUNT)
);

Learn More