ESTRI

Transparent Table Application Table
35 Fields 1 CDS Views

Identifier (Numbers, Names, Chemical Formulas)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecIdentifier view from BASIC Specification Identifier

Fields (35)

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
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
dokar DOKAR Document Type
doknr DOKNR Document
dokvr DOKVR Doc. Version
doktl DOKTL_D Document Part
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 (
    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]
    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]
    DOKAR,          -- Document Type [DOKAR]
    DOKNR,          -- Document [DOKNR]
    DOKVR,          -- Doc. Version [DOKVR]
    DOKTL,          -- Document Part [DOKTL_D]
    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]
    PRIMARY KEY (MANDT, RECN, ACTN)
);

Learn More