SAP Table ESTRI
EHS: Identifier (Numbers, Names, Chemical Formulas)
ESTRI (EHS: Identifier (Numbers, Names, Chemical Formulas)) 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 ESTRI to other SAP tables.
ESTRI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | |||||||
| IDTYPE | Identification Category | ESEIDTYPE | TCG21 | CHAR | 10 | 0 | ||||||
| IDCAT | Identification Type | ESEIDCAT | TCG23 | CHAR | 10 | 0 | ||||||
| LANGU | Language | ESELANGU | T002 | LANG | 1 | 0 | ||||||
| IDENT | Identifier | ESEIDENT | CHAR | 132 | 0 | |||||||
| IDENTNM | Normed identification (upper case, no special characters) | ESEIDENTNM | CHAR | 132 | 0 | |||||||
| LTXTFLG | Long Text | ESELTXTFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| FORMATFLG | Formatting Available | ESEFORMATFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| ORD | Sort Sequence | ESEORD | NUMC | 4 | 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 | |||||||
| FLG_INHSRC | Truth Value | ESEBOOLE | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_INHOVR | Truth Value | ESEBOOLE | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_INHEXCL | Truth Value | ESEBOOLE | CHAR | 1 | 0 |
Possible values
|
||||||
| RECN_TPLH | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| RECNTRI_SRC | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| RECNTRI_ORIG | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| RECNROOT_ORIG | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| TPL_ORD | Sort Sequence | ESEORD | NUMC | 4 | 0 | |||||||
ESTRI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ESTRI | AENNR | RCGUKEY | MANDT | AENR | Change Master | MANDT |
| ESTRI | AENNR | ESTRI | AENNR | AENR | Change Master | AENNR |
| ESTRI | DOKAR | SYST | MANDT | TDWA | Document Types | MANDT |
| ESTRI | DOKAR | ESTRI | DOKAR | TDWA | Document Types | DOKAR |
| ESTRI | DOKNR | ESTRI | DOKAR | ESD_DRAW | Generated Table for View | DOKAR |
| ESTRI | DOKNR | ESTRI | DOKNR | ESD_DRAW | Generated Table for View | DOKNR |
| ESTRI | DOKNR | ESTRI | DOKVR | ESD_DRAW | Generated Table for View | DOKVR |
| ESTRI | DOKNR | ESTRI | DOKTL | ESD_DRAW | Generated Table for View | DOKTL |
| ESTRI | DOKNR | SY | MANDT | ESD_DRAW | Generated Table for View | MANDT |
| ESTRI | DOKNR | SY | LANGU | ESD_DRAW | Generated Table for View | LANGU |
| ESTRI | DOKNR | * | ESD_DRAW | Generated Table for View | DKTXT | |
| ESTRI | DOKVR | SY | LANGU | ESD_DRAW | Generated Table for View | LANGU |
| ESTRI | DOKVR | * | ESD_DRAW | Generated Table for View | DKTXT | |
| ESTRI | DOKVR | ESTRI | DOKAR | ESD_DRAW | Generated Table for View | DOKAR |
| ESTRI | DOKVR | ESTRI | DOKNR | ESD_DRAW | Generated Table for View | DOKNR |
| ESTRI | DOKVR | ESTRI | DOKVR | ESD_DRAW | Generated Table for View | DOKVR |
| ESTRI | DOKVR | ESTRI | DOKTL | ESD_DRAW | Generated Table for View | DOKTL |
| ESTRI | DOKVR | SY | MANDT | ESD_DRAW | Generated Table for View | MANDT |
| ESTRI | IDCAT | ESTRI | IDTYPE | TCG23 | EHS: Identification Type | IDTYPE |
| ESTRI | IDCAT | ESTRI | IDCAT | TCG23 | EHS: Identification Type | IDCAT |
| ESTRI | IDCAT | ESTRI | MANDT | TCG23 | EHS: Identification Type | MANDT |
| ESTRI | IDTYPE | ESTRI | IDTYPE | TCG21 | EHS: Identification Category | IDTYPE |
| ESTRI | LANGU | ESTRI | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ESTRI | MANDT | ESTRI | MANDT | T000 | Clients | MANDT |
| ESTRI | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
| ESTRI | SRSID | ESTRI | SRSID | TCG56 | EHS: Data Origin | SRSID |
