SAP Table EST0F
EHS: Dangerous Goods Management - Transport Classification
EST0F (EHS: Dangerous Goods Management - Transport Classification) 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 EST0F to other SAP tables.
EST0F 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 | |||||||
| RECNTVA | Reference to RECN for Tables ESTVA, ESTRH and ESTRI | ESERECNTVA | NUMC | 20 | 0 | |||||||
| RECNCMP | Reference to Specification Header of a Component | ESERECNCMP | NUMC | 20 | 0 | |||||||
| LWDG | Dangerous Goods Regulation | THME_LWDG | THM063 | CHAR | 12 | 0 | ||||||
| DPOT | Risk Potential | THME_DPOT | CHAR | 10 | 0 | |||||||
| WOS | Processing Status for Basic Data and Master Data | THME_WOS | THM039 | CHAR | 2 | 0 | ||||||
| NHM | Non-Dangerous Goods Full Transport | THME_NHM | THM159 | CHAR | 1 | 0 | ||||||
| NHME | Non-Dangerous Goods Empty Transport | THME_NHME | THM159 | CHAR | 1 | 0 | ||||||
| HISCAT | EH&S: Hazard Inducer Type | THME_HISCAT | THM083 | CHAR | 3 | 0 | ||||||
| UPD_CMP | Date of Last Change to Component | ESEUPD_CMP | DATS | 8 | 0 | |||||||
EST0F foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EST0F | AENNR | SY | MANDT | AENR | Change Master | MANDT |
| EST0F | AENNR | EST0F | AENNR | AENR | Change Master | AENNR |
| EST0F | HISCAT | EST0F | MANDT | THM083 | EHS: Hazard Inducer Types | MANDT |
| EST0F | HISCAT | EST0F | HISCAT | THM083 | EHS: Hazard Inducer Types | HISCAT |
| EST0F | HISCAT | EST0F | LWDG | THM083 | EHS: Hazard Inducer Types | LWDG |
| EST0F | LWDG | EST0F | LWDG | THM063 | DG: Dangerous Goods Regulation | LWDG |
| EST0F | LWDG | EST0F | MANDT | THM063 | DG: Dangerous Goods Regulation | MANDT |
| EST0F | MANDT | EST0F | MANDT | T000 | Clients | MANDT |
| EST0F | NHM | ESTOF | MANDT | THM159 | DG: Not Dangerous Goods Full/Empty Transport | MANDT |
| EST0F | NHM | EST0F | NHM | THM159 | DG: Not Dangerous Goods Full/Empty Transport | NDG |
| EST0F | NHME | EST0F | MANDT | THM159 | DG: Not Dangerous Goods Full/Empty Transport | MANDT |
| EST0F | NHME | EST0F | NHME | THM159 | DG: Not Dangerous Goods Full/Empty Transport | NDG |
| EST0F | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
| EST0F | SRSID | EST0F | SRSID | TCG56 | EHS: Data Origin | SRSID |
| EST0F | WOS | EST0F | MANDT | THM039 | DG: Processing Status for Dangerous Goods Basic Data | MANDT |
| EST0F | WOS | EST0F | WOS | THM039 | DG: Processing Status for Dangerous Goods Basic Data | DGWOS |
