EWAROUTE SAP (Header table of route) Table details

Dictionary Type: Table
Description: Header table of route




ABAP Code to SELECT data from EWAROUTE
Related tables to EWAROUTE
Access table EWAROUTE




Table field list including key, data, relationships and ABAP select examples

EWAROUTE is a standard SAP Table which is used to store Header table of route data and is available within R/3 SAP systems depending on the version and release level.

The EWAROUTE table consists of various fields, each holding specific information or linking keys about Header table of route data available in SAP. These include ROUTE (Planned Waste Disposal Order Route), ROUTE_TXT (Text for route), STICHTAG (Date from which the route is valid), WASTE_TYPE1 (Waste).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EWAROUTE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ROUTEPlanned Waste Disposal Order Route EROUTECHAR10ALPHAEROUTEEROUTEEROUTE_MAIN
ROUTE_TXTText for route EROUTE_TXTCHAR30CHAR30
STICHTAGDate from which the route is valid EGUELTIGVONDATS8DATUM
WASTE_TYPE1Waste WASTE_TYPECHAR18MARAMATN1MATNRMATMAT1
PRODUCT_AREA1Service Area PRODUCT_AREACHAR2TPRDCTAREAPRODUCT_ID
RESULTYPConfirmation category ERESULTCHAR2Assigned to domainERESULT_ID
PRODUCT_AREA2Secondary service area PRODUCT_AREA2CHAR2TPRDCTAREAPRODUCT_ID
RESULTYP2Confirmation category ERESULTCHAR2Assigned to domainERESULT_ID
PRODUCT_AREA3Tertiary service area PRODUCT_AREA3CHAR2TPRDCTAREAPRODUCT_ID
RESULTYP3Confirmation category ERESULTCHAR2Assigned to domainERESULT_ID
FLEET_CATVehicle Type FLEET_CATCHAR10T370FLTEQARTFLEET_CAT
CAL_IDFactory Calendar WFCIDCHAR2TFACDWFCIDFCI
CORR_OPTCorrect non-workday CALCORRCHAR1CALCORR
WASTE_CALWaste Management Calendar as Template for Route WASTE_CALCHAR8EWACALENDERCHAR8ECAL
KOLONNEResource master KOLONNENUMC8Assigned to domainORGEH
KOLONNE_TXTResource master text KOLONNE_TXTCHAR25TEXT25
STANDARDDRIVERStandard driver of route STANDARDDRIVERNUMC8CRIDCR_OBJID
EVOL_ROUTE_TARGEPlanned volume of route EVOL_ROUTE_TARGETQUAN13(3) MENG13
VOL_UNITVolume unit VOL_UNITUNIT3Assigned to domainCUNITMEINS
EPREM_ROUTE_TARGTarget Number of Premises EPREMISE_TARGETNUMC5NUMC5
ECONT_ROUTE_TARGPlanned number of containers for route ECONT_ROUTE_TARGETDEC5DEC5
ETIME_ROUTE_TARGPlanned duration of route ETIME_ROUTE_TARGETTIMS6TIME
MEIZTUnit of measure for travelling times MEIZTUNIT3Assigned to domainCUNITMEINS
EDIST_ROUTE_TARGPlanned distance of route EDIST_ROUTE_TARGETQUAN13(3) MENG13
MEDSTUnit of measure for distance MEDSTUNIT3Assigned to domainCUNITMEINS
EWGHT_ROUTE_TARGPlanned weight of route EWGHT_ROUTE_TARGETQUAN13(3) MENG13
WEIGHT_UNITUnit of weight WEIGHT_UNITUNIT3Assigned to domainCUNITMEINS
WASTE_DISP_PLANTWaste Disposal Facility WASTE_DISP_PLANTCHAR10Assigned to domainALPHAKUNNRKUNDEBI
REGIOGROUPPolitical regional structure element REGPOLITCHAR8Assigned to domainREGPOLITTE227
FORM_ALLORDApplication Form 'Waste Disposal Orders in Full' FORM_ALLORDCHAR30EFRMFORMKEY
FORM_POSORDApplication Form 'Waste Disposal Order Items' FORM_POSORDCHAR30EFRMFORMKEY
FORM_HEADORDApplication Form 'Waste Disposal Orders Cover Sheet' FORM_HEADORDCHAR30EFRMFORMKEY
ESHIFTShift ESHIFTCHAR4TEWASHIFTSCHAR4
SHIFT_VONStart time TIMEFROMTIMS6
SHIFT_BISEnd time TIMETOTIMS6
EPNT_ROUTE_TARGTarget Service Points for Route EPOINT_ROUTE_TARGCHAR4CHAR4
FLEET_EQUNR1Vehicle Number (Equipment Number) E_VEHICLECHAR18EQUIALPHAEQUNREQNEQUI
ARBID1Object ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
ARBPL1Work center ARBPLCHAR8ARBPLAGR
WERKS1Plant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
FLEET_EQUNR2Vehicle Number (Equipment Number) E_VEHICLECHAR18EQUIALPHAEQUNREQNEQUI
ARBID2Object ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
ARBPL2Work center ARBPLCHAR8ARBPLAGR
WERKS2Plant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
FLEET_EQUNR3Vehicle Number (Equipment Number) E_VEHICLECHAR18EQUIALPHAEQUNREQNEQUI
ARBID3Object ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
ARBPL3Work center ARBPLCHAR8ARBPLAGR
WERKS3Plant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
INACTIVEIndicator to Show Whether Route Has Been Deactivated ROUTE_INACTIVECHAR1KENNZX
INACTIVE_DATEDate, From Which Route Is Inactive INACTIVE_DATEDATS8DATUM
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
SWERKMaintenance plant SWERKCHAR4T001WWERKSSWK
STORTLocation of maintenance object PMLOCCHAR10T499SAP_STAND
BEBERPlant section BEBERCHAR3T357BEBERBBE
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
DAUFNStanding order number DAUFNCHAR12AUFKALPHAAUFNRORDP
AUFNRSettlement order ILOM_ORDSTCHAR12AUFKALPHAAUFNRORDE
DWERKDelivering Plant DWERKCHAR4T001WWERKS
BEH_LGORTLocation: Storage location in plant L_LGORTCHAR4T001LLGORTLAG
COSTCOLCost Collector for Waste Disposal Order ECOSTCOLCHAR2ECOSTCOL
INITIAL_STATUSInitial Status When Creating Waste Disposal Order INITIAL_STATUSCHAR4INITIAL_STATUS
FRAKTIONWaste Fraction WASTETYPECHAR9TEWAWASTEMATKL
KOPFVERWIEGUNGHeader Weighing EEWA_VERWKOPFCHAR1EEWA_VERWIEGUNGOK
POSVERWIEGUNGItem Weighing EEWA_VERWPOSCHAR1EEWA_VERWIEGUNGOK
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion Indicator LOEVMCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table EWAROUTE using ABAP code

The following ABAP code Example will allow you to do a basic selection on EWAROUTE to SELECT all data from the table
DATA: WA_EWAROUTE TYPE EWAROUTE.

SELECT SINGLE *
FROM EWAROUTE
INTO CORRESPONDING FIELDS OF WA_EWAROUTE
WHERE...

How to access SAP table EWAROUTE

Within an ECC or HANA version of SAP you can also view further information about EWAROUTE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!