SAP ABAP View V_EWAOBJROUTE (Route View with Service Frequency)

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_EWAOBJROUTE
Short Description	Route View with Service Frequency
Root table	EWAOBJH	Service Frequency -> Services (History for EWAOBJ)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EWAOBJH	EWAOBJH
2	EWAOBJ
3	EWAROUTE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EWAOBJ	MANDT	JL	EQ				0	0
2	EWAOBJH	MANDT	JR	EQ			AND	0	0
3	EWAOBJ	OBJNR	JL	EQ				0	0
4	EWAOBJH	OBJNR	JR	EQ			AND	0	0
5	EWAROUTE	ROUTE	JL	EQ				0	0
6	EWAOBJ	ROUTE_MAIN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EWAOBJ	MANDT		☐	MANDT	☐	Client
2	OBJNR	EWAOBJH	OBJNR		☐	EOBJNR	☐	Number of service frequency
3	LAUFNR	EWAOBJH	LAUFNR		☐	LAUFNR	☐	Consecutive number of service frequency
4	BIS	EWAOBJH	BIS		☐	BISZEITSCH	☐	Date at Which a Time Slice Expires
5	AB	EWAOBJH	AB		☐	ABZEITSCH	☐	Date from which time slice is valid
6	TIMEFRAME	EWAOBJH	TIMEFRAME		☐	TIMEFRAME	☐	Service window
7	DATECHANGE	EWAOBJH	DATECHANGE		☐	KENNZDATE	☐	Service frequency can be changed
8	STARTTIME	EWAOBJH	STARTTIME		☐	START_TIME	☐	Start time of a service window
9	STOPTIME	EWAOBJH	STOPTIME		☐	STOP_TIME	☐	End of service window
10	ROUTE	EWAOBJH	ROUTE		☐	EROUTE	☐	Planned Waste Disposal Order Route
11	ROUTE_SEQUENCE	EWAOBJH	ROUTE_SEQUENCE		☐	ROUTE_SEQUENCE	☐	Number of stop in route
12	DATE_CONCRETE	EWAOBJH	DATE_CONCRETE		☐	DATE8	☐	Date in CHAR format
13	SEASON_FROM	EWAOBJH	SEASON_FROM		☐	SEASON_FROM	☐	Season start for waste disposal service
14	SEASON_TO	EWAOBJH	SEASON_TO		☐	SEASON_TO	☐	Season end for waste disposal service
15	CAL_ID	EWAOBJH	CAL_ID		☐	WFCID	☐	Factory Calendar
16	SFREPLACE	EWAOBJH	SFREPLACE		☐	E_SF_REPLACE	☐	Indicator: override route using service frequency
17	WEEKLY	EWAOBJH	WEEKLY		☐	WEEKLY	☐	Weekly Service Interval
18	MONTHLY	EWAOBJH	MONTHLY		☐	MONTHLY	☐	Day in Month for Service
19	MONTH_COUNT	EWAOBJH	MONTH_COUNT		☐	MONTH_COUNT	☐	Frequency of Service in Months
20	DAY_TYPE	EWAOBJH	DAY_TYPE		☐	DAY_TYPE	☐	Type of Daily Service (Single/Periodic)
21	DAY_FLAG	EWAOBJH	DAY_FLAG		☐	DAY_FLAG	☐	Service for service frequency occurs daily
22	WEEK_FLAG	EWAOBJH	WEEK_FLAG		☐	WEEK_FLAG	☐	Service for service frequency occurs weekly
23	MNTH_FLAG	EWAOBJH	MNTH_FLAG		☐	MNTH_FLAG	☐	Service for service frequency occurs monthly
24	FLAG1	EWAOBJH	FLAG1		☐	KENNZX	☐	Indicators
25	FLAG2	EWAOBJH	FLAG2		☐	KENNZX	☐	Indicators
26	FLAG3	EWAOBJH	FLAG3		☐	KENNZX	☐	Indicators
27	FLAG4	EWAOBJH	FLAG4		☐	KENNZX	☐	Indicators
28	FLAG5	EWAOBJH	FLAG5		☐	KENNZX	☐	Indicators
29	FLAG6	EWAOBJH	FLAG6		☐	KENNZX	☐	Indicators
30	FLAG7	EWAOBJH	FLAG7		☐	KENNZX	☐	Indicators
31	STARTDATE	EWAOBJH	STARTDATE		☐	START	☐	Start
32	OBKNR	EWAOBJ	OBKNR		☐	OBJKNR	☐	Object list number
33	OBZAE	EWAOBJ	OBZAE		☐	OBJZA	☐	Object list counters
34	ANLAGE	EWAOBJ	ANLAGE		☐	ANLAGE	☐	Installation
35	OPERAND	EWAOBJ	OPERAND		☐	E_OPERAND	☐	Operand
36	OPLFDNR	EWAOBJ	OPLFDNR		☐	OPLFDNR	☐	Consecutive number of an operand
37	SERVLOC	EWAOBJ	SERVLOC		☐	SERVLOC	☐	Location of Container
38	MATNR	EWAOBJ	MATNR		☐	MATNR	☐	Material Number
39	EQUNR	EWAOBJ	EQUNR		☐	EQUNR	☐	Equipment Number
40	ADRNR	EWAOBJ	ADRNR		☐	AD_ADDRNUM	☐	Address number
41	WASTE_TYPE	EWAOBJ	WASTE_TYPE		☐	WASTE_TYPE	☐	Waste
42	BEH_TYPE	EWAOBJ	BEH_TYPE		☐	BEH_TYPE	☐	Container category
43	ROUTE_MAIN	EWAOBJ	ROUTE_MAIN		☐	EROUTE	☐	Planned Waste Disposal Order Route
44	STATUS_SERV	EWAOBJH	STATUS_SERV		☐	STATUS_SERV	☐	Service Status
45	STATUS_CUST	EWAOBJH	STATUS_CUST		☐	STATUS_CUST	☐	Customer Status
46	PRODUCT_AREA	EWAOBJH	PRODUCT_AREA		☐	PRODUCT_AREA	☐	Service Area
47	LOGIKNR	EWAOBJ	LOGIKNR		☐	LOGIKNR	☐	Logical device number
48	SERVICE_TYPE	EWAOBJH	SERVICE_TYPE		☐	SERVICE_TYPE	☐	Service Type
49	CONT_COUNT	EWAOBJH	CONT_COUNT		☐	CONT_COUNT	☐	Number of available containers
50	EWEEKDAY	EWAOBJH	EWEEKDAY		☐	EWEEKDAY	☐	Weekday of Service
51	ROB	EWAOBJ	ROB		☐	EEWA_CLEAN_ROB	☐	Cleaning Object
52	WINTERLEVEL	EWAOBJ	WINTERLEVEL		☐	EEWA_WINTERLEVEL	☐	Winter Maintenance Level
53	FREQZUS	EWAOBJH	FREQZUS		☐	E_FREQZUS	☐	Service Interval Grouping
54	DEVGRP	EWAOBJ	DEVGRP		☐	BEHGRP	☐	Container Group
55	INTAPPNO	EWAOBJ	INTAPPNO		☐	EWA_EHS_APPNOINT	☐	Waste Approval
56	APPNO	EWAOBJ	APPNO		☐	EWA_EHS_APPNO	☐	Authority-Assigned Waste Approval Number
57	RECN	EWAOBJ	RECN		☐	EWAEHS_GUID	☐	Unique ID Number for Integration with EHS
58	WAKEYIDE	EWAOBJ	WAKEYIDE		☐	EHS_WAKEYIDE	☐	Waste Code
59	WAKEYCATLG	EWAOBJ	WAKEYCATLG		☐	EHS_WAKEYCATLG	☐	Waste Catalog
60	MNAMIN	EWAOBJ	MNAMIN		☐	EHS_MNAMIN	☐	Disposal Quantity (Planning)
61	MNAMQIN	EWAOBJ	MNAMQIN		☐	EHS_MNAMQIN	☐	Unit of Measure for Outgoing Quantity
62	WASTE_FLAG	EWAOBJH	WASTE_FLAG		☐	WASTE_FLAG	☐	Order Relevance
63	CAL_ID_RO	EWAROUTE	CAL_ID		☐	WFCID	☐	Factory Calendar
64	FLEET_EQUNR1	EWAROUTE	FLEET_EQUNR1		☐	E_VEHICLE	☐	Vehicle Number (Equipment Number)
65	ARBID1	EWAROUTE	ARBID1		☐	CR_OBJID	☐	Object ID of the resource
66	FLEET_EQUNR2	EWAROUTE	FLEET_EQUNR2		☐	E_VEHICLE	☐	Vehicle Number (Equipment Number)
67	ARBID2	EWAROUTE	ARBID2		☐	CR_OBJID	☐	Object ID of the resource
68	FLEET_EQUNR3	EWAROUTE	FLEET_EQUNR3		☐	E_VEHICLE	☐	Vehicle Number (Equipment Number)
69	ARBID3	EWAROUTE	ARBID3		☐	CR_OBJID	☐	Object ID of the resource
70	ESHIFT	EWAROUTE	ESHIFT		☐	ESHIFT	☐	Shift
71	ARBPL1	EWAROUTE	ARBPL1		☐	ARBPL	☐	Work center
72	WERKS1	EWAROUTE	WERKS1		☐	WERKS_D	☐	Plant
73	ARBPL2	EWAROUTE	ARBPL2		☐	ARBPL	☐	Work center
74	WERKS2	EWAROUTE	WERKS2		☐	WERKS_D	☐	Plant
75	ARBPL3	EWAROUTE	ARBPL3		☐	ARBPL	☐	Work center
76	WERKS3	EWAROUTE	WERKS3		☐	WERKS_D	☐	Plant

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	471