SAP ABAP Table EWAROUTE (Header table of 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	TRANSP	Transparent table
Transparent table	EWAROUTE	Table Relationship Diagram
Short Description	Header table of route

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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

Foreign Keys

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

History

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