SAP ABAP Table EST07 (EHS: Dangerous Goods Management - Transport Approval)

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	EST07	Table Relationship Diagram
Short Description	EHS: Dangerous Goods Management - Transport Approval

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	MOS	☐	THME_MOS	HMD_MOS	NUMC	3	0	Dangerous Goods Transport Type	*
21	ADMOS	☐	THME_ADMOS	X	CHAR	1	0	Transport Permitted
22	LEG_SRC_RESTR	☐	CBDUE_LEG_SRC_RESTR	CBUND_LEG_SRC_RESTR	CHAR	25	0	Regulatory Basis for Transport Restrictions	CCUNC117
23	RESTR_PHRKEY	☐	CBDUE_RESTR_PHRKEY	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Phrase Key for Transport Restriction
24	MIN_QUANT	☐	CBDUE_MIN_QUANT	HMD_QUAN	QUAN	8	2	Minimum Quantity for Restriction
25	U_MIN_QUANT	☐	CBDUE_U_MIN_QUANT	MEINS	UNIT	3	0	Unit of Measurement for Minimum Quantity	*
26	MAX_QUANT	☐	CBDUE_MAX_QUANT	HMD_QUAN	QUAN	8	2	Maximum Quantity for Exemption
27	U_MAX_QUANT	☐	CBDUE_U_MAX_QUANT	MEINS	UNIT	3	0	Unit of Measurement for Maximum Quantity	*
28	FLG_MIN_QUANT	☐	CBDUE_FLG_MIN_QUANT	CBUND_FLG	CHAR	1	0	Value Entered for Minimum Quantity for Restriction
29	FLG_MAX_QUANT	☐	CBDUE_FLG_MAX_QUANT	CBUND_FLG	CHAR	1	0	Value Entered for Maximum Quantity for Restriction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EST07	AENNR	AENR	AENNR	REF	1	CN
2	EST07	LEG_SRC_RESTR	CCUNC117	LEG_SRC_RESTR		1	CN
3	EST07	MANDT	T000	MANDT
4	EST07	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in