ESTRI

Transparent Table Application Table

Identifier (Numbers, Names, Chemical Formulas)

ESTRI is an SAP database table in S/4HANA. Identifier (Numbers, Names, Chemical Formulas). It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecIdentifier view from BASIC Specification Identifier

Fields (16)

KeyField Data ElementDescription DomainTypeLength
idtype eseidtype ID Category
idcat eseidcat ID Type
langu eselangu Language
ident eseident Identifier
identnm eseidentnm Normed ID
ltxtflg eseltxtflg Long text
formatflg eseformatflg Formatted
ord eseord Sort Order
flg_inhsrc eseboole Truth Value
flg_inhovr eseboole Truth Value
flg_inhexcl eseboole Truth Value
recn_tplh eserecn Record number
recntri_src eserecn Record number
recntri_orig eserecn Record number
recnroot_orig eserecn Record number
tpl_ord eseord Sort Order

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.

-- Identifier (Numbers, Names, Chemical Formulas)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESTRI (
    IDTYPE,         -- ID Category [eseidtype]
    IDCAT,          -- ID Type [eseidcat]
    LANGU,          -- Language [eselangu]
    IDENT,          -- Identifier [eseident]
    IDENTNM,        -- Normed ID [eseidentnm]
    LTXTFLG,        -- Long text [eseltxtflg]
    FORMATFLG,      -- Formatted [eseformatflg]
    ORD,            -- Sort Order [eseord]
    FLG_INHSRC,     -- Truth Value [eseboole]
    FLG_INHOVR,     -- Truth Value [eseboole]
    FLG_INHEXCL,    -- Truth Value [eseboole]
    RECN_TPLH,      -- Record number [eserecn]
    RECNTRI_SRC,    -- Record number [eserecn]
    RECNTRI_ORIG,   -- Record number [eserecn]
    RECNROOT_ORIG,  -- Record number [eserecn]
    TPL_ORD         -- Sort Order [eseord]
);