TC37A

Transparent Table Customizing Table
14 Fields 1 CDS Views

Shift definition

TC37A is an SAP database table in S/4HANA. Shift definition. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ShiftDefinition view from BASIC Shift Definition Code

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY schgrup schgrup Shift Grouping
KEY kaptprog kaptprog Shift Definition
KEY endda endda End Date
begda begda Start Date
begzt kapbegzeit Start Time
endzt kapendzeit End Time
einzt kapeinzt Operating Durn
paplan pauplan Break Schedule
kw_profil kw_profil Pick.waves prfl
motpr motpr DWS grouping
tprog tprog Daily WS
varia varia DWS variant
hrendda endda End Date

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 definition
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TC37A (
    MANDT,      -- Client [mandt]
    SCHGRUP,    -- Shift Grouping [schgrup]
    KAPTPROG,   -- Shift Definition [kaptprog]
    ENDDA,      -- End Date [endda]
    BEGDA,      -- Start Date [begda]
    BEGZT,      -- Start Time [kapbegzeit]
    ENDZT,      -- End Time [kapendzeit]
    EINZT,      -- Operating Durn [kapeinzt]
    PAPLAN,     -- Break Schedule [pauplan]
    KW_PROFIL,  -- Pick.waves prfl [kw_profil]
    MOTPR,      -- DWS grouping [motpr]
    TPROG,      -- Daily WS [tprog]
    VARIA,      -- DWS variant [varia]
    HRENDDA,    -- End Date [endda]
    PRIMARY KEY (MANDT, SCHGRUP, KAPTPROG, ENDDA)
);

Learn More