SAP ABAP View V_EWAODITEM_STAT (View Objects for Waste Disposal Orders, with Status)

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_EWAODITEM_STAT
Short Description	View Objects for Waste Disposal Orders, with Status
Root table	JEST	Individual Object Status

Table

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

Join Conditions

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

View Fields

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

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	473