1. Home
  2. Resources
  3. SAP Tables
  4. EST0D - EHS: Dangerous Goods Management - Risk Classification

SAP Table EST0D

EHS: Dangerous Goods Management - Risk Classification

EST0D (EHS: Dangerous Goods Management - Risk 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 EST0D to other SAP tables.

EST0D 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
X Indicator Is Active
NULL Indicator Is Inactive
PARKFLG Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
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
RECNMST Reference to Master Table ESERECNMST NUMC 20 0
DPOT Risk Potential THME_DPOT CHAR 10 0
HNU Hazard Identification Number THME_HNU CHAR 4 0
RELQ Exemption (ADR 1.1.3.6) THME_RELQ QUAN 8 2
RELU Unit of Measure Quantity Limit THME_RELU T006 UNIT 3 0
MULRQ Multiplication Factor Exemption (ADR 1.1.3.6) THME_MULRQ NUMC 4 0
PIN Packing Instruction Number THME_PIN CHAR 25 0
PINLQ Packing Instruction Number for Limited Quantity (LQ) THME_PINLQ CHAR 25 0
DGTA Transport Approved THME_DGTA CHAR 1 0
X Yes
NULL No
SPPRO Special Provision THME_SPPRO CHAR 5 0
PAI Limited Quantity (LQ) Inner Packaging THME_PAI QUAN 8 2
PAIU Unit of Meas. for Limited Quantity (LQ) Inner Packaging THME_PAIU T006 UNIT 3 0
PAO Limited Quantity (LQ) Outer Packaging THME_PAO QUAN 8 2
PAOU Unit of Meas. for Limited Quantity (LQ) Outer Packaging THME_PAOU T006 UNIT 3 0
PASI Maximum Quantity per Package THME_PASI QUAN 8 2
UPASI Unit of Measurement for Single Packaging THME_UPASI T006 UNIT 3 0
PAGW Limited Quantity (LQ) Gross Weight THME_PAGW QUAN 8 2
UPAGW Unit of Measurement for Limited Quantity (LQ) Gross THME_UPAGW T006 UNIT 3 0
HAZCHEM_CODE Code for Chemical Hazard CBDUE_HAZCHEM_CODE CHAR 10 0
EMSN1 EmS Number 1 CBUNE_EMSN1 CHAR 7 0
FLG_EMSN1_U EmS Number 1 Underlined CBDUE_FLG_EMSN1_U CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
EMSN2 EmS Number 2 CBUNE_EMSN2 CHAR 7 0
FLG_EMSN2_U EmS Number 2 Underlined CBDUE_FLG_EMSN2_U CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
STOWAGE Stowage Category CBDUE_STOWAGE CCUNC111 CHAR 3 0
CARR_TYPE Transport Category CBDUE_CARR_TYPE CHAR 3 0
FLG_PAI Value Entered for Limited Quantity (LQ) Inner Packaging CBDUE_FLG_PAI CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_PAO Value Entered for Limited Quantity (LQ) Outer Packaging CBDUE_FLG_PAO CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_PASI Value Entered for Maximum Quantity per Package CBDUE_FLG_PASI CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_PAGW Value Entered for Limited Quantity (LQ) Gross Weight CBDUE_FLG_PAGW CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_RELQ Value Entered for Exemption CBDUE_FLG_RELQ CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_MULRQ Value Entered for Multiplication Factor CBDUE_FLG_MULRQ CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_RELQ_UNLIMIT Unlimited Set for Exemption CBDUE_FLG_RELQ_UNLIMIT CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_MULRQ_FORBID Prohibited Set for Multiplication Factor CBDUE_FLG_MULRQ_FORBID CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PINEQ Excepted Quantity: Packing Instruction Number ADGE_PINEQ CHAR 25 0
EXC_QUANT_IP Excepted Quantity: Maximum Quantity/Volume Inner Packaging ADGE_EXC_QUANT_IP QUAN 8 2
EXC_QUANT_IP_U Excepted Quantity: Unit of Meas. for Max.Qty Inner Packaging ADGE_EXC_QUANT_IP_U UNIT 3 0
EXC_QUANT_OP Excepted Quantity: Maximum Quantity/Volume Outer Packaging ADGE_EXC_QUANT_OP QUAN 8 2
EXC_QUANT_OP_U Excepted Quantity: Unit of Meas. for Max.Qty Outer Packaging ADGE_EXC_QUANT_OP_U UNIT 3 0
FLG_EXC_QUANT_IP Value Entered for Max. Qty Inner Packaging (Excepted Qty) ADGE_FLG_EXC_QUANT_IP CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_EXC_QUANT_OP Value Entered for Max. Qty Outer Packaging (Excepted Qty) ADGE_FLG_EXC_QUANT_OP CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive

EST0D foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EST0D AENNR SY MANDT AENR Change Master MANDT
EST0D AENNR EST0D AENNR AENR Change Master AENNR
EST0D MANDT EST0D MANDT T000 Clients MANDT
EST0D PAIU EST0D MANDT T006 Units of Measurement MANDT
EST0D PAIU EST0D PAIU T006 Units of Measurement MSEHI
EST0D PAOU EST0D MANDT T006 Units of Measurement MANDT
EST0D PAOU EST0D PAOU T006 Units of Measurement MSEHI
EST0D RELU EST0D RELU T006 Units of Measurement MSEHI
EST0D RELU EST0D MANDT T006 Units of Measurement MANDT
EST0D SRSID * TCG56 EHS: Data Origin MANDT
EST0D SRSID EST0D SRSID TCG56 EHS: Data Origin SRSID
EST0D STOWAGE EST0D MANDT CCUNC111 Stowage Categories MANDT
EST0D STOWAGE RCG0DIOT LWDG CCUNC111 Stowage Categories LWDG
EST0D STOWAGE EST0D STOWAGE CCUNC111 Stowage Categories STOWAGE
EST0D UPAGW EST0D MANDT T006 Units of Measurement MANDT
EST0D UPAGW EST0D UPAGW T006 Units of Measurement MSEHI
EST0D UPASI EST0D MANDT T006 Units of Measurement MANDT
EST0D UPASI EST0D UPASI T006 Units of Measurement MSEHI