SAP ABAP View V_CAPAROUTE (View: Routes Allocated to Capacities)

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_CAPAROUTE
Short Description	View: Routes Allocated to Capacities
Root table	EEWA_CAPAB_ROUTE	IS-U Waste: Capacity Planning - Routes

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EEWA_CAPAB_ROUTE	EEWA_CAPAB_ROUTE
2	EWAROUTE
3	EEWA_CAPAB_KEY

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EEWA_CAPAB_ROUTE	ROUTE	JL	EQ				0	0
2	EWAROUTE	ROUTE	JR	EQ			AND	0	0
3	EEWA_CAPAB_ROUTE	MANDT	JL	EQ				0	0
4	EWAROUTE	MANDT	JR	EQ			AND	0	0
5	EEWA_CAPAB_KEY	CAPAB	JL	EQ				0	0
6	EEWA_CAPAB_ROUTE	CAPAB	JR	EQ			AND	0	0
7	EEWA_CAPAB_KEY	MANDT	JL	EQ				0	0
8	EEWA_CAPAB_ROUTE	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EEWA_CAPAB_ROUTE	MANDT		☐	MANDT	☐	Client
2	CAPAB	EEWA_CAPAB_ROUTE	CAPAB		☐	EEWA_CAPAB	☐	Capacity Number
3	ROUTE	EEWA_CAPAB_ROUTE	ROUTE		☐	EROUTE	☐	Planned Waste Disposal Order Route
4	CDATE	EEWA_CAPAB_KEY	CDATE		☐	DATUM	☐	Date
5	PRODUCT_AREA	EEWA_CAPAB_KEY	PRODUCT_AREA		☐	PRODUCT_AREA	☐	Service Area
6	REGIOGROUP_KEY	EEWA_CAPAB_KEY	REGIOGROUP		☐	REGPOLIT	☐	Political regional structure element
7	ROUTE_TXT	EWAROUTE	ROUTE_TXT		☐	EROUTE_TXT	☐	Text for route
8	STICHTAG	EWAROUTE	STICHTAG		☐	EGUELTIGVON	☐	Date from which the route is valid
9	WASTE_TYPE1	EWAROUTE	WASTE_TYPE1		☐	WASTE_TYPE	☐	Waste
10	PRODUCT_AREA1	EWAROUTE	PRODUCT_AREA1		☐	PRODUCT_AREA	☐	Service Area
11	RESULTYP	EWAROUTE	RESULTYP		☐	ERESULT	☐	Confirmation category
12	PRODUCT_AREA2	EWAROUTE	PRODUCT_AREA2		☐	PRODUCT_AREA2	☐	Secondary service area
13	RESULTYP2	EWAROUTE	RESULTYP2		☐	ERESULT	☐	Confirmation category
14	PRODUCT_AREA3	EWAROUTE	PRODUCT_AREA3		☐	PRODUCT_AREA3	☐	Tertiary service area
15	RESULTYP3	EWAROUTE	RESULTYP3		☐	ERESULT	☐	Confirmation category
16	FLEET_CAT	EWAROUTE	FLEET_CAT		☐	FLEET_CAT	☐	Vehicle Type
17	CAL_ID	EWAROUTE	CAL_ID		☐	WFCID	☐	Factory Calendar
18	CORR_OPT	EWAROUTE	CORR_OPT		☐	CALCORR	☐	Correct non-workday
19	WASTE_CAL	EWAROUTE	WASTE_CAL		☐	WASTE_CAL	☐	Waste Management Calendar as Template for Route
20	KOLONNE	EWAROUTE	KOLONNE		☐	KOLONNE	☐	Resource master
21	KOLONNE_TXT	EWAROUTE	KOLONNE_TXT		☐	KOLONNE_TXT	☐	Resource master text
22	STANDARDDRIVER	EWAROUTE	STANDARDDRIVER		☐	STANDARDDRIVER	☐	Standard driver of route
23	EVOL_ROUTE_TARGE	EWAROUTE	EVOL_ROUTE_TARGE		☐	EVOL_ROUTE_TARGET	☐	Planned volume of route
24	VOL_UNIT	EWAROUTE	VOL_UNIT		☐	VOL_UNIT	☐	Volume unit
25	EPREM_ROUTE_TARG	EWAROUTE	EPREM_ROUTE_TARG		☐	EPREMISE_TARGET	☐	Target Number of Premises
26	ECONT_ROUTE_TARG	EWAROUTE	ECONT_ROUTE_TARG		☐	ECONT_ROUTE_TARGET	☐	Planned number of containers for route
27	ETIME_ROUTE_TARG	EWAROUTE	ETIME_ROUTE_TARG		☐	ETIME_ROUTE_TARGET	☐	Planned duration of route
28	MEIZT	EWAROUTE	MEIZT		☐	MEIZT	☐	Unit of measure for travelling times
29	EDIST_ROUTE_TARG	EWAROUTE	EDIST_ROUTE_TARG		☐	EDIST_ROUTE_TARGET	☐	Planned distance of route
30	MEDST	EWAROUTE	MEDST		☐	MEDST	☐	Unit of measure for distance
31	EWGHT_ROUTE_TARG	EWAROUTE	EWGHT_ROUTE_TARG		☐	EWGHT_ROUTE_TARGET	☐	Planned weight of route
32	WEIGHT_UNIT	EWAROUTE	WEIGHT_UNIT		☐	WEIGHT_UNIT	☐	Unit of weight
33	WASTE_DISP_PLANT	EWAROUTE	WASTE_DISP_PLANT		☐	WASTE_DISP_PLANT	☐	Waste Disposal Facility
34	REGIOGROUP	EWAROUTE	REGIOGROUP		☐	REGPOLIT	☐	Political regional structure element
35	FORM_ALLORD	EWAROUTE	FORM_ALLORD		☐	FORM_ALLORD	☐	Application Form "Waste Disposal Orders in Full"
36	FORM_POSORD	EWAROUTE	FORM_POSORD		☐	FORM_POSORD	☐	Application Form "Waste Disposal Order Items"
37	FORM_HEADORD	EWAROUTE	FORM_HEADORD		☐	FORM_HEADORD	☐	Application Form "Waste Disposal Orders Cover Sheet"
38	ESHIFT	EWAROUTE	ESHIFT		☐	ESHIFT	☐	Shift
39	SHIFT_VON	EWAROUTE	SHIFT_VON		☐	TIMEFROM	☐	Start time
40	SHIFT_BIS	EWAROUTE	SHIFT_BIS		☐	TIMETO	☐	End time
41	EPNT_ROUTE_TARG	EWAROUTE	EPNT_ROUTE_TARG		☐	EPOINT_ROUTE_TARG	☐	Target Service Points for Route
42	FLEET_EQUNR1	EWAROUTE	FLEET_EQUNR1		☐	E_VEHICLE	☐	Vehicle Number (Equipment Number)
43	ARBID1	EWAROUTE	ARBID1		☐	CR_OBJID	☐	Object ID of the resource
44	ARBPL1	EWAROUTE	ARBPL1		☐	ARBPL	☐	Work center
45	WERKS1	EWAROUTE	WERKS1		☐	WERKS_D	☐	Plant
46	FLEET_EQUNR2	EWAROUTE	FLEET_EQUNR2		☐	E_VEHICLE	☐	Vehicle Number (Equipment Number)
47	ARBID2	EWAROUTE	ARBID2		☐	CR_OBJID	☐	Object ID of the resource
48	ARBPL2	EWAROUTE	ARBPL2		☐	ARBPL	☐	Work center
49	WERKS2	EWAROUTE	WERKS2		☐	WERKS_D	☐	Plant
50	FLEET_EQUNR3	EWAROUTE	FLEET_EQUNR3		☐	E_VEHICLE	☐	Vehicle Number (Equipment Number)
51	ARBID3	EWAROUTE	ARBID3		☐	CR_OBJID	☐	Object ID of the resource
52	ARBPL3	EWAROUTE	ARBPL3		☐	ARBPL	☐	Work center
53	WERKS3	EWAROUTE	WERKS3		☐	WERKS_D	☐	Plant
54	ERDAT	EWAROUTE	ERDAT		☐	ERDAT	☐	Date on which the record was created
55	ERNAM	EWAROUTE	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
56	AEDAT	EWAROUTE	AEDAT		☐	AEDAT	☐	Last Changed On
57	AENAM	EWAROUTE	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
58	BEGRU	EWAROUTE	BEGRU		☐	BEGRU	☐	Authorization Group
59	LOEVM	EWAROUTE	LOEVM		☐	LOEVM	☐	Deletion Indicator

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	463