SAP ABAP Table ESTDF (Additional Information - User-Defined Text)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-SAF (Application Component) Product Safety
⤷ CBUI (Package) Company Environment Information System
⤷ EHS-SAF (Application Component) Product Safety
⤷ CBUI (Package) Company Environment Information System
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ESTDF | Table Relationship Diagram |
Short Description | Additional Information - User-Defined Text |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | EHS: Structure for key info of master data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | RECN | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
4 | ACTN | ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
5 | .INCLUDE | 0 | 0 | EHS: Structure for General Administration Information | |||||
6 | VALFR | ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
7 | VALTO | ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
8 | AENNR | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
9 | DELFLG | ESEDELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
10 | PARKFLG | ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
11 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
12 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
13 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
14 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
15 | SRSID | ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
16 | OWNID | ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
17 | RECNROOT | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | * | |
18 | NAMEMST | ESENAMEMST | CHAR30 | CHAR | 30 | 0 | Name of Master Table | ||
19 | RECNMST | ESERECNMST | ESDRECN | NUMC | 20 | 0 | Reference to Master Table | ||
20 | TEXTCAT | ESETEXTCAT | ESDTEXTCAT | CHAR | 10 | 0 | User-Defined Text Type | TCG41 | |
21 | ORD | ESEORD | NUMC4 | NUMC | 4 | 0 | Sort Sequence | ||
22 | LANGU | ESELANGU | SPRAS | LANG | 1 | 0 | Language | T002 | |
23 | HEADER | ESEHEADER | TEXT132 | CHAR | 132 | 0 | Start of User-Defined Text | ||
24 | LTXTFLG | ESELTXTFLG | ESDFLAG | CHAR | 1 | 0 | Long Text | ||
25 | FORMATFLG | ESEFORMATFLG | ESDFLAG | CHAR | 1 | 0 | Formatting Available | ||
26 | .INCLUDE | 0 | 0 | DDS: DMS document key | |||||
27 | DOKAR | DOKAR | DOKAR | CHAR | 3 | 0 | Document Type | TDWA | |
28 | DOKNR | DOKNR | DOKNR | CHAR | 25 | 0 | Document number | ESD_DRAW | |
29 | DOKVR | DOKVR | DOKVR | CHAR | 2 | 0 | Document version | ESD_DRAW | |
30 | DOKTL | DOKTL_D | DOKTL | CHAR | 3 | 0 | Document part | ||
31 | DOCDATE | EHSBEDOCDAT | DATUM | DATS | 8 | 0 | Document Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ESTDF | AENNR | AENR | AENNR | REF | 1 | CN |
2 | ESTDF | DOKAR | TDWA | DOKAR | |||
3 | ESTDF | DOKNR | ESD_DRAW | DOKNR | KEY | 1 | CN |
4 | ESTDF | DOKVR | ESD_DRAW | DOKVR | |||
5 | ESTDF | LANGU | T002 | SPRAS | REF | 1 | CN |
6 | ESTDF | MANDT | T000 | MANDT | |||
7 | ESTDF | SRSID | TCG56 | SRSID | REF | 1 | CN |
8 | ESTDF | TEXTCAT | TCG41 | TEXTCAT | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |