TC38A

Transparent Table Customizing Table
11 Fields 2 CDS Views

Shift sequence

TC38A is an SAP database table in S/4HANA. Shift sequence. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MassMaintCapShiftSequence view_entity from BASIC Shift Sequence
I_ShiftNumber view from BASIC Shift Number

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY schgrup SCHGRUP Shift Grouping
KEY sprog SCHPROG Shift Sequence
KEY schnr SCHICHTNR Capacity Shift
tprog1 KAPTPROG Shift Definition
tprog2 KAPTPROG Shift Definition
tprog3 KAPTPROG Shift Definition
tprog4 KAPTPROG Shift Definition
tprog5 KAPTPROG Shift Definition
tprog6 KAPTPROG Shift Definition
tprog7 KAPTPROG Shift Definition

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.

-- Shift sequence
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TC38A (
    MANDT,    -- Client [MANDT]
    SCHGRUP,  -- Shift Grouping [SCHGRUP]
    SPROG,    -- Shift Sequence [SCHPROG]
    SCHNR,    -- Capacity Shift [SCHICHTNR]
    TPROG1,   -- Shift Definition [KAPTPROG]
    TPROG2,   -- Shift Definition [KAPTPROG]
    TPROG3,   -- Shift Definition [KAPTPROG]
    TPROG4,   -- Shift Definition [KAPTPROG]
    TPROG5,   -- Shift Definition [KAPTPROG]
    TPROG6,   -- Shift Definition [KAPTPROG]
    TPROG7,   -- Shift Definition [KAPTPROG]
    PRIMARY KEY (MANDT, SCHGRUP, SPROG, SCHNR)
);

Learn More