EST0D SAP table for – EHS: Dangerous Goods Management – Risk Classification

Here we would like to draw your attention to EST0D table in SAP. As we know it is being mainly used with the SAP EHS-SAF (Product Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). EST0D is a SAP standard transp table used for storing EHS: Dangerous Goods Management – Risk Classification related data in SAP. It comes under the package CBUI.

SAP EST0D table

Table EST0D technical data

TableEST0D
Data storingEHS: Dangerous Goods Management – Risk Classification
ModuleEHS
Sub ModuleEHS-SAF
SAP PackageCBUI
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP EST0D Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in EST0D table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Structure for General Administration Information
  • VALFR : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : Valid-To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • RECNMST : Reference to Master Table
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • DPOT : Risk Potential
    Its data type is CHAR (Character String) with field length 10
  • HNU : Hazard Identification Number
    Its data type is CHAR (Character String) with field length 4
  • RELQ : Exemption (ADR 1.1.3.6)
    Its data type is QUAN (Quantity field) with field length 8
  • RELU : Unit of Measure Quantity Limit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MULRQ : Multiplication Factor Exemption (ADR 1.1.3.6)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PIN : Packing Instruction Number
    Its data type is CHAR (Character String) with field length 25
  • PINLQ : Packing Instruction Number for Limited Quantity (LQ)
    Its data type is CHAR (Character String) with field length 25
  • DGTA : Transport Approved
    Its data type is CHAR (Character String) with field length 1
  • SPPRO : Special Provision
    Its data type is CHAR (Character String) with field length 5
  • PAI : Limited Quantity (LQ) Inner Packaging
    Its data type is QUAN (Quantity field) with field length 8
  • PAIU : Unit of Meas. for Limited Quantity (LQ) Inner Packaging
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PAO : Limited Quantity (LQ) Outer Packaging
    Its data type is QUAN (Quantity field) with field length 8
  • PAOU : Unit of Meas. for Limited Quantity (LQ) Outer Packaging
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PASI : Maximum Quantity per Package
    Its data type is QUAN (Quantity field) with field length 8
  • UPASI : Unit of Measurement for Single Packaging
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PAGW : Limited Quantity (LQ) Gross Weight
    Its data type is QUAN (Quantity field) with field length 8
  • UPAGW : Unit of Measurement for Limited Quantity (LQ) Gross
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • HAZCHEM_CODE : Code for Chemical Hazard
    Its data type is CHAR (Character String) with field length 10
  • EMSN1 : EmS Number 1
    Its data type is CHAR (Character String) with field length 7
  • FLG_EMSN1_U : EmS Number 1 Underlined
    Its data type is CHAR (Character String) with field length 1
  • EMSN2 : EmS Number 2
    Its data type is CHAR (Character String) with field length 7
  • FLG_EMSN2_U : EmS Number 2 Underlined
    Its data type is CHAR (Character String) with field length 1
  • STOWAGE : Stowage Category
    Its data type is CHAR (Character String) with field length 3
  • CARR_TYPE : Transport Category
    Its data type is CHAR (Character String) with field length 3
  • FLG_PAI : Value Entered for Limited Quantity (LQ) Inner Packaging
    Its data type is CHAR (Character String) with field length 1
  • FLG_PAO : Value Entered for Limited Quantity (LQ) Outer Packaging
    Its data type is CHAR (Character String) with field length 1
  • FLG_PASI : Value Entered for Maximum Quantity per Package
    Its data type is CHAR (Character String) with field length 1
  • FLG_PAGW : Value Entered for Limited Quantity (LQ) Gross Weight
    Its data type is CHAR (Character String) with field length 1
  • FLG_RELQ : Value Entered for Exemption
    Its data type is CHAR (Character String) with field length 1
  • FLG_MULRQ : Value Entered for Multiplication Factor
    Its data type is CHAR (Character String) with field length 1
  • FLG_RELQ_UNLIMIT : Unlimited Set for Exemption
    Its data type is CHAR (Character String) with field length 1
  • FLG_MULRQ_FORBID : Prohibited Set for Multiplication Factor
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : DG: Structure for Dangerous Goods Master Table DGTM2
  • PINEQ : Excepted Quantity: Packing Instruction Number
    Its data type is CHAR (Character String) with field length 25
  • EXC_QUANT_IP : Excepted Quantity: Maximum Quantity/Volume Inner Packaging
    Its data type is QUAN (Quantity field) with field length 8
  • EXC_QUANT_IP_U : Excepted Quantity: Unit of Meas. for Max.Qty Inner Packaging
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • EXC_QUANT_OP : Excepted Quantity: Maximum Quantity/Volume Outer Packaging
    Its data type is QUAN (Quantity field) with field length 8
  • EXC_QUANT_OP_U : Excepted Quantity: Unit of Meas. for Max.Qty Outer Packaging
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FLG_EXC_QUANT_IP : Value Entered for Max. Qty Inner Packaging (Excepted Qty)
    Its data type is CHAR (Character String) with field length 1
  • FLG_EXC_QUANT_OP : Value Entered for Max. Qty Outer Packaging (Excepted Qty)
    Its data type is CHAR (Character String) with field length 1