TC37T

Transparent Table Customizing Table

Texts for shift definitions

TC37T is an SAP database table in S/4HANA. Texts for shift definitions. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ShiftDefinitionText view from BASIC Shift Definition - Text

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY schgrup SCHGRUP Shift Grouping
KEY kaptprog KAPTPROG Shift Definition
ktext SCHTXT Shift Definition Txt

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.

-- Texts for shift definitions
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TC37T (
    MANDT,     -- Client [MANDT]
    SPRAS,     -- Language [SPRAS]
    SCHGRUP,   -- Shift Grouping [SCHGRUP]
    KAPTPROG,  -- Shift Definition [KAPTPROG]
    KTEXT,     -- Shift Definition Txt [SCHTXT]
    PRIMARY KEY (MANDT, SPRAS, SCHGRUP, KAPTPROG)
);