SAP ABAP View EHSWAV_APPQUANT (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_APPQUANT
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	MANDT	EHSWAT_APPROVAL	MANDT		☐	MANDT	☐	Client
2	RECN	EHSWAT_APPROVAL	RECN		☐	EHSBE_UUID_32	☐	GUID Number
3	ACTN	EHSWAT_APPROVAL	ACTN		☐	EHSBE_UUID_32	☐	GUID Number
4	INTAPPNO	EHSWAT_APPROVAL	INTAPPNO		☐	EHSWAE_APPNOINT	☐	Waste Approval
5	APPNO	EHSWAT_APPROVAL	APPNO		☐	EHSWAE_APPNO	☐	Waste Approval Number Assigned by Authority
6	APPSTATUS	EHSWAT_APPROVAL	APPSTATUS		☐	EHSWAE_APWOS	☐	Processing Status of the Waste Approval
7	APC	EHSWAT_APPROVAL	APC		☐	EHSWAE_APCAT	☐	Waste Approval Type
8	RECNWAKEY	EHSWAT_APPWAKEY	RECNWAKEY		☐	EHSWAE_WAKEY	☐	Waste Code (RECN)
9	APWAKEY	EHSWAT_APPWAKEY	APWAKEY		☐	EHSWAE_WAKEYIDE_SHORT	☐	Waste Code
10	APCKQUAN	EHSWAT_APPWAKEY	APCKQUAN		☐	EHSWAE_APCKQUAN	☐	Alert Quantity
11	APCKU	EHSWAT_APPWAKEY	APCKU		☐	EHSWAE_APCKU	☐	Unit of Measure for Alert Quantity
12	APDISQUAN	EHSWAT_APPWAKEY	APDISQUAN		☐	EHSWAE_APDISQUAN	☐	Quantity Disposed Of
13	APDISU	EHSWAT_APPWAKEY	APDISU		☐	EHSWAE_DISU	☐	Unit of Measure for Quantity Disposed Of
14	APPQUAN	EHSWAT_APPWAKEY	APPQUAN		☐	EHSWAE_APPQUAN	☐	Total Licensed Quantity for the Approval and Waste Code
15	APPQUANU	EHSWAT_APPWAKEY	APPQUANU		☐	EHSWAE_PERU	☐	Unit of Measure for Licensed Quantity
16	APDISCAT	EHSWAT_APPWAKEY	APDISCAT		☐	EHSWAE_APDISCAT	☐	Type of disposal
17	APDISMETH	EHSWAT_APPWAKEY	APDISMETH		☐	EHSWAE_APDISMETH	☐	Disposal Method
18	APDISPROC	EHSWAT_APPWAKEY	APDISPROC		☐	EHSWAE_APDISPROC	☐	Process Code
19	APFRE	EHSWAT_APPWAKEY	APFRE		☐	EHSWAE_APFRE	☐	Frequency of Removal
20	RECNSUBST	EHSWAT_APPWAKEY	RECNSUBST		☐	EHSWAE_RECNAPSUBST	☐	Specification (RECN) with Declaration Analysis Data
21	APPACCAT	EHSWAT_APPWAKEY	APPACCAT		☐	EHSWAE_APACCAT	☐	Packaging Category
22	APVALFROM	EHSWAT_APPROVAL	APVALFROM		☐	EHSWAE_APVALFROM	☐	Valid From
23	APVALTO	EHSWAT_APPROVAL	APVALTO		☐	EHSWAE_APVALTO	☐	Valid To
24	RECN_APPWAKEY	EHSWAT_APPWAKEY	RECN		☐	EHSBE_UUID_32	☐	GUID Number

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