EST07 SAP table for – EHS: Dangerous Goods Management – Transport Approval

Here we would like to draw your attention to EST07 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). EST07 is a SAP standard transp table used for storing EHS: Dangerous Goods Management – Transport Approval related data in SAP. It comes under the package CBUI.

SAP EST07 table

Table EST07 technical data

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

SAP EST07 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 EST07 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
  • MOS : Dangerous Goods Transport Type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ADMOS : Transport Permitted
    Its data type is CHAR (Character String) with field length 1
  • LEG_SRC_RESTR : Regulatory Basis for Transport Restrictions
    Its data type is CHAR (Character String) with field length 25
  • RESTR_PHRKEY : Phrase Key for Transport Restriction
    Its data type is CHAR (Character String) with field length 21
  • MIN_QUANT : Minimum Quantity for Restriction
    Its data type is QUAN (Quantity field) with field length 8
  • U_MIN_QUANT : Unit of Measurement for Minimum Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MAX_QUANT : Maximum Quantity for Exemption
    Its data type is QUAN (Quantity field) with field length 8
  • U_MAX_QUANT : Unit of Measurement for Maximum Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FLG_MIN_QUANT : Value Entered for Minimum Quantity for Restriction
    Its data type is CHAR (Character String) with field length 1
  • FLG_MAX_QUANT : Value Entered for Maximum Quantity for Restriction
    Its data type is CHAR (Character String) with field length 1