TCGTPLH

Transparent Table Application Table
20 Fields 1 CDS Views

Inheritance Template Header

TCGTPLH is an SAP database table in S/4HANA. Inheritance Template Header. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecInheritanceTemplateHdr view from BASIC Specification Inheritance Template Header

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY recn_grp ESERECN Record number
aennr ESEAENNR Change number
searchmode ESESEARCHMODE Search mode
valdat ESEDIAGVD Key date
valfr ESEDIAGVF From Date
valto ESEDIAGVT To Date
crdat ESECRDAT Created on
crnam ESECRNAM Created by
upddat ESEUPDDAT Changed On
updnam ESEUPDNAM Last changed by
objid ESEGRPOBJID Group entry
grpid ESEGRPID Group
ord ESEORD Sort Order
flg_dst_chng ESEFLG_DST_CHNG Trgt spec. changes
flg_inh_dsbl ESEFLG_INH_DISBL Deact.InhrRlshp
flg_inh_excl ESEFLG_INH_EXCL Exclusion
flg_all_prop ESEFLG_ALL_PROP All VA types
flg_all_ident ESEFLG_ALL_IDENT All identifiers
flg_all_usages ESEFLG_ALL_USAGES All usages

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.

-- Inheritance Template Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCGTPLH (
    MANDT,           -- Client [MANDT]
    RECN_GRP,        -- Record number [ESERECN]
    AENNR,           -- Change number [ESEAENNR]
    SEARCHMODE,      -- Search mode [ESESEARCHMODE]
    VALDAT,          -- Key date [ESEDIAGVD]
    VALFR,           -- From Date [ESEDIAGVF]
    VALTO,           -- To Date [ESEDIAGVT]
    CRDAT,           -- Created on [ESECRDAT]
    CRNAM,           -- Created by [ESECRNAM]
    UPDDAT,          -- Changed On [ESEUPDDAT]
    UPDNAM,          -- Last changed by [ESEUPDNAM]
    OBJID,           -- Group entry [ESEGRPOBJID]
    GRPID,           -- Group [ESEGRPID]
    ORD,             -- Sort Order [ESEORD]
    FLG_DST_CHNG,    -- Trgt spec. changes [ESEFLG_DST_CHNG]
    FLG_INH_DSBL,    -- Deact.InhrRlshp [ESEFLG_INH_DISBL]
    FLG_INH_EXCL,    -- Exclusion [ESEFLG_INH_EXCL]
    FLG_ALL_PROP,    -- All VA types [ESEFLG_ALL_PROP]
    FLG_ALL_IDENT,   -- All identifiers [ESEFLG_ALL_IDENT]
    FLG_ALL_USAGES,  -- All usages [ESEFLG_ALL_USAGES]
    PRIMARY KEY (MANDT, RECN_GRP)
);

Learn More