SAP ABAP View EHSWAV_SHLP_APP (Use for Search Help EHSWAH_APPROVAL_EXT Only)

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_SHLP_APP
Short Description	Use for Search Help EHSWAH_APPROVAL_EXT Only
Root table	EHSWAT_APPROVAL	MD: Waste Approval

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EHSWAT_APPROVAL	EHSWAT_APPROVAL
2	EHSWAT_APPWAKEY
3	ESTRI
4	EHSWAT002
5	EHSWAT000
6	EHSWAT001_DESCR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EHSWAT_APPROVAL	MANDT	JL	EQ				0	0
2	EHSWAT_APPWAKEY	MANDT	JR	EQ			AND	0	0
3	EHSWAT_APPWAKEY	MANDT	JL	EQ				0	0
4	ESTRI	MANDT	JR	EQ			AND	0	0
5	EHSWAT_APPROVAL	MANDT	JL	EQ				0	0
6	EHSWAT002	MANDT	JR	EQ			AND	0	0
7	EHSWAT000	MANDT	JL	EQ				0	0
8	EHSWAT_APPROVAL	MANDT	JR	EQ			AND	0	0
9	EHSWAT001_DESCR	MANDT	JL	EQ				0	0
10	EHSWAT002	MANDT	JR	EQ			AND	0	0
11	EHSWAT_APPROVAL	RECN	JL	EQ				0	0
12	EHSWAT_APPWAKEY	RECNROOT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EHSWAT_APPROVAL	MANDT		☐	MANDT	☐	Client
2	APPNO	EHSWAT_APPROVAL	APPNO		☐	EHSWAE_APPNO	☐	Waste Approval Number Assigned by Authority
3	APC	EHSWAT_APPROVAL	APC		☐	EHSWAE_APCAT	☐	Waste Approval Type
4	APPSTATUS	EHSWAT_APPROVAL	APPSTATUS		☐	EHSWAE_APWOS	☐	Processing Status of the Waste Approval
5	APVALFROM	EHSWAT_APPROVAL	APVALFROM		☐	EHSWAE_APVALFROM	☐	Valid From
6	APVALTO	EHSWAT_APPROVAL	APVALTO		☐	EHSWAE_APVALTO	☐	Valid To
7	MATNR	EHSWAT002	MATNR		☐	EHSWAE_WASTE	☐	Material That Represents the Waste
8	WAKEY	EHSWAT_APPWAKEY	RECNWAKEY		☐	EHSWAE_WAKEY	☐	Waste Code (RECN)
9	GENERATOR	EHSWAT000	PARTNER		☐	EHSWAE_PARTNER	☐	Business Partner for Waste Management
10	DISPOSER	EHSWAT000	PARTNER		☐	EHSWAE_PARTNER	☐	Business Partner for Waste Management
11	TRANSPORTER	EHSWAT000	PARTNER		☐	EHSWAE_PARTNER	☐	Business Partner for Waste Management
12	RECN	EHSWAT_APPROVAL	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	20130529
SAP Release Created in	110