SAP ABAP Table EWAEL_ROUTE (Routes)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	EWAEL_ROUTE	Table Relationship Diagram
Short Description	Routes

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EWAEL_ROUTE	ARBID1	CRID	OBJID
2	EWAEL_ROUTE	ARBID2	CRID	OBJID
3	EWAEL_ROUTE	ARBID3	CRID	OBJID
4	EWAEL_ROUTE	AUFNR	AUFK	AUFNR
5	EWAEL_ROUTE	BEBER	T357	BEBER
6	EWAEL_ROUTE	BEH_LGORT	T001L	LGORT
7	EWAEL_ROUTE	BUKRS	T001	BUKRS
8	EWAEL_ROUTE	CAL_ID	TFACD	IDENT
9	EWAEL_ROUTE	DAUFN	AUFK	AUFNR
10	EWAEL_ROUTE	DWERK	T001W	WERKS
11	EWAEL_ROUTE	ESHIFT	TEWASHIFTS	ESHIFT		1	CN
12	EWAEL_ROUTE	FLEET_CAT	T370FLT	FLEET_CAT
13	EWAEL_ROUTE	FLEET_EQUNR1	EQUI	EQUNR
14	EWAEL_ROUTE	FLEET_EQUNR2	EQUI	EQUNR
15	EWAEL_ROUTE	FLEET_EQUNR3	EQUI	EQUNR
16	EWAEL_ROUTE	FORM_ALLORD	EFRM	FORMKEY
17	EWAEL_ROUTE	FORM_HEADORD	EFRM	FORMKEY
18	EWAEL_ROUTE	FORM_POSORD	EFRM	FORMKEY
19	EWAEL_ROUTE	FRAKTION	TEWAWASTE	MATKL
20	EWAEL_ROUTE	GSBER	TGSB	GSBER
21	EWAEL_ROUTE	KOKRS	TKA01	KOKRS
22	EWAEL_ROUTE	KOSTL	CSKS	KOSTL
23	EWAEL_ROUTE	MANDT	T000	MANDT
24	EWAEL_ROUTE	OBJNR	ONR00	OBJNR
25	EWAEL_ROUTE	PRODUCT_AREA1	TPRDCTAREA	PRODUCT_AREA
26	EWAEL_ROUTE	PRODUCT_AREA2	TPRDCTAREA	PRODUCT_AREA
27	EWAEL_ROUTE	PRODUCT_AREA3	TPRDCTAREA	PRODUCT_AREA
28	EWAEL_ROUTE	ROUTE_WD	EWAROUTE	ROUTE
29	EWAEL_ROUTE	STANDARDDRIVER	CRID	OBJID
30	EWAEL_ROUTE	STORT	T499S	STAND
31	EWAEL_ROUTE	SWERK	T001W	WERKS
32	EWAEL_ROUTE	WASTE_CAL	EWACALENDER	WASTE_CAL
33	EWAEL_ROUTE	WASTE_LGORT_WD	T001L	LGORT
34	EWAEL_ROUTE	WASTE_TYPE1	MARA	MATNR
35	EWAEL_ROUTE	WASTE_WERKS_WD	T001W	WERKS
36	EWAEL_ROUTE	WDPLANT_WD	EWA_EL_WDPLANT	MANDT
37	EWAEL_ROUTE	WERKS1	T001W	WERKS
38	EWAEL_ROUTE	WERKS3	T001W	WERKS

History

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