TC21

Transparent Table Customizing Table
42 Fields 1 CDS Views

Standard value key

TC21 is an SAP database table in S/4HANA. Standard value key. It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StandardWorkFmlaParamGroup view from BASIC Standard Work Formula Parameter Group

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vgwts vorgschl Std Value Key
par01 paramid Parameter
bde01 bdenr Inc. wages ind.
par02 paramid Parameter
bde02 bdenr Inc. wages ind.
par03 paramid Parameter
bde03 bdenr Inc. wages ind.
par04 paramid Parameter
bde04 bdenr Inc. wages ind.
par05 paramid Parameter
bde05 bdenr Inc. wages ind.
par06 paramid Parameter
bde06 bdenr Inc. wages ind.
parn1 paramid Parameter
gener cr_gener Generate
sakl_01 sa_klasse Rec. type group
rkrcfr_01 ap_formel Formula Key
rkrczt_01 rkrecn_zt RetroCalculTime
rkmlzt_01 rkmeld_zt ComplConfirTime
sakl_02 sa_klasse Rec. type group
rkrcfr_02 ap_formel Formula Key
rkrczt_02 rkrecn_zt RetroCalculTime
rkmlzt_02 rkmeld_zt ComplConfirTime
sakl_03 sa_klasse Rec. type group
rkrcfr_03 ap_formel Formula Key
rkrczt_03 rkrecn_zt RetroCalculTime
rkmlzt_03 rkmeld_zt ComplConfirTime
sakl_04 sa_klasse Rec. type group
rkrcfr_04 ap_formel Formula Key
rkrczt_04 rkrecn_zt RetroCalculTime
rkmlzt_04 rkmeld_zt ComplConfirTime
sakl_05 sa_klasse Rec. type group
rkrcfr_05 ap_formel Formula Key
rkrczt_05 rkrecn_zt RetroCalculTime
rkmlzt_05 rkmeld_zt ComplConfirTime
sakl_06 sa_klasse Rec. type group
rkrcfr_06 ap_formel Formula Key
rkrczt_06 rkrecn_zt RetroCalculTime
rkmlzt_06 rkmeld_zt ComplConfirTime
bdep1 bdenr Inc. wages ind.
sakl_p1 sa_klasse Rec. type group

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.

-- Standard value key
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TC21 (
    MANDT,      -- Client [mandt]
    VGWTS,      -- Std Value Key [vorgschl]
    PAR01,      -- Parameter [paramid]
    BDE01,      -- Inc. wages ind. [bdenr]
    PAR02,      -- Parameter [paramid]
    BDE02,      -- Inc. wages ind. [bdenr]
    PAR03,      -- Parameter [paramid]
    BDE03,      -- Inc. wages ind. [bdenr]
    PAR04,      -- Parameter [paramid]
    BDE04,      -- Inc. wages ind. [bdenr]
    PAR05,      -- Parameter [paramid]
    BDE05,      -- Inc. wages ind. [bdenr]
    PAR06,      -- Parameter [paramid]
    BDE06,      -- Inc. wages ind. [bdenr]
    PARN1,      -- Parameter [paramid]
    GENER,      -- Generate [cr_gener]
    SAKL_01,    -- Rec. type group [sa_klasse]
    RKRCFR_01,  -- Formula Key [ap_formel]
    RKRCZT_01,  -- RetroCalculTime [rkrecn_zt]
    RKMLZT_01,  -- ComplConfirTime [rkmeld_zt]
    SAKL_02,    -- Rec. type group [sa_klasse]
    RKRCFR_02,  -- Formula Key [ap_formel]
    RKRCZT_02,  -- RetroCalculTime [rkrecn_zt]
    RKMLZT_02,  -- ComplConfirTime [rkmeld_zt]
    SAKL_03,    -- Rec. type group [sa_klasse]
    RKRCFR_03,  -- Formula Key [ap_formel]
    RKRCZT_03,  -- RetroCalculTime [rkrecn_zt]
    RKMLZT_03,  -- ComplConfirTime [rkmeld_zt]
    SAKL_04,    -- Rec. type group [sa_klasse]
    RKRCFR_04,  -- Formula Key [ap_formel]
    RKRCZT_04,  -- RetroCalculTime [rkrecn_zt]
    RKMLZT_04,  -- ComplConfirTime [rkmeld_zt]
    SAKL_05,    -- Rec. type group [sa_klasse]
    RKRCFR_05,  -- Formula Key [ap_formel]
    RKRCZT_05,  -- RetroCalculTime [rkrecn_zt]
    RKMLZT_05,  -- ComplConfirTime [rkmeld_zt]
    SAKL_06,    -- Rec. type group [sa_klasse]
    RKRCFR_06,  -- Formula Key [ap_formel]
    RKRCZT_06,  -- RetroCalculTime [rkrecn_zt]
    RKMLZT_06,  -- ComplConfirTime [rkmeld_zt]
    BDEP1,      -- Inc. wages ind. [bdenr]
    SAKL_P1,    -- Rec. type group [sa_klasse]
    PRIMARY KEY (MANDT, VGWTS)
);

Learn More