EWAROUTE

Header table of route | #masterdata | Component: Waste Management
Column Name Description
MANDT FK Client
ROUTE Planned Waste Disposal Order Route
Column Name Description
Column Name Description
📏 Volume unit (VOL_UNIT):
EVOL_ROUTE_TARGE Planned volume of route
📏 Distance Unit of Measure (MEDST):
EDIST_ROUTE_TARG Planned distance of route
📏 Unit of weight (WEIGHT_UNIT):
EWGHT_ROUTE_TARG Planned weight of route
Column Name Description
STICHTAG Date from which the route is valid
ETIME_ROUTE_TARG Planned duration of route
SHIFT_VON Start time
SHIFT_BIS End time
INACTIVE_DATE Date, From Which Route Is Inactive
ERDAT Date on which the record was created
AEDAT Last Changed On
Column Name Description
CORR_OPT Correct non-workday Show values
INACTIVE Indicator to Show Whether Route Has Been Deactivated Show values
COSTCOL Cost Collector for Waste Disposal Order Show values
INITIAL_STATUS Initial Status When Creating Waste Disposal Order Show values
KOPFVERWIEGUNG Header Weighing Show values
POSVERWIEGUNG Item Weighing Show values
LOEVM Deletion Indicator Show values
Column Name Description Domain name
ROUTE_TXT Text for route CHAR30
KOLONNE_TXT Resource master text TEXT25
EPREM_ROUTE_TARG Target Number of Premises NUMC5
ECONT_ROUTE_TARG Planned number of containers for route DEC5
EPNT_ROUTE_TARG Target Service Points for Route CHAR4
ARBPL1 Work Center ARBPL
ARBPL2 Work Center ARBPL
WERKS2 Plant WERKS
ARBPL3 Work Center ARBPL
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
BEGRU Authorization Group BEGRU
Master Data Relations | to Other Relations ↓ Join Conditions
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • EWAROUTE.ARBID1 == CRID.OBJID
  • EWAROUTE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • EWAROUTE.MANDT == CRID.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • EWAROUTE.ARBID2 == CRID.OBJID
  • EWAROUTE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • EWAROUTE.MANDT == CRID.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • EWAROUTE.ARBID3 == CRID.OBJID
  • EWAROUTE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • EWAROUTE.MANDT == CRID.MANDT
Settlement order
  • Settlement order
  • Client
  • EWAROUTE.AUFNR == AUFK.AUFNR
  • EWAROUTE.MANDT == AUFK.MANDT
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • EWAROUTE.BEBER == T357.BEBER
  • EWAROUTE.MANDT == T357.MANDT
  • EWAROUTE.SWERK == T357.WERKS
Location: Storage location in plant
  • Location: Storage location in plant
  • Client
  • Delivering Plant
  • EWAROUTE.BEH_LGORT == T001L.LGORT
  • EWAROUTE.MANDT == T001L.MANDT
  • EWAROUTE.DWERK == T001L.WERKS
Company Code
  • EWAROUTE.MANDT == T001.MANDT
  • EWAROUTE.BUKRS == T001.BUKRS
Factory Calendar EWAROUTE.CAL_ID == TFACD.IDENT
Standing order number
  • Standing order number
  • Client
  • EWAROUTE.DAUFN == AUFK.AUFNR
  • EWAROUTE.MANDT == AUFK.MANDT
Delivering Plant
  • EWAROUTE.MANDT == T001W.MANDT
  • EWAROUTE.DWERK == T001W.WERKS
Shift
Vehicle Number (Equipment Number)
  • Vehicle Number (Equipment Number)
  • Client
  • EWAROUTE.FLEET_EQUNR1 == EQUI.EQUNR
  • EWAROUTE.MANDT == EQUI.MANDT
Vehicle Number (Equipment Number)
  • Vehicle Number (Equipment Number)
  • Client
  • EWAROUTE.FLEET_EQUNR2 == EQUI.EQUNR
  • EWAROUTE.MANDT == EQUI.MANDT
Vehicle Number (Equipment Number)
  • Vehicle Number (Equipment Number)
  • Client
  • EWAROUTE.FLEET_EQUNR3 == EQUI.EQUNR
  • EWAROUTE.MANDT == EQUI.MANDT
Application Form "Waste Disposal Orders in Full"
  • Application Form "Waste Disposal Orders in Full"
  • Client
  • EWAROUTE.FORM_ALLORD == EFRM.FORMKEY
  • EWAROUTE.MANDT == EFRM.CLIENT
Application Form "Waste Disposal Orders Cover Sheet"
  • Application Form "Waste Disposal Orders Cover Sheet"
  • Client
  • EWAROUTE.FORM_HEADORD == EFRM.FORMKEY
  • EWAROUTE.MANDT == EFRM.CLIENT
Application Form "Waste Disposal Order Items"
  • Application Form "Waste Disposal Order Items"
  • Client
  • EWAROUTE.FORM_POSORD == EFRM.FORMKEY
  • EWAROUTE.MANDT == EFRM.CLIENT
Business Area
  • EWAROUTE.MANDT == TGSB.MANDT
  • EWAROUTE.GSBER == TGSB.GSBER
Controlling Area
  • EWAROUTE.MANDT == TKA01.MANDT
  • EWAROUTE.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • EWAROUTE.MANDT == CSKS.MANDT
  • EWAROUTE.[column in domain "DATBI"] == CSKS.DATBI
  • EWAROUTE.KOSTL == CSKS.KOSTL
  • EWAROUTE.KOKRS == CSKS.KOKRS
Client EWAROUTE.MANDT == T000.MANDT
Service Area
Secondary service area
Tertiary service area
Standard driver of route
  • Standard driver of route
  • ?
  • Client
  • EWAROUTE.STANDARDDRIVER == CRID.OBJID
  • EWAROUTE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • EWAROUTE.MANDT == CRID.MANDT
Location of maintenance object
  • Location of maintenance object
  • Client
  • Maintenance Plant
  • EWAROUTE.STORT == T499S.STAND
  • EWAROUTE.MANDT == T499S.MANDT
  • EWAROUTE.SWERK == T499S.WERKS
Maintenance Plant
  • EWAROUTE.MANDT == T001W.MANDT
  • EWAROUTE.SWERK == T001W.WERKS
Waste Management Calendar as Template for Route
Waste
  • Waste
  • Client
  • EWAROUTE.WASTE_TYPE1 == MARA.MATNR
  • EWAROUTE.MANDT == MARA.MANDT
Plant
  • EWAROUTE.MANDT == T001W.MANDT
  • EWAROUTE.WERKS1 == T001W.WERKS
Plant
  • EWAROUTE.MANDT == T001W.MANDT
  • EWAROUTE.WERKS3 == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Fleet Object Type
  • EWAROUTE.MANDT == T370FLT.MANDT
  • EWAROUTE.FLEET_CAT == T370FLT.FLEET_CAT
Waste Fraction