SAP ABAP View EHSWAV_APPWAKEY (MD: Partner/Role/Approval/Waste Code Test View)

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

View Type	D	Database View
Database View	EHSWAV_APPWAKEY
Short Description	MD: Partner/Role/Approval/Waste Code Test View
Root table	EHSWAT_APPROVAL	MD: Waste Approval

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EHSWAT_APPROVAL	EHSWAT_APPROVAL
2	EHSWAT_APPWAKEY

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EHSWAT_APPWAKEY	MANDT	JL	EQ				0	0
2	EHSWAT_APPROVAL	MANDT	JR	EQ			AND	0	0
3	EHSWAT_APPWAKEY	RECNROOT	JL	EQ				0	0
4	EHSWAT_APPROVAL	RECN	JR	EQ			AND	0	0
5	EHSWAT_APPROVAL	DELFLG		NE	'X'		AND	0	0
6	EHSWAT_APPWAKEY	DELFLG		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	EHSWAT_APPWAKEY	*		☐		☐
2	MANDT	EHSWAT_APPWAKEY	MANDT		☐	MANDT	☐	Client
3	RECN	EHSWAT_APPWAKEY	RECN		☐	EHSBE_UUID_32	☐	GUID Number
4	ACTN	EHSWAT_APPWAKEY	ACTN		☐	EHSBE_UUID_32	☐	GUID Number
5	VALFR	EHSWAT_APPWAKEY	VALFR		☐	ESEVALFR	☐	Valid-From Date
6	VALTO	EHSWAT_APPWAKEY	VALTO		☐	ESEVALTO	☐	Valid-To Date
7	AENNR	EHSWAT_APPWAKEY	AENNR		☐	ESEAENNR	☐	Change Number
8	DELFLG	EHSWAT_APPWAKEY	DELFLG		☐	ESEDELFLG	☐	Deletion Indicator
9	PARKFLG	EHSWAT_APPWAKEY	PARKFLG		☐	ESEPARKFLG	☐	Data Record Is Inactive
10	CRDAT	EHSWAT_APPWAKEY	CRDAT		☐	ESECRDAT	☐	Created On
11	CRNAM	EHSWAT_APPWAKEY	CRNAM		☐	ESECRNAM	☐	Created By
12	UPDDAT	EHSWAT_APPWAKEY	UPDDAT		☐	ESEUPDDAT	☐	Changed On
13	UPDNAM	EHSWAT_APPWAKEY	UPDNAM		☐	ESEUPDNAM	☐	Last Changed By
14	SRSID	EHSWAT_APPWAKEY	SRSID		☐	ESESRSID	☐	Source of Data
15	OWNID	EHSWAT_APPWAKEY	OWNID		☐	ESEVENDRID	☐	Data Provider
16	RECNROOT	EHSWAT_APPWAKEY	RECNROOT		☐	EHSBE_UUID_32	☐	GUID Number
17	RECNWAKEY	EHSWAT_APPWAKEY	RECNWAKEY		☐	EHSWAE_WAKEY	☐	Waste Code (RECN)
18	APWAKEY	EHSWAT_APPWAKEY	APWAKEY		☐	EHSWAE_WAKEYIDE_SHORT	☐	Waste Code
19	APCKQUAN	EHSWAT_APPWAKEY	APCKQUAN		☐	EHSWAE_APCKQUAN	☐	Alert Quantity
20	APCKU	EHSWAT_APPWAKEY	APCKU		☐	EHSWAE_APCKU	☐	Unit of Measure for Alert Quantity
21	APDISQUAN	EHSWAT_APPWAKEY	APDISQUAN		☐	EHSWAE_APDISQUAN	☐	Quantity Disposed Of
22	APDISU	EHSWAT_APPWAKEY	APDISU		☐	EHSWAE_DISU	☐	Unit of Measure for Quantity Disposed Of
23	APPQUAN	EHSWAT_APPWAKEY	APPQUAN		☐	EHSWAE_APPQUAN	☐	Total Licensed Quantity for the Approval and Waste Code
24	APPQUANU	EHSWAT_APPWAKEY	APPQUANU		☐	EHSWAE_PERU	☐	Unit of Measure for Licensed Quantity
25	APDISCAT	EHSWAT_APPWAKEY	APDISCAT		☐	EHSWAE_APDISCAT	☐	Type of disposal
26	APDISMETH	EHSWAT_APPWAKEY	APDISMETH		☐	EHSWAE_APDISMETH	☐	Disposal Method
27	APDISPROC	EHSWAT_APPWAKEY	APDISPROC		☐	EHSWAE_APDISPROC	☐	Process Code
28	APFRE	EHSWAT_APPWAKEY	APFRE		☐	EHSWAE_APFRE	☐	Frequency of Removal
29	RECNSUBST	EHSWAT_APPWAKEY	RECNSUBST		☐	EHSWAE_RECNAPSUBST	☐	Specification (RECN) with Declaration Analysis Data
30	APPACCAT	EHSWAT_APPWAKEY	APPACCAT		☐	EHSWAE_APACCAT	☐	Packaging Category
31	APPDISPREAS	EHSWAT_APPWAKEY	APPDISPREAS		☐	EHSWAE_DISPREAS	☐	Reason for Disposal of Waste
32	APWAKEYORD	EHSWAT_APPWAKEY	APWAKEYORD		☐	EHSWAE_APWAKEYORD	☐	Sort Sequence and Default Setting for Waste Code

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in