SAP ABAP Table EHSWAT_APPROVAL (MD: Waste Approval)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-WA (Application Component) Waste Management
     ⤷ CBWA (Package) EH&S: Waste Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EHSWAT_APPROVAL	Table Relationship Diagram
Short Description	MD: Waste 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 Standard Key Fields in Master Data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
4	ACTN	☑	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
5	.INCLUDE	☐				0	0	EHS: Structure for general administrative 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	*
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	*
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
18	INTAPPNO	☐	EHSWAE_APPNOINT	EHSWAD_APPNOINT	CHAR	10	0	Waste Approval
19	APPSTATUS	☐	EHSWAE_APWOS	EHSWAD_APWOS	CHAR	5	0	Processing Status of the Waste Approval	EHSWAC_APSTAT
20	APPNO	☐	EHSWAE_APPNO	EHSWAD_APPNO	CHAR	20	0	Waste Approval Number Assigned by Authority
21	APC	☐	EHSWAE_APCAT	EHSWAD_APCAT	CHAR	6	0	Waste Approval Type	EHSWAC_APPCAT
22	APVALFROM	☐	EHSWAE_APVALFROM	DATS	DATS	8	0	Valid From
23	APVALTO	☐	EHSWAE_APVALTO	DATS	DATS	8	0	Valid To
24	APLWDG	☐	THME_LWDG	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation	THM063
25	APMNCAT	☐	EHSWAE_MNCAT	EHSWAD_MNCAT	CHAR	6	0	Disposal Document Type	EHSWAC_MNCAT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHSWAT_APPROVAL	APC	EHSWAC_APPCAT	APC	KEY
2	EHSWAT_APPROVAL	APLWDG	THM063	LWDG	KEY
3	EHSWAT_APPROVAL	APMNCAT	EHSWAC_MNCAT	MNCAT
4	EHSWAT_APPROVAL	APPSTATUS	EHSWAC_APSTAT	APWOS	KEY
5	EHSWAT_APPROVAL	MANDT	T000	MANDT

History

Last changed by/on	SAP	20110901
SAP Release Created in