ESTPP

Transparent Table Application Table
24 Fields 1 CDS Views

EHS: Phrase Item

ESTPP is an SAP database table in S/4HANA. EHS: Phrase Item. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecificationPhraseItem view from BASIC Specification Phrase Item

Fields (24)

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
langu ESELANGU Language
phrcode ESEPHRCODE Phrase code
phrtext ESEPHRTEXT Phrase text
ltxtflg ESELTXTFLG Long text
formatflg ESEFORMATFLG Formatted
rem ESEREM Note
phrgraph ESEPHRGRPH Graphics File
flgwrltxt ESEWRLTXT Long text
ppstate ESEPPSTATE Phrase status

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: Phrase Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESTPP (
    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]
    LANGU,      -- Language [ESELANGU]
    PHRCODE,    -- Phrase code [ESEPHRCODE]
    PHRTEXT,    -- Phrase text [ESEPHRTEXT]
    LTXTFLG,    -- Long text [ESELTXTFLG]
    FORMATFLG,  -- Formatted [ESEFORMATFLG]
    REM,        -- Note [ESEREM]
    PHRGRAPH,   -- Graphics File [ESEPHRGRPH]
    FLGWRLTXT,  -- Long text [ESEWRLTXT]
    PPSTATE,    -- Phrase status [ESEPPSTATE]
    PRIMARY KEY (MANDT, RECN, ACTN)
);

Learn More