TCG11

Transparent Table Customizing (protected)
18 Fields 1 CDS Views

EHS: Value Assignment Type

TCG11 is an SAP database table in S/4HANA. EHS: Value Assignment Type. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecValAssgmtType view from BASIC Specification Value Assignment Type

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY estcat ESEESTCAT Val. Asst Type
esttype ESEESTTYPE Value Ass. Cat.
rem ESEREM Note
cls ESECLSVA Class no. (cha)
clspos ESECLSVP Class no.(item)
eccoflg ESEECCOFLG VA Copy Active
ecinflg ESEECINFLG New VA Active
ecupflg ESEECUPFLG Change active
useprof ESEUSEPROF Usage profile
idlid ESEIDLID ID listing
clvanam ESECLVANAM Class (ValAss.)
clvpnam ESECLVPNAM (obsolete)
useprdef ESEUSEPRDEF Profile overridden
entryf ESEENTRYF Screen function
flgsinst ESEFLGSINST Single instance
flgint ESEFLGINT Int. VA type
flginv EHS_ESEFLGINV Invert Axes

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.

-- EHS: Value Assignment Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCG11 (
    MANDT,     -- Client [MANDT]
    ESTCAT,    -- Val. Asst Type [ESEESTCAT]
    ESTTYPE,   -- Value Ass. Cat. [ESEESTTYPE]
    REM,       -- Note [ESEREM]
    CLS,       -- Class no. (cha) [ESECLSVA]
    CLSPOS,    -- Class no.(item) [ESECLSVP]
    ECCOFLG,   -- VA Copy Active [ESEECCOFLG]
    ECINFLG,   -- New VA Active [ESEECINFLG]
    ECUPFLG,   -- Change active [ESEECUPFLG]
    USEPROF,   -- Usage profile [ESEUSEPROF]
    IDLID,     -- ID listing [ESEIDLID]
    CLVANAM,   -- Class (ValAss.) [ESECLVANAM]
    CLVPNAM,   -- (obsolete) [ESECLVPNAM]
    USEPRDEF,  -- Profile overridden [ESEUSEPRDEF]
    ENTRYF,    -- Screen function [ESEENTRYF]
    FLGSINST,  -- Single instance [ESEFLGSINST]
    FLGINT,    -- Int. VA type [ESEFLGINT]
    FLGINV,    -- Invert Axes [EHS_ESEFLGINV]
    PRIMARY KEY (MANDT, ESTCAT)
);

Learn More