SAP ABAP View EHSWAV_002 (MD: Logical Table for EHSWAT002)

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_002
Short Description	MD: Logical Table for EHSWAT002
Root table	EHSWAT000	MD (BDT): Master Table for the Waste Management Master Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EHSWAT000	EHSWAT000
2	EHSWAT002
3	EHSWAT100
4	MAKT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EHSWAT002	RECNMAST	JL	EQ				0	0
2	EHSWAT100	RECN	JR	EQ			AND	0	0
3	EHSWAT100	RECNROOT	JL	EQ				0	0
4	EHSWAT000	RECN	JR	EQ			AND	0	0
5	EHSWAT002	MATNR	JL	EQ				0	0
6	MAKT	MATNR	JR	EQ			AND	0	0
7	EHSWAT002	MANDT	JL	EQ				0	0
8	EHSWAT100	MANDT	JR	EQ			AND	0	0
9	EHSWAT100	MANDT	JL	EQ				0	0
10	EHSWAT000	MANDT	JR	EQ			AND	0	0
11	MAKT	MANDT	JL	EQ				0	0
12	EHSWAT002	MANDT	JR	EQ			AND	0	0
13	EHSWAT000	DELFLG		NE	'X'		AND	0	0
14	EHSWAT002	DELFLG		NE	'X'		AND	0	0
15	EHSWAT100	DELFLG		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	EHSWAT002	*		☐		☐
2	MANDT	EHSWAT002	MANDT		☐	MANDT	☐	Client
3	RECN	EHSWAT002	RECN		☐	EHSBE_UUID_32	☐	GUID Number
4	ACTN	EHSWAT002	ACTN		☐	EHSBE_UUID_32	☐	GUID Number
5	VALFR	EHSWAT002	VALFR		☐	ESEVALFR	☐	Valid-From Date
6	VALTO	EHSWAT002	VALTO		☐	ESEVALTO	☐	Valid-To Date
7	AENNR	EHSWAT002	AENNR		☐	ESEAENNR	☐	Change Number
8	DELFLG	EHSWAT002	DELFLG		☐	ESEDELFLG	☐	Deletion Indicator
9	PARKFLG	EHSWAT002	PARKFLG		☐	ESEPARKFLG	☐	Data Record Is Inactive
10	CRDAT	EHSWAT002	CRDAT		☐	ESECRDAT	☐	Created On
11	CRNAM	EHSWAT002	CRNAM		☐	ESECRNAM	☐	Created By
12	UPDDAT	EHSWAT002	UPDDAT		☐	ESEUPDDAT	☐	Changed On
13	UPDNAM	EHSWAT002	UPDNAM		☐	ESEUPDNAM	☐	Last Changed By
14	SRSID	EHSWAT002	SRSID		☐	ESESRSID	☐	Source of Data
15	OWNID	EHSWAT002	OWNID		☐	ESEVENDRID	☐	Data Provider
16	RECNROOT	EHSWAT002	RECNROOT		☐	EHSBE_UUID_32	☐	GUID Number
17	RECNMAST	EHSWAT002	RECNMAST		☐	EHSBE_UUID_32	☐	GUID Number
18	BPWANO	EHSWAT002	BPWANO		☐	EHSWAE_BPWANO	☐	Waste Generation, Waste Disposal, or Waste Transport
19	MATNR	EHSWAT002	MATNR		☐	EHSWAE_WASTE	☐	Material That Represents the Waste
20	AVRECOK	EHSWAT002	AVRECOK		☐	EHSWAE_AVRECOK	☐	Date of Last Check
21	AVRECPER	EHSWAT002	AVRECPER		☐	EHSWAE_AVRECPER	☐	Person Who Performed the Last Check
22	CONGD	EHSWAT002	CONGD		☐	EHSWAE_CONGD	☐	Contact Person
23	CONPHONE	EHSWAT002	CONPHONE		☐	EHSWAE_CONPHONE	☐	Contact Person: Telephone Number
24	RECNSUBST	EHSWAT002	RECNSUBST		☐	ESERECN	☐	Sequential Number of Data Record
25	AVREC	EHSWAT002	AVREC		☐	EHSWAE_AVREC	☐	Avoidability and Recoverability Checked
26	AVOID	EHSWAT002	AVOID		☐	EHSWAE_AVOID	☐	Avoidability
27	RECYCLE	EHSWAT002	RECYCLE		☐	EHSWAE_RECYCLE	☐	Recoverability
28	DISPOSE	EHSWAT002	DISPOSE		☐	EHSWAE_DISPOSE	☐	Disposal
29	DUTY	EHSWAT002	DUTY		☐	EHSWAE_DUTCAT	☐	Condition Type
30	DUTYNO	EHSWAT002	DUTYNO		☐	EHSWAE_DUTYNO	☐	Number of Condition Imposed by Authority
31	WERK	EHSWAT002	WERK		☐	EHSWAE_WERKLGORT	☐	Plant for Storage Location
32	WASTORE	EHSWAT002	WASTORE		☐	EHSWAE_STORE	☐	Storage Location for Waste
33	MATNPART	EHSWAT002	MATNPART		☐	EHSWAE_MATNRPART	☐	Waste Number at Waste Management Business Partner
34	DISPROC	EHSWAT002	DISPROC		☐	EHSWAE_APDISPROC	☐	Process Code
35	DIRG	EHSWAT002	DIRG		☐	EHSWAE_DIRG	☐	Advanced Notice Period in Days
36	GENRHY	EHSWAT002	GENRHY		☐	EHSWAE_GENRHY	☐	Rhythm
37	GENFRE	EHSWAT002	GENFRE		☐	EHSWAE_GENFRE	☐	Frequency
38	GENCYC	EHSWAT002	GENCYC		☐	EHSWAE_GENCYC	☐	Cycle
39	GEDIMIN	EHSWAT002	GEDIMIN		☐	EHSWAE_GEDIMIN	☐	Minimum Waste Quantity
40	GEDIMINU	EHSWAT002	GEDIMINU		☐	EHSWAE_GEDIMINU	☐	Unit of Measure for Minimum Waste Quantity
41	GEDIMAX	EHSWAT002	GEDIMAX		☐	EHSWAE_GEDIMAX	☐	Maximum Waste Quantity
42	GEDIMAXU	EHSWAT002	GEDIMAXU		☐	EHSWAE_GEDIMAXU	☐	Unit of Measure for Maximum Waste Quantity
43	GEDIAV	EHSWAT002	GEDIAV		☐	EHSWAE_GEDIAV	☐	Average Waste Quantity
44	GEDIAVU	EHSWAT002	GEDIAVU		☐	EHSWAE_GEDIAVU	☐	Unit of Measure for Average Waste Quantity
45	PARTNER	EHSWAT000	PARTNER		☐	EHSWAE_PARTNER	☐	Business Partner for Waste Management
46	RLTYP	EHSWAT100	RLTYP		☐	EHSWAE_WABPROLE	☐	Business Partner Role in Waste Management
47	SPRAS	MAKT	SPRAS		☐	SPRAS	☐	Language Key
48	MAKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
49	RECN1	EHSWAT000	RECN		☐	EHSBE_UUID_32	☐	GUID Number
50	ACTN1	EHSWAT000	ACTN		☐	EHSBE_UUID_32	☐	GUID Number
51	RECN2	EHSWAT100	RECN		☐	EHSBE_UUID_32	☐	GUID Number
52	ACTN2	EHSWAT100	ACTN		☐	EHSBE_UUID_32	☐	GUID Number
53	MATNR1	MAKT	MATNR		☐	MATNR	☐	Material 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