EST0D SAP (EHS: Dangerous Goods Management - Risk Classification) Table details

Dictionary Type: Table
Description: EHS: Dangerous Goods Management - Risk Classification




ABAP Code to SELECT data from EST0D
Related tables to EST0D
Access table EST0D




Table field list including key, data, relationships and ABAP select examples

EST0D is a standard SAP Table which is used to store EHS: Dangerous Goods Management - Risk Classification data and is available within R/3 SAP systems depending on the version and release level.

The EST0D table consists of various fields, each holding specific information or linking keys about EHS: Dangerous Goods Management - Risk Classification data available in SAP. These include MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State), VALFR (Valid-From Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EST0D table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
RECNSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
ACTNSequential Number of the Change State ESEACTNNUMC20ALPHAESDACTN
VALFRValid-From Date ESEVALFRDATS8DATUM
VALTOValid-To Date ESEVALTODATS8DATUM
AENNRChange Number ESEAENNRCHAR12AENRAENNRAENNRAEN
DELFLGDeletion Indicator ESEDELFLGCHAR1ESDFLAG
PARKFLGData Record Is Inactive ESEPARKFLGCHAR1ESDFLAG
CRDATCreated On ESECRDATDATS8DATUM
CRNAMCreated By ESECRNAMCHAR12USNAM
UPDDATChanged On ESEUPDDATDATS8DATUM
UPDNAMLast Changed By ESEUPDNAMCHAR12USNAM
SRSIDSource of Data ESESRSIDCHAR10TCG56ESDSRSID
OWNIDData Provider ESEVENDRIDCHAR10Assigned to domainALPHAAD_ADDRNUM
RECNROOTSequential Number of Data Record ESERECNNUMC20Assigned to domainALPHAESDRECN
RECNMSTReference to Master Table ESERECNMSTNUMC20ALPHAESDRECN
DPOTRisk Potential THME_DPOTCHAR10Assigned to domainHMD_DPOT
HNUHazard Identification Number THME_HNUCHAR4Assigned to domainHMD_HNU
RELQExemption (ADR 1.1.3.6) THME_RELQQUAN8(2) HMD_QUAN
RELUUnit of Measure Quantity Limit THME_RELUUNIT3T006CUNITMEINS
MULRQMultiplication Factor Exemption (ADR 1.1.3.6) THME_MULRQNUMC4NUMC4
PINPacking Instruction Number THME_PINCHAR25Assigned to domainHMD_PIN
PINLQPacking Instruction Number for Limited Quantity (LQ) THME_PINLQCHAR25Assigned to domainHMD_PIN
DGTATransport Approved THME_DGTACHAR1X
SPPROSpecial Provision THME_SPPROCHAR5CHAR5
PAILimited Quantity (LQ) Inner Packaging THME_PAIQUAN8(2) HMD_QUAN
PAIUUnit of Meas. for Limited Quantity (LQ) Inner Packaging THME_PAIUUNIT3T006CUNITMEINS
PAOLimited Quantity (LQ) Outer Packaging THME_PAOQUAN8(2) HMD_QUAN
PAOUUnit of Meas. for Limited Quantity (LQ) Outer Packaging THME_PAOUUNIT3T006CUNITMEINS
PASIMaximum Quantity per Package THME_PASIQUAN8(2) HMD_QUAN
UPASIUnit of Measurement for Single Packaging THME_UPASIUNIT3T006CUNITMEINS
PAGWLimited Quantity (LQ) Gross Weight THME_PAGWQUAN8(2) HMD_QUAN
UPAGWUnit of Measurement for Limited Quantity (LQ) Gross THME_UPAGWUNIT3T006CUNITMEINS
HAZCHEM_CODECode for Chemical Hazard CBDUE_HAZCHEM_CODECHAR10CBDUD_HAZCHEM_CODE
EMSN1EmS Number 1 CBUNE_EMSN1CHAR7CBUND_EMSN1
FLG_EMSN1_UEmS Number 1 Underlined CBDUE_FLG_EMSN1_UCHAR1CBUND_FLG_EMSN_U
EMSN2EmS Number 2 CBUNE_EMSN2CHAR7CBUND_EMSN1
FLG_EMSN2_UEmS Number 2 Underlined CBDUE_FLG_EMSN2_UCHAR1CBUND_FLG_EMSN_U
STOWAGEStowage Category CBDUE_STOWAGECHAR3CCUNC111CBUND_STOWAGE
CARR_TYPETransport Category CBDUE_CARR_TYPECHAR3CBUND_CARR_TYPE
FLG_PAIValue Entered for Limited Quantity (LQ) Inner Packaging CBDUE_FLG_PAICHAR1CBUND_FLG
FLG_PAOValue Entered for Limited Quantity (LQ) Outer Packaging CBDUE_FLG_PAOCHAR1CBUND_FLG
FLG_PASIValue Entered for Maximum Quantity per Package CBDUE_FLG_PASICHAR1CBUND_FLG
FLG_PAGWValue Entered for Limited Quantity (LQ) Gross Weight CBDUE_FLG_PAGWCHAR1CBUND_FLG
FLG_RELQValue Entered for Exemption CBDUE_FLG_RELQCHAR1CBUND_FLG
FLG_MULRQValue Entered for Multiplication Factor CBDUE_FLG_MULRQCHAR1CBUND_FLG
FLG_RELQ_UNLIMITUnlimited Set for Exemption CBDUE_FLG_RELQ_UNLIMITCHAR1CBUND_FLG
FLG_MULRQ_FORBIDProhibited Set for Multiplication Factor CBDUE_FLG_MULRQ_FORBIDCHAR1CBUND_FLG
PINEQExcepted Quantity: Packing Instruction Number ADGE_PINEQCHAR25Assigned to domainHMD_PIN
EXC_QUANT_IPExcepted Quantity: Maximum Quantity/Volume Inner Packaging ADGE_EXC_QUANT_IPQUAN8(2) HMD_QUAN
EXC_QUANT_IP_UExcepted Quantity: Unit of Meas. for Max.Qty Inner Packaging ADGE_EXC_QUANT_IP_UUNIT3Assigned to domainCUNITMEINS
EXC_QUANT_OPExcepted Quantity: Maximum Quantity/Volume Outer Packaging ADGE_EXC_QUANT_OPQUAN8(2) HMD_QUAN
EXC_QUANT_OP_UExcepted Quantity: Unit of Meas. for Max.Qty Outer Packaging ADGE_EXC_QUANT_OP_UUNIT3Assigned to domainCUNITMEINS
FLG_EXC_QUANT_IPValue Entered for Max. Qty Inner Packaging (Excepted Qty) ADGE_FLG_EXC_QUANT_IPCHAR1CBUND_FLG
FLG_EXC_QUANT_OPValue Entered for Max. Qty Outer Packaging (Excepted Qty) ADGE_FLG_EXC_QUANT_OPCHAR1CBUND_FLG

Key field Non-key field



How do I retrieve data from SAP table EST0D using ABAP code

The following ABAP code Example will allow you to do a basic selection on EST0D to SELECT all data from the table
DATA: WA_EST0D TYPE EST0D.

SELECT SINGLE *
FROM EST0D
INTO CORRESPONDING FIELDS OF WA_EST0D
WHERE...

How to access SAP table EST0D

Within an ECC or HANA version of SAP you can also view further information about EST0D and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!