SAP Table ESTDF
Additional Information - User-Defined Text
ESTDF (Additional Information - User-Defined Text) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ESTDF to other SAP tables.
ESTDF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
RECN
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||
|
ACTN
Sequential Number of the Change State
|
ESEACTN |
NUMC
|
20 | 0 | ||||||||
|
VALFR
Valid-From Date
|
ESEVALFR |
DATS
|
8 | 0 | ||||||||
|
VALTO
Valid-To Date
|
ESEVALTO |
DATS
|
8 | 0 | ||||||||
|
AENNR
Change Number
|
ESEAENNR | AENR |
CHAR
|
12 | 0 | |||||||
|
DELFLG
Deletion Indicator
|
ESEDELFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PARKFLG
Data Record Is Inactive
|
ESEPARKFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CRDAT
Created On
|
ESECRDAT |
DATS
|
8 | 0 | ||||||||
|
CRNAM
Created By
|
ESECRNAM |
CHAR
|
12 | 0 | ||||||||
|
UPDDAT
Changed On
|
ESEUPDDAT |
DATS
|
8 | 0 | ||||||||
|
UPDNAM
Last Changed By
|
ESEUPDNAM |
CHAR
|
12 | 0 | ||||||||
|
SRSID
Source of Data
|
ESESRSID | TCG56 |
CHAR
|
10 | 0 | |||||||
|
OWNID
Data Provider
|
ESEVENDRID |
CHAR
|
10 | 0 | ||||||||
|
RECNROOT
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||
|
NAMEMST
Name of Master Table
|
ESENAMEMST |
CHAR
|
30 | 0 | ||||||||
|
RECNMST
Reference to Master Table
|
ESERECNMST |
NUMC
|
20 | 0 | ||||||||
|
TEXTCAT
User-Defined Text Type
|
ESETEXTCAT | TCG41 |
CHAR
|
10 | 0 | |||||||
|
ORD
Sort Sequence
|
ESEORD |
NUMC
|
4 | 0 | ||||||||
|
LANGU
Language
|
ESELANGU | T002 |
LANG
|
1 | 0 | |||||||
|
HEADER
Start of User-Defined Text
|
ESEHEADER |
CHAR
|
132 | 0 | ||||||||
|
LTXTFLG
Long Text
|
ESELTXTFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FORMATFLG
Formatting Available
|
ESEFORMATFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DOKAR
Document Type
|
DOKAR | TDWA |
CHAR
|
3 | 0 | |||||||
|
DOKNR
Document number
|
DOKNR | ESD_DRAW |
CHAR
|
25 | 0 | |||||||
|
DOKVR
Document Version
|
DOKVR | ESD_DRAW |
CHAR
|
2 | 0 | |||||||
|
DOKTL
Document Part
|
DOKTL_D |
CHAR
|
3 | 0 | ||||||||
|
DOCDATE
Document Date
|
EHSBEDOCDAT |
DATS
|
8 | 0 | ||||||||
ESTDF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ESTDF | AENNR | SY | MANDT |
AENR
Change Master
|
MANDT |
| ESTDF | AENNR | ESTDF | AENNR |
AENR
Change Master
|
AENNR |
| ESTDF | DOKAR | SYST | MANDT |
TDWA
Document Types
|
MANDT |
| ESTDF | DOKAR | ESTDF | DOKAR |
TDWA
Document Types
|
DOKAR |
| ESTDF | DOKNR | ESTDF | DOKVR |
ESD_DRAW
Generated Table for View
|
DOKVR |
| ESTDF | DOKNR | ESTDF | DOKTL |
ESD_DRAW
Generated Table for View
|
DOKTL |
| ESTDF | DOKNR | SY | MANDT |
ESD_DRAW
Generated Table for View
|
MANDT |
| ESTDF | DOKNR | SY | LANGU |
ESD_DRAW
Generated Table for View
|
LANGU |
| ESTDF | DOKNR | * |
ESD_DRAW
Generated Table for View
|
DKTXT | |
| ESTDF | DOKNR | ESTDF | DOKAR |
ESD_DRAW
Generated Table for View
|
DOKAR |
| ESTDF | DOKNR | ESTDF | DOKNR |
ESD_DRAW
Generated Table for View
|
DOKNR |
| ESTDF | DOKVR | ESTDF | DOKAR |
ESD_DRAW
Generated Table for View
|
DOKAR |
| ESTDF | DOKVR | ESTDF | DOKNR |
ESD_DRAW
Generated Table for View
|
DOKNR |
| ESTDF | DOKVR | ESTDF | DOKVR |
ESD_DRAW
Generated Table for View
|
DOKVR |
| ESTDF | DOKVR | ESTDF | DOKTL |
ESD_DRAW
Generated Table for View
|
DOKTL |
| ESTDF | DOKVR | SY | MANDT |
ESD_DRAW
Generated Table for View
|
MANDT |
| ESTDF | DOKVR | SY | LANGU |
ESD_DRAW
Generated Table for View
|
LANGU |
| ESTDF | DOKVR | * |
ESD_DRAW
Generated Table for View
|
DKTXT | |
| ESTDF | LANGU | ESTDF | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| ESTDF | MANDT | ESTDF | MANDT |
T000
Clients
|
MANDT |
| ESTDF | SRSID | * |
TCG56
EHS: Data Origin
|
MANDT | |
| ESTDF | SRSID | ESTDF | SRSID |
TCG56
EHS: Data Origin
|
SRSID |
| ESTDF | TEXTCAT | SY | MANDT |
TCG41
EHS: Value Assignment Text Type
|
MANDT |
| ESTDF | TEXTCAT | ESTDF | TEXTCAT |
TCG41
EHS: Value Assignment Text Type
|
TEXTCAT |