TBTC_SPOOLID

Transparent Table Temporary Data
6 Fields 3 CDS Views

Background Processing Spool IDs Table

TBTC_SPOOLID is an SAP database table in S/4HANA. Background Processing Spool IDs Table. It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
APJ_V_VISIBLE_SPOOLS view from Spool exists check
HRPY_PCC_spool view from Spool Data
SAPJ_V_SPOOLREQS view inner spool requests created by application jobs

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY jobname BTCJOB Job Name
KEY jobcount BTCJOBCNT Job No.
KEY stepcount BTCSTEPCNT Step no.
KEY spoolid BTCLISTID List ID
spoolcount INT4 INT4
recycled BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)

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 Processing Spool IDs Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBTC_SPOOLID (
    JOBNAME,     -- Job Name [BTCJOB]
    JOBCOUNT,    -- Job No. [BTCJOBCNT]
    STEPCOUNT,   -- Step no. [BTCSTEPCNT]
    SPOOLID,     -- List ID [BTCLISTID]
    SPOOLCOUNT,  -- INT4 [INT4]
    RECYCLED,    -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PRIMARY KEY (JOBNAME, JOBCOUNT, STEPCOUNT, SPOOLID)
);

Learn More