TCGTPLREL

Transparent Table Application Table
28 Fields 1 CDS Views

Inheritance Relationships

TCGTPLREL is an SAP database table in S/4HANA. Inheritance Relationships. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecInheritanceRelationship view from BASIC Specification Inheritance Relationship

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY recn ESERECN Record number
KEY actn ESEACTN Change State
valfr ESEVALFR Valid From
valto ESEVALTO Valid To
aennr ESEAENNR Change number
delflg ESEDELFLG Deletion Ind.
parkflg ESEPARKFLG Inactive
crdat ESECRDAT Created on
crnam ESECRNAM Created by
upddat ESEUPDDAT Changed On
updnam ESEUPDNAM Last changed by
srsid ESESRSID Data Origin
ownid ESEVENDRID Data Provider
recnroot ESERECN Record number
flg_srcdest_req ESEFLG_SRCDEST_REQ Request
apprv_stat ESEAPPRV_STAT Approval status
cons_stat ESECONS_STAT Status
flg_inh ESEFLG_INH Inher. inactive
job_req_tim ESEJOB_REQ_TIM Time
job_req_dat ESEJOB_REQ_DAT Date
flg_subcpy ESEFLG_SUBCPY Relevancy
recnroot_src ESERECN Record number
recnroot_dst ESERECN Record number
recn_tplh ESERECN Record number
esntflg ESEESNTFLG Relevant
crtmstmp TIMESTAMPL Time Stamp
updtmstmp TIMESTAMPL Time Stamp

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 Relationships
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCGTPLREL (
    MANDT,            -- Client [MANDT]
    RECN,             -- Record number [ESERECN]
    ACTN,             -- Change State [ESEACTN]
    VALFR,            -- Valid From [ESEVALFR]
    VALTO,            -- Valid To [ESEVALTO]
    AENNR,            -- Change number [ESEAENNR]
    DELFLG,           -- Deletion Ind. [ESEDELFLG]
    PARKFLG,          -- Inactive [ESEPARKFLG]
    CRDAT,            -- Created on [ESECRDAT]
    CRNAM,            -- Created by [ESECRNAM]
    UPDDAT,           -- Changed On [ESEUPDDAT]
    UPDNAM,           -- Last changed by [ESEUPDNAM]
    SRSID,            -- Data Origin [ESESRSID]
    OWNID,            -- Data Provider [ESEVENDRID]
    RECNROOT,         -- Record number [ESERECN]
    FLG_SRCDEST_REQ,  -- Request [ESEFLG_SRCDEST_REQ]
    APPRV_STAT,       -- Approval status [ESEAPPRV_STAT]
    CONS_STAT,        -- Status [ESECONS_STAT]
    FLG_INH,          -- Inher. inactive [ESEFLG_INH]
    JOB_REQ_TIM,      -- Time [ESEJOB_REQ_TIM]
    JOB_REQ_DAT,      -- Date [ESEJOB_REQ_DAT]
    FLG_SUBCPY,       -- Relevancy [ESEFLG_SUBCPY]
    RECNROOT_SRC,     -- Record number [ESERECN]
    RECNROOT_DST,     -- Record number [ESERECN]
    RECN_TPLH,        -- Record number [ESERECN]
    ESNTFLG,          -- Relevant [ESEESNTFLG]
    CRTMSTMP,         -- Time Stamp [TIMESTAMPL]
    UPDTMSTMP,        -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, RECN, ACTN)
);

Learn More