SAP ABAP View V_EORDER_STAT (View: All Waste Disposal Order Data (Header and Items))

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-WA (Application Component) Waste Management
     ⤷ EEWA (Package) IS-U: Waste Management

Basic Data

View Type	D	Database View
Database View	V_EORDER_STAT
Short Description	View: All Waste Disposal Order Data (Header and Items)
Root table	EWA_ORDER_OBJECT	Item Table for Waste Disposal Order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EWA_ORDER_OBJECT	EWA_ORDER_OBJECT
2	EWA_ORDER_HEAD
3	JEST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EWA_ORDER_HEAD	MANDT	JL	EQ				0	0
2	EWA_ORDER_OBJECT	MANDT	JR	EQ			AND	0	0
3	EWA_ORDER_HEAD	ORDERNR	JL	EQ				0	0
4	EWA_ORDER_OBJECT	ORDERNR	JR	EQ			AND	0	0
5	EWA_ORDER_OBJECT	MANDT	JL	EQ				0	0
6	JEST	MANDT	JR	EQ			AND	0	0
7	EWA_ORDER_OBJECT	POBJNR	JL	EQ				0	0
8	JEST	OBJNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EWA_ORDER_HEAD	MANDT		☐	MANDT	☐	Client
2	ORDERNR	EWA_ORDER_HEAD	ORDERNR		☐	EORDERNR	☐	Internal Number for Identifying a Waste Disposal Order
3	ORDER_LAUFNR	EWA_ORDER_OBJECT	ORDER_LAUFNR		☐	ORDER_LAUFNR	☐	Consecutive Number for Waste Disposal Order Item
4	ORDER_DATE	EWA_ORDER_OBJECT	ORDER_DATE		☐	EORDER_DATE	☐	Planned Date for the Execution of the Waste Disposal Order
5	PLANED_START	EWA_ORDER_HEAD	PLANED_START		☐	EWASTART	☐	Planned Start Time of Waste Disposal Order
6	PLANED_END	EWA_ORDER_HEAD	PLANED_END		☐	EWAEND	☐	Planned Finish Time of Waste Disposal Order
7	ROUTE	EWA_ORDER_HEAD	ROUTE		☐	EROUTE	☐	Planned Waste Disposal Order Route
8	START_TIME	EWA_ORDER_OBJECT	START_TIME		☐	START_TIME	☐	Start time of a service window
9	END_TIME	EWA_ORDER_OBJECT	END_TIME		☐	STOP_TIME	☐	End of service window
10	SERVFREQNR	EWA_ORDER_OBJECT	SERVFREQNR		☐	EOBJNR	☐	Number of service frequency
11	KUNNR	EWA_ORDER_OBJECT	KUNNR		☐	BU_PARTNER	☐	Business Partner Number
12	SDAUFNR	EWA_ORDER_OBJECT	SDAUFNR		☐	VBELN_VA	☐	Sales Document
13	ADDRNR	EWA_ORDER_OBJECT	ADDRNR		☐	AD_ADDRNUM	☐	Address number
14	EORDER_STATUS	EWA_ORDER_HEAD	EORDER_STATUS		☐	EORDER_STATUS	☐	Status of the waste disposal order
15	STATUS_TXT	EWA_ORDER_OBJECT	STATUS_TXT		☐	EORDER_STATUS_TXT	☐	Status Text of the Waste Disposal Order
16	SERVFREQ_LFNR	EWA_ORDER_OBJECT	SERVFREQ_LFNR		☐	LAUFNR	☐	Consecutive number of service frequency
17	ROUTE_SEQUENCE	EWA_ORDER_OBJECT	ROUTE_SEQUENCE		☐	ROUTE_SEQUENCE	☐	Number of stop in route
18	BEH_TYPE	EWA_ORDER_OBJECT	BEH_TYPE		☐	BEH_TYPE	☐	Container category
19	SERNR	EWA_ORDER_OBJECT	SERNR		☐	GERNR	☐	Serial Number
20	BEHGRP	EWA_ORDER_OBJECT	BEHGRP		☐	BEHGRP	☐	Container Group
21	SERVICE_TYPE	EWA_ORDER_OBJECT	SERVICE_TYPE		☐	SERVICE_TYPE	☐	Service Type
22	SMAUFNR	EWA_ORDER_OBJECT	SMAUFNR		☐	AUFNR	☐	Order Number
23	SERVLOC	EWA_ORDER_OBJECT	SERVLOC		☐	SERVLOC	☐	Location of Container
24	ROB	EWA_ORDER_OBJECT	ROB		☐	EEWA_CLEAN_ROB	☐	Cleaning Object
25	CAPAB	EWA_ORDER_HEAD	CAPAB		☐	EEWA_CAPAB	☐	Capacity Number
26	EORDER_STATUS_I	EWA_ORDER_OBJECT	EORDER_STATUS		☐	EORDER_STATUS	☐	Status of the waste disposal order
27	BEH_TYPE_NEW	EWA_ORDER_OBJECT	BEH_TYPE_NEW		☐	BEHTYPNEU	☐	New Container Category
28	SERNR_NEW	EWA_ORDER_OBJECT	SERNR_NEW		☐	BEHNEU	☐	New Container Serial Number
29	BEHGRP_NEW	EWA_ORDER_OBJECT	BEHGRP_NEW		☐	BEHGRP	☐	Container Group
30	WASTE_TYPE	EWA_ORDER_OBJECT	WASTE_TYPE		☐	WASTE_TYPE	☐	Waste
31	BEH_ANZAHL	EWA_ORDER_OBJECT	BEH_ANZAHL		☐	CONT_COUNT	☐	Number of available containers
32	EPROP	EWA_ORDER_OBJECT	EPROP		☐	EEWA_CLEAN_PROP	☐	Property
33	ROBTYP	EWA_ORDER_OBJECT	ROBTYP		☐	EEWA_ROB_ROBTYP	☐	Cleaning object category
34	SUPERROB	EWA_ORDER_OBJECT	SUPERROB		☐	EEWA_CLEAN_SUPERROB	☐	Superordinate Cleaning Object
35	WINTERLEVEL	EWA_ORDER_OBJECT	WINTERLEVEL		☐	EEWA_WINTERLEVEL	☐	Winter Maintenance Level
36	CLEAN1	EWA_ORDER_OBJECT	CLEAN1		☐	EEWA_CLEANMETH	☐	Cleaning Method
37	CLEAN2	EWA_ORDER_OBJECT	CLEAN2		☐	EEWA_CLEANMETH	☐	Cleaning Method
38	CLEAN3	EWA_ORDER_OBJECT	CLEAN3		☐	EEWA_CLEANMETH	☐	Cleaning Method
39	CLEAN4	EWA_ORDER_OBJECT	CLEAN4		☐	EEWA_CLEANMETH	☐	Cleaning Method
40	CLEAN5	EWA_ORDER_OBJECT	CLEAN5		☐	EEWA_CLEANMETH	☐	Cleaning Method
41	REMENG_TARGET	EWA_ORDER_OBJECT	REMENG_TARGET		☐	EEWA_CLEAN_REMENGMET	☐	Assessment Value
42	REUNIT	EWA_ORDER_OBJECT	REUNIT		☐	MSEHI	☐	Unit of Measurement
43	ANZAHL_BEHGRP	EWA_ORDER_OBJECT	ANZAHL_BEHGRP		☐	ECONT_BEHGRP	☐	Number of Containers in Container Group
44	BELNR	EWA_ORDER_OBJECT	BELNR		☐	E_BELNR	☐	Number of a billing document
45	INTAPPNO	EWA_ORDER_OBJECT	INTAPPNO		☐	EWA_EHS_APPNOINT	☐	Waste Approval
46	APPNO	EWA_ORDER_OBJECT	APPNO		☐	EWA_EHS_APPNO	☐	Authority-Assigned Waste Approval Number
47	RECN	EWA_ORDER_OBJECT	RECN		☐	EWAEHS_GUID	☐	Unique ID Number for Integration with EHS
48	WAKEYIDE	EWA_ORDER_OBJECT	WAKEYIDE		☐	EHS_WAKEYIDE	☐	Waste Code
49	WAKEYCATLG	EWA_ORDER_OBJECT	WAKEYCATLG		☐	EHS_WAKEYCATLG	☐	Waste Catalog
50	MNAMIN	EWA_ORDER_OBJECT	MNAMIN		☐	EHS_MNAMIN	☐	Disposal Quantity (Planning)
51	MNAMQIN	EWA_ORDER_OBJECT	MNAMQIN		☐	EHS_MNAMQIN	☐	Unit of Measure for Outgoing Quantity
52	BEH_ANZAHL_RM	EWA_ORDER_OBJECT	BEH_ANZAHL_RM		☐	ANZSERN_RM	☐	Confirmed Number of Containers
53	WEIGHT_UNIT	EWA_ORDER_OBJECT	WEIGHT_UNIT		☐	WEIGHT_UNIT	☐	Unit of weight
54	WASTE_WEIGHT	EWA_ORDER_OBJECT	WASTE_WEIGHT		☐	WASTE_WEIGHT	☐	Weight of Waste Measured when Container Emptied
55	WASTE	EWA_ORDER_OBJECT	WASTE		☐	WASTE_TYPE	☐	Waste
56	VOL_UNIT	EWA_ORDER_OBJECT	VOL_UNIT		☐	VOL_UNIT	☐	Volume unit
57	WASTE_VOL	EWA_ORDER_OBJECT	WASTE_VOL		☐	WASTE_VOL	☐	Waste Volume Measured when Container Emptied
58	UZEIT	EWA_ORDER_OBJECT	UZEIT		☐	UZEIT	☐	Time
59	CONT_SERV_DURAT	EWA_ORDER_OBJECT	CONT_SERV_DURAT		☐	CONT_SERV_DURAT	☐	Time required for emptying a container
60	REMENG	EWA_ORDER_OBJECT	REMENG		☐	EEWA_CLEAN_REMENGMET	☐	Assessment Value
61	CONFTYPE1	EWA_ORDER_OBJECT	CONFTYPE1		☐	CONFTYPE	☐	Confirmation note
62	CONFTYPE2	EWA_ORDER_OBJECT	CONFTYPE2		☐	CONFTYPE	☐	Confirmation note
63	CONFTYPE3	EWA_ORDER_OBJECT	CONFTYPE3		☐	CONFTYPE	☐	Confirmation note
64	TEXT	EWA_ORDER_OBJECT	TEXT		☐	ETEXT250	☐	Text with 250 characters
65	WCNT	EWA_ORDER_OBJECT	WCNT		☐	EWEIGHCNT	☐	Consecutive Number of Weighing Data Record
66	REF_ORDERNR	EWA_ORDER_OBJECT	REF_ORDERNR		☐	EORDERNR_REF	☐	Number of Waste Disposal Order for Weighing Data Record
67	WERKS	EWA_ORDER_OBJECT	WERKS		☐	WERKS_D	☐	Plant
68	LGORT	EWA_ORDER_OBJECT	LGORT		☐	LGORT_D	☐	Storage location
69	ABRMENGE	EWA_ORDER_OBJECT	ABRMENGE		☐	E_ABRMENGE	☐	Billing quantity
70	ACTUAL_DATE	EWA_ORDER_OBJECT	ACTUAL_DATE		☐	EORDER_ACTDATE	☐	Actual Date of Waste Disposal Order
71	OLD_ORDER_DATE	EWA_ORDER_OBJECT	OLD_ORDER_DATE		☐	EORDER_DATE	☐	Planned Date for the Execution of the Waste Disposal Order
72	POSTPONED	EWA_ORDER_OBJECT	POSTPONED		☐	POSTPONED	☐	Confirmation of Waste Disposal Order Reset
73	ORDER_TYPE	EWA_ORDER_OBJECT	ORDER_TYPE		☐	EORDER_TYPE	☐	Processing of Waste Disposal Order
74	MBLNR	EWA_ORDER_OBJECT	MBLNR		☐	MBLNR	☐	Number of Material Document
75	ADD_SERVICE	EWA_ORDER_OBJECT	ADD_SERVICE		☐	ADD_SERVICE	☐	Indicator for Additional Service
76	SERNR_RM_NEW	EWA_ORDER_OBJECT	SERNR_RM_NEW		☐	GERNR	☐	Serial Number
77	CONT_WGHT_TARA	EWA_ORDER_OBJECT	CONT_WGHT_TARA		☐	CONT_WGHT_TARA	☐	Weight of empty container
78	CONT_WEIGHT_FULL	EWA_ORDER_OBJECT	CONT_WEIGHT_FULL		☐	CONT_WEIGHT_FULL	☐	Container weight including waste
79	EHS_PARTNER	EWA_ORDER_OBJECT	EHS_PARTNER		☐	EHS_PARTNER	☐	Waste Management Business Partner
80	MNINO_UNS	EWA_ORDER_OBJECT	MNINO_UNS		☐	EWA_EHSWAE_MNINO	☐	Disposal Document
81	MNINO_BGS	EWA_ORDER_OBJECT	MNINO_BGS		☐	EWA_EHSWAE_MNINO	☐	Disposal Document
82	TRANSPORTER	EWA_ORDER_OBJECT	TRANSPORTER		☐	EHS_PARTNER	☐	Waste Management Business Partner
83	DISPOSER	EWA_ORDER_OBJECT	DISPOSER		☐	EHS_PARTNER	☐	Waste Management Business Partner
84	RECNWAKEY	EWA_ORDER_OBJECT	RECNWAKEY		☐	EHS_WAKEY	☐	Waste Code (RECN)
85	E_WERKS	EWA_ORDER_OBJECT	E_WERKS		☐	WERKS_D	☐	Plant
86	E_LGORT	EWA_ORDER_OBJECT	E_LGORT		☐	LGORT_D	☐	Storage location
87	GGVERTRAG	EWA_ORDER_OBJECT	GGVERTRAG		☐	E_GUARANTOR_CONTRACT	☐	Guarantor Contract
88	SDPOSNR	EWA_ORDER_OBJECT	SDPOSNR		☐	POSNR	☐	Item number of the SD document
89	POBJNR	EWA_ORDER_OBJECT	POBJNR		☐	J_OBJNR	☐	Object number
90	HOBJNR	EWA_ORDER_HEAD	HOBJNR		☐	J_OBJNR	☐	Object number
91	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
92	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
93	WDPLANTNR	EWA_ORDER_OBJECT	WDPLANTNR		☐	EWAEL_WDPLANTNR	☐	Identification of Waste Disposal Facility
94	SDAUFNR_NACH	EWA_ORDER_OBJECT	SDAUFNR_NACH		☐	VBELN_NACH	☐	Subsequent sales and distribution document

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	472