SAP ABAP View V_ORDERALL (View: All Waste Disposal Order Data)

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_ORDERALL
Short Description	View: All Waste Disposal Order Data
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	POBJNR	JL	EQ				0	0
6	JEST	OBJNR	JR	EQ			AND	0	0
7	EWA_ORDER_OBJECT	MANDT	JL	EQ				0	0
8	JEST	MANDT	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	TIMEFRAME	EWA_ORDER_OBJECT	TIMEFRAME		☐	TIMEFRAME	☐	Service window
9	START_TIME	EWA_ORDER_OBJECT	START_TIME		☐	START_TIME	☐	Start time of a service window
10	END_TIME	EWA_ORDER_OBJECT	END_TIME		☐	STOP_TIME	☐	End of service window
11	SERVFREQNR	EWA_ORDER_OBJECT	SERVFREQNR		☐	EOBJNR	☐	Number of service frequency
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	SERVFREQ_LFNR	EWA_ORDER_OBJECT	SERVFREQ_LFNR		☐	LAUFNR	☐	Consecutive number of service frequency
16	ROUTE_SEQUENCE	EWA_ORDER_OBJECT	ROUTE_SEQUENCE		☐	ROUTE_SEQUENCE	☐	Number of stop in route
17	BEH_TYPE	EWA_ORDER_OBJECT	BEH_TYPE		☐	BEH_TYPE	☐	Container category
18	SERNR	EWA_ORDER_OBJECT	SERNR		☐	GERNR	☐	Serial Number
19	SERVICE_TYPE	EWA_ORDER_OBJECT	SERVICE_TYPE		☐	SERVICE_TYPE	☐	Service Type
20	SMAUFNR	EWA_ORDER_OBJECT	SMAUFNR		☐	AUFNR	☐	Order Number
21	SERVLOC	EWA_ORDER_OBJECT	SERVLOC		☐	SERVLOC	☐	Location of Container
22	ROB	EWA_ORDER_OBJECT	ROB		☐	EEWA_CLEAN_ROB	☐	Cleaning Object
23	CAPAB	EWA_ORDER_OBJECT	CAPAB		☐	EEWA_CAPAB	☐	Capacity Number
24	WINTERLEVEL	EWA_ORDER_HEAD	WINTERLEVEL		☐	EEWA_WINTERLEVEL	☐	Winter Maintenance Level
25	EPROP	EWA_ORDER_OBJECT	EPROP		☐	EEWA_CLEAN_PROP	☐	Property
26	KUNNR	EWA_ORDER_OBJECT	KUNNR		☐	BU_PARTNER	☐	Business Partner Number
27	ORDER_TYPE	EWA_ORDER_OBJECT	ORDER_TYPE		☐	EORDER_TYPE	☐	Processing of Waste Disposal Order
28	ROBTYP	EWA_ORDER_OBJECT	ROBTYP		☐	EEWA_ROB_ROBTYP	☐	Cleaning object category
29	BEHGRP	EWA_ORDER_OBJECT	BEHGRP		☐	BEHGRP	☐	Container Group
30	BELNR	EWA_ORDER_OBJECT	BELNR		☐	E_BELNR	☐	Number of a billing document
31	GGVERTRAG	EWA_ORDER_OBJECT	GGVERTRAG		☐	E_GUARANTOR_CONTRACT	☐	Guarantor Contract
32	EHS_PARTNER	EWA_ORDER_OBJECT	EHS_PARTNER		☐	EHS_PARTNER	☐	Waste Management Business Partner
33	INTAPPNO	EWA_ORDER_OBJECT	INTAPPNO		☐	EWA_EHS_APPNOINT	☐	Waste Approval
34	APPNO	EWA_ORDER_OBJECT	APPNO		☐	EWA_EHS_APPNO	☐	Authority-Assigned Waste Approval Number
35	E_WERKS	EWA_ORDER_OBJECT	E_WERKS		☐	WERKS_D	☐	Plant
36	E_LGORT	EWA_ORDER_OBJECT	E_LGORT		☐	LGORT_D	☐	Storage location
37	WASTE	EWA_ORDER_OBJECT	WASTE		☐	WASTE_TYPE	☐	Waste
38	SDPOSNR	EWA_ORDER_OBJECT	SDPOSNR		☐	POSNR	☐	Item number of the SD document
39	POBJNR	EWA_ORDER_OBJECT	POBJNR		☐	J_OBJNR	☐	Object number
40	HOBJNR	EWA_ORDER_HEAD	HOBJNR		☐	J_OBJNR	☐	Object number
41	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
42	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
43	PWINTERLEVEL	EWA_ORDER_OBJECT	WINTERLEVEL		☐	EEWA_WINTERLEVEL	☐	Winter Maintenance Level

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	464