SAP Table ESTRH
EHS: Specification Header
ESTRH (EHS: Specification Header) 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 ESTRH to other SAP tables.
ESTRH 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 | |||||||
| UPDDATS | Date of Last Change to Specification As a Whole | ESEUPDDATS | DATS | 8 | 0 | |||||||
| UPDNAMS | Name of Person Who Last Changed Specification | ESEUPDNAMS | CHAR | 12 | 0 | |||||||
| SUBID | Specification | ESESUBID | CHAR | 12 | 0 | |||||||
| SUBCAT | Specification Type | ESESUBCAT | TCG31 | CHAR | 10 | 0 | ||||||
| AUTHGRP | Authorization Group | ESEAUTHGRP | TCG36 | CHAR | 10 | 0 | ||||||
| REM | Note | ESEREM | CHAR | 60 | 0 | |||||||
| SUBCHAR | Identification of Substance Nature | ESESUBCHAR | TCG34 | CHAR | 10 | 0 | ||||||
ESTRH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ESTRH | AENNR | RCGUKEY | MANDT | AENR | Change Master | MANDT |
| ESTRH | AENNR | ESTRH | AENNR | AENR | Change Master | AENNR |
| ESTRH | AUTHGRP | ESTRH | AUTHGRP | TCG36 | EHS: Specification Authorization Object | AUTHGRP |
| ESTRH | AUTHGRP | ESTRH | MANDT | TCG36 | EHS: Specification Authorization Object | MANDT |
| ESTRH | MANDT | ESTRH | MANDT | T000 | Clients | MANDT |
| ESTRH | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
| ESTRH | SRSID | ESTRH | SRSID | TCG56 | EHS: Data Origin | SRSID |
| ESTRH | SUBCAT | ESTRH | MANDT | TCG31 | EHS: Specification Type | MANDT |
| ESTRH | SUBCAT | ESTRH | SUBCAT | TCG31 | EHS: Specification Type | SUBCAT |
| ESTRH | SUBCHAR | ESTRH | MANDT | TCG34 | EHS: Substance Nature | MANDT |
| ESTRH | SUBCHAR | ESTRH | SUBCHAR | TCG34 | EHS: Substance Nature | SUBCHAR |
