ESTRI - Identifier (Numbers, Names, Chemical Formulas)
Identifier (Numbers, Names, Chemical Formulas) information is stored in SAP table ESTRI.
It is part of development package CBUI in software component EHS-SAF. This development package consists of objects that can be grouped under "Company Environment Information System".
It is part of development package CBUI in software component EHS-SAF. This development package consists of objects that can be grouped under "Company Environment Information System".
Fields for table ESTRI
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | RCGUKEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| RECN | Sequential Number of Data Record | X | ESERECN | NUMC | 40 | |
| ACTN | Sequential Number of the Change State | X | ESEACTN | NUMC | 40 | |
| .INCLUDE | RCGUADM | 0 | ||||
| VALFR | Valid-From Date | ESEVALFR | DATS | 16 | ||
| VALTO | Valid-To Date | ESEVALTO | DATS | 16 | ||
| AENNR | Change Number | ESEAENNR | CHAR | 24 | AENR | |
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR | 2 | ||
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 2 | ||
| CRDAT | Created On | ESECRDAT | DATS | 16 | ||
| CRNAM | Created By | ESECRNAM | CHAR | 24 | ||
| UPDDAT | Last Changed On | ESEUPDDAT | DATS | 16 | ||
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 24 | ||
| SRSID | Source of Data | ESESRSID | CHAR | 20 | TCG56 | |
| OWNID | Data Provider | ESEVENDRID | CHAR | 20 | * | |
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC | 40 | * | |
| IDTYPE | Identification Category | ESEIDTYPE | CHAR | 20 | TCG21 | |
| IDCAT | Identification Type | ESEIDCAT | CHAR | 20 | TCG23 | |
| LANGU | Language | ESELANGU | LANG | 2 | T002 | |
| IDENT | Identifier | ESEIDENT | CHAR | 264 | ||
| IDENTNM | Normed identification (upper case, no special characters) | ESEIDENTNM | CHAR | 264 | ||
| LTXTFLG | Long Text | ESELTXTFLG | CHAR | 2 | ||
| FORMATFLG | Formatted | ESEFORMATFLG | CHAR | 2 | ||
| ORD | Sort Order | ESEORD | NUMC | 8 | ||
| .INCLUDE | CVDDOCKEY | 0 | ||||
| DOKAR | Document Type | DOKAR | CHAR | 6 | TDWA | |
| DOKNR | Document number | DOKNR | CHAR | 50 | ESD_DRAW | |
| DOKVR | Document Version | DOKVR | CHAR | 4 | ESD_DRAW | |
| DOKTL | Document Part | DOKTL_D | CHAR | 6 | ||
| FLG_INHSRC | Truth Value | ESEBOOLE | CHAR | 2 | ||
| FLG_INHOVR | Truth Value | ESEBOOLE | CHAR | 2 | ||
| FLG_INHEXCL | Truth Value | ESEBOOLE | CHAR | 2 | ||
| RECN_TPLH | Sequential Number of Data Record | ESERECN | NUMC | 40 | ||
| RECNTRI_SRC | Sequential Number of Data Record | ESERECN | NUMC | 40 | ||
| RECNTRI_ORIG | Sequential Number of Data Record | ESERECN | NUMC | 40 | ||
| RECNROOT_ORIG | Sequential Number of Data Record | ESERECN | NUMC | 40 | ||
| TPL_ORD | Sort Order | ESEORD | NUMC | 8 |