SAP ABAP Table EWAROUTE_MAIN (Fields for Route)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-WA (Application Component) Waste Management
     ⤷ EEWA (Package) IS-U: Waste Management

Basic Data

Table Category	INTTAB	Structure
Structure	EWAROUTE_MAIN	Table Relationship Diagram
Short Description	Fields for Route

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	ROUTE_TXT	☐	EROUTE_TXT	CHAR30	CHAR	30	0	Text for route
2	STICHTAG	☐	EGUELTIGVON	DATUM	DATS	8	0	Date from which the route is valid
3	WASTE_TYPE1	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	MARA
4	PRODUCT_AREA1	☐	PRODUCT_AREA	PRODUCT_ID	CHAR	2	0	Service Area	TPRDCTAREA
5	RESULTYP	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	TEWARESULT
6	PRODUCT_AREA2	☐	PRODUCT_AREA2	PRODUCT_ID	CHAR	2	0	Secondary service area	TPRDCTAREA
7	RESULTYP2	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	TEWARESULT
8	PRODUCT_AREA3	☐	PRODUCT_AREA3	PRODUCT_ID	CHAR	2	0	Tertiary service area	TPRDCTAREA
9	RESULTYP3	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	TEWARESULT
10	FLEET_CAT	☐	FLEET_CAT	EQART	CHAR	10	0	Vehicle Type	T370FLT
11	CAL_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
12	CORR_OPT	☐	CALCORR	CALCORR	CHAR	1	0	Correct non-workday
13	WASTE_CAL	☐	WASTE_CAL	CHAR8	CHAR	8	0	Waste Management Calendar as Template for Route	EWACALENDER
14	KOLONNE	☐	KOLONNE	ORGEH	NUMC	8	0	Resource master	T527X
15	KOLONNE_TXT	☐	KOLONNE_TXT	TEXT25	CHAR	25	0	Resource master text
16	STANDARDDRIVER	☐	STANDARDDRIVER	CR_OBJID	NUMC	8	0	Standard driver of route	CRID
17	EVOL_ROUTE_TARGE	☐	EVOL_ROUTE_TARGET	MENG13	QUAN	13	3	Planned volume of route
18	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
19	EPREM_ROUTE_TARG	☐	EPREMISE_TARGET	NUMC5	NUMC	5	0	Target Number of Premises
20	ECONT_ROUTE_TARG	☐	ECONT_ROUTE_TARGET	DEC5	DEC	5	0	Planned number of containers for route
21	ETIME_ROUTE_TARG	☐	ETIME_ROUTE_TARGET	TIME	TIMS	6	0	Planned duration of route
22	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	T006
23	EDIST_ROUTE_TARG	☐	EDIST_ROUTE_TARGET	MENG13	QUAN	13	3	Planned distance of route
24	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	T006
25	EWGHT_ROUTE_TARG	☐	EWGHT_ROUTE_TARGET	MENG13	QUAN	13	3	Planned weight of route
26	WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
27	WASTE_DISP_PLANT	☐	WASTE_DISP_PLANT	KUNNR	CHAR	10	0	Waste Disposal Facility	KNA1
28	REGIOGROUP	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	TE227
29	FORM_ALLORD	☐	FORM_ALLORD	FORMKEY	CHAR	30	0	Application Form "Waste Disposal Orders in Full"	EFRM
30	FORM_POSORD	☐	FORM_POSORD	FORMKEY	CHAR	30	0	Application Form "Waste Disposal Order Items"	EFRM
31	FORM_HEADORD	☐	FORM_HEADORD	FORMKEY	CHAR	30	0	Application Form "Waste Disposal Orders Cover Sheet"	EFRM
32	ESHIFT	☐	ESHIFT	CHAR4	CHAR	4	0	Shift	TEWASHIFTS
33	SHIFT_VON	☐	TIMEFROM		TIMS	6	0	Start time
34	SHIFT_BIS	☐	TIMETO		TIMS	6	0	End time
35	EPNT_ROUTE_TARG	☐	EPOINT_ROUTE_TARG	CHAR4	CHAR	4	0	Target Service Points for Route
36	FLEET_EQUNR1	☐	E_VEHICLE	EQUNR	CHAR	18	0	Vehicle Number (Equipment Number)	EQUI
37	ARBID1	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
38	ARBPL1	☐	ARBPL	ARBPL	CHAR	8	0	Work center
39	WERKS1	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
40	FLEET_EQUNR2	☐	E_VEHICLE	EQUNR	CHAR	18	0	Vehicle Number (Equipment Number)	EQUI
41	ARBID2	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
42	ARBPL2	☐	ARBPL	ARBPL	CHAR	8	0	Work center
43	WERKS2	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
44	FLEET_EQUNR3	☐	E_VEHICLE	EQUNR	CHAR	18	0	Vehicle Number (Equipment Number)	EQUI
45	ARBID3	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
46	ARBPL3	☐	ARBPL	ARBPL	CHAR	8	0	Work center
47	WERKS3	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
48	INACTIVE	☐	ROUTE_INACTIVE	KENNZX	CHAR	1	0	Indicator to Show Whether Route Has Been Deactivated
49	INACTIVE_DATE	☐	INACTIVE_DATE	DATUM	DATS	8	0	Date, From Which Route Is Inactive
50	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
51	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
52	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
53	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
54	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
55	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
56	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
57	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
58	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
59	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
60	DWERK	☐	DWERK	WERKS	CHAR	4	0	Delivering Plant	T001W
61	BEH_LGORT	☐	L_LGORT	LGORT	CHAR	4	0	Location: Storage location in plant	T001L
62	COSTCOL	☐	ECOSTCOL	ECOSTCOL	CHAR	2	0	Cost Collector for Waste Disposal Order
63	INITIAL_STATUS	☐	INITIAL_STATUS	INITIAL_STATUS	CHAR	4	0	Initial Status When Creating Waste Disposal Order
64	FRAKTION	☐	WASTETYPE	MATKL	CHAR	9	0	Waste Fraction	TEWAWASTE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EWAROUTE_MAIN	ARBID1	CRID	OBJID
2	EWAROUTE_MAIN	ARBID2	CRID	OBJID
3	EWAROUTE_MAIN	ARBID3	CRID	OBJID
4	EWAROUTE_MAIN	AUFNR	AUFK	AUFNR
5	EWAROUTE_MAIN	BEBER	T357	BEBER
6	EWAROUTE_MAIN	BEH_LGORT	T001L	LGORT
7	EWAROUTE_MAIN	BUKRS	T001	BUKRS
8	EWAROUTE_MAIN	CAL_ID	TFACD	IDENT
9	EWAROUTE_MAIN	DAUFN	AUFK	AUFNR
10	EWAROUTE_MAIN	DWERK	T001W	WERKS
11	EWAROUTE_MAIN	ESHIFT	TEWASHIFTS	ESHIFT		1	CN
12	EWAROUTE_MAIN	FLEET_CAT	T370FLT	FLEET_CAT
13	EWAROUTE_MAIN	FLEET_EQUNR1	EQUI	EQUNR
14	EWAROUTE_MAIN	FLEET_EQUNR2	EQUI	EQUNR
15	EWAROUTE_MAIN	FLEET_EQUNR3	EQUI	EQUNR
16	EWAROUTE_MAIN	FORM_ALLORD	EFRM	FORMKEY
17	EWAROUTE_MAIN	FORM_HEADORD	EFRM	FORMKEY
18	EWAROUTE_MAIN	FORM_POSORD	EFRM	FORMKEY
19	EWAROUTE_MAIN	FRAKTION	TEWAWASTE	MATKL
20	EWAROUTE_MAIN	GSBER	TGSB	GSBER
21	EWAROUTE_MAIN	KOKRS	TKA01	KOKRS
22	EWAROUTE_MAIN	KOLONNE	T527X	ORGEH
23	EWAROUTE_MAIN	KOSTL	CSKS	KOSTL
24	EWAROUTE_MAIN	MEDST	T006	MSEHI
25	EWAROUTE_MAIN	MEIZT	T006	MSEHI
26	EWAROUTE_MAIN	OBJNR	ONR00	OBJNR
27	EWAROUTE_MAIN	PRODUCT_AREA1	TPRDCTAREA	PRODUCT_AREA
28	EWAROUTE_MAIN	PRODUCT_AREA2	TPRDCTAREA	PRODUCT_AREA
29	EWAROUTE_MAIN	PRODUCT_AREA3	TPRDCTAREA	PRODUCT_AREA
30	EWAROUTE_MAIN	REGIOGROUP	TE227	REGPOLIT
31	EWAROUTE_MAIN	RESULTYP	TEWARESULT	RESULTYP
32	EWAROUTE_MAIN	RESULTYP2	TEWARESULT	RESULTYP
33	EWAROUTE_MAIN	RESULTYP3	TEWARESULT	RESULTYP
34	EWAROUTE_MAIN	STANDARDDRIVER	CRID	OBJID
35	EWAROUTE_MAIN	STORT	T499S	STAND
36	EWAROUTE_MAIN	SWERK	T001W	WERKS
37	EWAROUTE_MAIN	VOL_UNIT	T006	MSEHI
38	EWAROUTE_MAIN	WASTE_CAL	EWACALENDER	WASTE_CAL
39	EWAROUTE_MAIN	WASTE_DISP_PLANT	KNA1	KUNNR
40	EWAROUTE_MAIN	WASTE_TYPE1	MARA	MATNR
41	EWAROUTE_MAIN	WEIGHT_UNIT	T006	MSEHI
42	EWAROUTE_MAIN	WERKS1	T001W	WERKS
43	EWAROUTE_MAIN	WERKS3	T001W	WERKS

History

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