SAP ABAP Table V_CAPAROUTE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_CAPAROUTE	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_CAPAROUTE	ARBID1	CRID	OBJID
2	V_CAPAROUTE	ARBID2	CRID	OBJID
3	V_CAPAROUTE	ARBID3	CRID	OBJID
4	V_CAPAROUTE	CAL_ID	TFACD	IDENT
5	V_CAPAROUTE	ESHIFT	TEWASHIFTS	ESHIFT		1	CN
6	V_CAPAROUTE	FLEET_CAT	T370FLT	FLEET_CAT
7	V_CAPAROUTE	FLEET_EQUNR1	EQUI	EQUNR
8	V_CAPAROUTE	FLEET_EQUNR2	EQUI	EQUNR
9	V_CAPAROUTE	FLEET_EQUNR3	EQUI	EQUNR
10	V_CAPAROUTE	FORM_ALLORD	EFRM	FORMKEY
11	V_CAPAROUTE	FORM_HEADORD	EFRM	FORMKEY
12	V_CAPAROUTE	FORM_POSORD	EFRM	FORMKEY
13	V_CAPAROUTE	PRODUCT_AREA	TPRDCTAREA	PRODUCT_AREA
14	V_CAPAROUTE	PRODUCT_AREA1	TPRDCTAREA	PRODUCT_AREA
15	V_CAPAROUTE	PRODUCT_AREA2	TPRDCTAREA	PRODUCT_AREA
16	V_CAPAROUTE	PRODUCT_AREA3	TPRDCTAREA	PRODUCT_AREA
17	V_CAPAROUTE	REGIOGROUP_KEY	TE227	REGPOLIT
18	V_CAPAROUTE	STANDARDDRIVER	CRID	OBJID
19	V_CAPAROUTE	WASTE_CAL	EWACALENDER	WASTE_CAL
20	V_CAPAROUTE	WASTE_TYPE1	MARA	MATNR
21	V_CAPAROUTE	WERKS1	T001W	WERKS
22	V_CAPAROUTE	WERKS3	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in