ESTDF

Transparent Table Application Table
28 Fields 1 CDS Views

Additional Information - User-Defined Text

ESTDF is an SAP database table in S/4HANA. Additional Information - User-Defined Text. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/OHS4/P_Documents view from Documents

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
namemst ESENAMEMST Master table
recnmst ESERECNMST RefMaster
textcat ESETEXTCAT UserDfndTxtType
ord ESEORD Sort Order
langu ESELANGU Language
header ESEHEADER User-Def. Text
ltxtflg ESELTXTFLG Long text
formatflg ESEFORMATFLG Formatted
dokar DOKAR Document Type
doknr DOKNR Document
dokvr DOKVR Doc. Version
doktl DOKTL_D Document Part
docdate EHSBEDOCDAT Document Date

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.

-- Additional Information - User-Defined Text
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESTDF (
    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]
    NAMEMST,    -- Master table [ESENAMEMST]
    RECNMST,    -- RefMaster [ESERECNMST]
    TEXTCAT,    -- UserDfndTxtType [ESETEXTCAT]
    ORD,        -- Sort Order [ESEORD]
    LANGU,      -- Language [ESELANGU]
    HEADER,     -- User-Def. Text [ESEHEADER]
    LTXTFLG,    -- Long text [ESELTXTFLG]
    FORMATFLG,  -- Formatted [ESEFORMATFLG]
    DOKAR,      -- Document Type [DOKAR]
    DOKNR,      -- Document [DOKNR]
    DOKVR,      -- Doc. Version [DOKVR]
    DOKTL,      -- Document Part [DOKTL_D]
    DOCDATE,    -- Document Date [EHSBEDOCDAT]
    PRIMARY KEY (MANDT, RECN, ACTN)
);

Learn More