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

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-SAF (Application Component) Product Safety
     ⤷ CBUI (Package) Company Environment Information System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EST0D	Table Relationship Diagram
Short Description	EHS: Dangerous Goods Management - Risk Classification

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record	*
18	RECNMST	☐	ESERECNMST	ESDRECN	NUMC	20	0	Reference to Master Table
19	DPOT	☐	THME_DPOT	HMD_DPOT	CHAR	10	0	Risk Potential	*
20	HNU	☐	THME_HNU	HMD_HNU	CHAR	4	0	Hazard Identification Number	*
21	RELQ	☐	THME_RELQ	HMD_QUAN	QUAN	8	2	Exemption (ADR 1.1.3.6)
22	RELU	☐	THME_RELU	MEINS	UNIT	3	0	Unit of Measure Quantity Limit	T006
23	MULRQ	☐	THME_MULRQ	NUMC4	NUMC	4	0	Multiplication Factor Exemption (ADR 1.1.3.6)
24	PIN	☐	THME_PIN	HMD_PIN	CHAR	25	0	Packing Instruction Number	*
25	PINLQ	☐	THME_PINLQ	HMD_PIN	CHAR	25	0	Packing Instruction Number for Limited Quantity (LQ)	*
26	DGTA	☐	THME_DGTA	X	CHAR	1	0	Transport Approved
27	SPPRO	☐	THME_SPPRO	CHAR5	CHAR	5	0	Special Provision
28	PAI	☐	THME_PAI	HMD_QUAN	QUAN	8	2	Limited Quantity (LQ) Inner Packaging
29	PAIU	☐	THME_PAIU	MEINS	UNIT	3	0	Unit of Meas. for Limited Quantity (LQ) Inner Packaging	T006
30	PAO	☐	THME_PAO	HMD_QUAN	QUAN	8	2	Limited Quantity (LQ) Outer Packaging
31	PAOU	☐	THME_PAOU	MEINS	UNIT	3	0	Unit of Meas. for Limited Quantity (LQ) Outer Packaging	T006
32	PASI	☐	THME_PASI	HMD_QUAN	QUAN	8	2	Maximum Quantity per Package
33	UPASI	☐	THME_UPASI	MEINS	UNIT	3	0	Unit of Measurement for Single Packaging	T006
34	PAGW	☐	THME_PAGW	HMD_QUAN	QUAN	8	2	Limited Quantity (LQ) Gross Weight
35	UPAGW	☐	THME_UPAGW	MEINS	UNIT	3	0	Unit of Measurement for Limited Quantity (LQ) Gross	T006
36	HAZCHEM_CODE	☐	CBDUE_HAZCHEM_CODE	CBDUD_HAZCHEM_CODE	CHAR	10	0	Code for Chemical Hazard
37	EMSN1	☐	CBUNE_EMSN1	CBUND_EMSN1	CHAR	7	0	EmS Number 1
38	FLG_EMSN1_U	☐	CBDUE_FLG_EMSN1_U	CBUND_FLG_EMSN_U	CHAR	1	0	EmS Number 1 Underlined
39	EMSN2	☐	CBUNE_EMSN2	CBUND_EMSN1	CHAR	7	0	EmS Number 2
40	FLG_EMSN2_U	☐	CBDUE_FLG_EMSN2_U	CBUND_FLG_EMSN_U	CHAR	1	0	EmS Number 2 Underlined
41	STOWAGE	☐	CBDUE_STOWAGE	CBUND_STOWAGE	CHAR	3	0	Stowage Category	CCUNC111
42	CARR_TYPE	☐	CBDUE_CARR_TYPE	CBUND_CARR_TYPE	CHAR	3	0	Transport Category
43	FLG_PAI	☐	CBDUE_FLG_PAI	CBUND_FLG	CHAR	1	0	Value Entered for Limited Quantity (LQ) Inner Packaging
44	FLG_PAO	☐	CBDUE_FLG_PAO	CBUND_FLG	CHAR	1	0	Value Entered for Limited Quantity (LQ) Outer Packaging
45	FLG_PASI	☐	CBDUE_FLG_PASI	CBUND_FLG	CHAR	1	0	Value Entered for Maximum Quantity per Package
46	FLG_PAGW	☐	CBDUE_FLG_PAGW	CBUND_FLG	CHAR	1	0	Value Entered for Limited Quantity (LQ) Gross Weight
47	FLG_RELQ	☐	CBDUE_FLG_RELQ	CBUND_FLG	CHAR	1	0	Value Entered for Exemption
48	FLG_MULRQ	☐	CBDUE_FLG_MULRQ	CBUND_FLG	CHAR	1	0	Value Entered for Multiplication Factor
49	FLG_RELQ_UNLIMIT	☐	CBDUE_FLG_RELQ_UNLIMIT	CBUND_FLG	CHAR	1	0	Unlimited Set for Exemption
50	FLG_MULRQ_FORBID	☐	CBDUE_FLG_MULRQ_FORBID	CBUND_FLG	CHAR	1	0	Prohibited Set for Multiplication Factor
51	.INCLUDE	☐				0	0	DG: Structure for Dangerous Goods Master Table DGTM2
52	PINEQ	☐	ADGE_PINEQ	HMD_PIN	CHAR	25	0	Excepted Quantity: Packing Instruction Number	*
53	EXC_QUANT_IP	☐	ADGE_EXC_QUANT_IP	HMD_QUAN	QUAN	8	2	Excepted Quantity: Maximum Quantity/Volume Inner Packaging
54	EXC_QUANT_IP_U	☐	ADGE_EXC_QUANT_IP_U	MEINS	UNIT	3	0	Excepted Quantity: Unit of Meas. for Max.Qty Inner Packaging	*
55	EXC_QUANT_OP	☐	ADGE_EXC_QUANT_OP	HMD_QUAN	QUAN	8	2	Excepted Quantity: Maximum Quantity/Volume Outer Packaging
56	EXC_QUANT_OP_U	☐	ADGE_EXC_QUANT_OP_U	MEINS	UNIT	3	0	Excepted Quantity: Unit of Meas. for Max.Qty Outer Packaging	*
57	FLG_EXC_QUANT_IP	☐	ADGE_FLG_EXC_QUANT_IP	CBUND_FLG	CHAR	1	0	Value Entered for Max. Qty Inner Packaging (Excepted Qty)
58	FLG_EXC_QUANT_OP	☐	ADGE_FLG_EXC_QUANT_OP	CBUND_FLG	CHAR	1	0	Value Entered for Max. Qty Outer Packaging (Excepted Qty)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EST0D	AENNR	AENR	AENNR	REF	1	CN
2	EST0D	MANDT	T000	MANDT
3	EST0D	PAIU	T006	MSEHI		1	CN
4	EST0D	PAOU	T006	MSEHI		1	CN
5	EST0D	RELU	T006	MSEHI		1	CN
6	EST0D	SRSID	TCG56	SRSID	REF	1	CN
7	EST0D	STOWAGE	CCUNC111	STOWAGE		1	CN
8	EST0D	UPAGW	T006	MSEHI		1	CN
9	EST0D	UPASI	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in