SAP ABAP Table V_EWAOBJROUTE (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_EWAOBJROUTE   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 OBJNR EOBJNR EOBJNR CHAR 10   0   Number of service frequency EWAOBJ
3 LAUFNR LAUFNR NUMC5 NUMC 5   0   Consecutive number of service frequency  
4 BIS BISZEITSCH DATUM DATS 8   0   Date at Which a Time Slice Expires  
5 AB ABZEITSCH DATUM DATS 8   0   Date from which time slice is valid  
6 TIMEFRAME TIMEFRAME TIMEFRAME CHAR 2   0   Service window  
7 DATECHANGE KENNZDATE KENNZX CHAR 1   0   Service frequency can be changed  
8 STARTTIME START_TIME UZEIT TIMS 6   0   Start time of a service window  
9 STOPTIME STOP_TIME UZEIT TIMS 6   0   End of service window  
10 ROUTE EROUTE EROUTE CHAR 10   0   Planned Waste Disposal Order Route  
11 ROUTE_SEQUENCE ROUTE_SEQUENCE SEQUENCE CHAR 4   0   Number of stop in route  
12 DATE_CONCRETE DATE8 DATE DATS 8   0   Date in CHAR format  
13 SEASON_FROM SEASON_FROM MMTT CHAR 4   0   Season start for waste disposal service  
14 SEASON_TO SEASON_TO MMTT CHAR 4   0   Season end for waste disposal service  
15 CAL_ID WFCID WFCID CHAR 2   0   Factory Calendar  
16 SFREPLACE E_SF_REPLACE CHAR1 CHAR 1   0   Indicator: override route using service frequency  
17 WEEKLY WEEKLY RYTHMUS CHAR 2   0   Weekly Service Interval  
18 MONTHLY MONTHLY MONTHLY CHAR 2   0   Day in Month for Service  
19 MONTH_COUNT MONTH_COUNT MONTH_COUNT CHAR 2   0   Frequency of Service in Months  
20 DAY_TYPE DAY_TYPE DAY_TYPE CHAR 1   0   Type of Daily Service (Single/Periodic)  
21 DAY_FLAG DAY_FLAG KENNZX CHAR 1   0   Service for service frequency occurs daily  
22 WEEK_FLAG WEEK_FLAG KENNZX CHAR 1   0   Service for service frequency occurs weekly  
23 MNTH_FLAG MNTH_FLAG KENNZX CHAR 1   0   Service for service frequency occurs monthly  
24 FLAG1 KENNZX KENNZX CHAR 1   0   Indicators  
25 FLAG2 KENNZX KENNZX CHAR 1   0   Indicators  
26 FLAG3 KENNZX KENNZX CHAR 1   0   Indicators  
27 FLAG4 KENNZX KENNZX CHAR 1   0   Indicators  
28 FLAG5 KENNZX KENNZX CHAR 1   0   Indicators  
29 FLAG6 KENNZX KENNZX CHAR 1   0   Indicators  
30 FLAG7 KENNZX KENNZX CHAR 1   0   Indicators  
31 STARTDATE START DATE DATS 8   0   Start  
32 OBKNR OBJKNR OBJKN INT4 10   0   Object list number  
33 OBZAE OBJZA OBZAE INT4 10   0   Object list counters  
34 ANLAGE ANLAGE ANLAGE CHAR 10   0   Installation  
35 OPERAND E_OPERAND E_OPERAND CHAR 10   0   Operand  
36 OPLFDNR OPLFDNR LFDNR4 NUMC 4   0   Consecutive number of an operand  
37 SERVLOC SERVLOC TPLNR CHAR 30   0   Location of Container  
38 MATNR MATNR MATNR CHAR 18   0   Material Number  
39 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number  
40 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
41 WASTE_TYPE WASTE_TYPE MATNR CHAR 18   0   Waste  
42 BEH_TYPE BEH_TYPE MATNR CHAR 18   0   Container category  
43 ROUTE_MAIN EROUTE EROUTE CHAR 10   0   Planned Waste Disposal Order Route  
44 STATUS_SERV STATUS_SERV STATUS_SERV CHAR 2   0   Service Status  
45 STATUS_CUST STATUS_CUST CUSTSTAT CHAR 2   0   Customer Status  
46 PRODUCT_AREA PRODUCT_AREA PRODUCT_ID CHAR 2   0   Service Area  
47 LOGIKNR LOGIKNR LOGIKNR NUMC 18   0   Logical device number  
48 SERVICE_TYPE SERVICE_TYPE SERVICE_TYPE CHAR 2   0   Service Type  
49 CONT_COUNT CONT_COUNT E_FAKTOR INT4 10   0   Number of available containers  
50 EWEEKDAY EWEEKDAY SC_WEEKDAY NUMC 1   0   Weekday of Service  
51 ROB EEWA_CLEAN_ROB ROB CHAR 16   0   Cleaning Object  
52 WINTERLEVEL EEWA_WINTERLEVEL EEWA_WINTERLEVEL CHAR 3   0   Winter Maintenance Level  
53 FREQZUS E_FREQZUS E_FREQZUS CHAR 4   0   Service Interval Grouping  
54 DEVGRP BEHGRP DEVGRP CHAR 8   0   Container Group  
55 INTAPPNO EWA_EHS_APPNOINT EWA_EHS_APPNOINT CHAR 10   0   Waste Approval  
56 APPNO EWA_EHS_APPNO EWA_EHS_APPNO CHAR 20   0   Authority-Assigned Waste Approval Number  
57 RECN EWAEHS_GUID   CHAR 32   0   Unique ID Number for Integration with EHS  
58 WAKEYIDE EHS_WAKEYIDE TEXT132 CHAR 132   0   Waste Code  
59 WAKEYCATLG EHS_WAKEYCATLG TEXT132 CHAR 132   0   Waste Catalog  
60 MNAMIN EHS_MNAMIN MENG13 QUAN 13   3   Disposal Quantity (Planning)  
61 MNAMQIN EHS_MNAMQIN MEINS UNIT 3   0   Unit of Measure for Outgoing Quantity  
62 WASTE_FLAG WASTE_FLAG EWAORDER_RELEVANT CHAR 2   0   Order Relevance  
63 CAL_ID_RO WFCID WFCID CHAR 2   0   Factory Calendar TFACD
64 FLEET_EQUNR1 E_VEHICLE EQUNR CHAR 18   0   Vehicle Number (Equipment Number) EQUI
65 ARBID1 CR_OBJID CR_OBJID NUMC 8   0   Object ID of the resource CRID
66 FLEET_EQUNR2 E_VEHICLE EQUNR CHAR 18   0   Vehicle Number (Equipment Number) EQUI
67 ARBID2 CR_OBJID CR_OBJID NUMC 8   0   Object ID of the resource CRID
68 FLEET_EQUNR3 E_VEHICLE EQUNR CHAR 18   0   Vehicle Number (Equipment Number) EQUI
69 ARBID3 CR_OBJID CR_OBJID NUMC 8   0   Object ID of the resource CRID
70 ESHIFT ESHIFT CHAR4 CHAR 4   0   Shift TEWASHIFTS
71 ARBPL1 ARBPL ARBPL CHAR 8   0   Work center  
72 WERKS1 WERKS_D WERKS CHAR 4   0   Plant T001W
73 ARBPL2 ARBPL ARBPL CHAR 8   0   Work center  
74 WERKS2 WERKS_D WERKS CHAR 4   0   Plant  
75 ARBPL3 ARBPL ARBPL CHAR 8   0   Work center  
76 WERKS3 WERKS_D WERKS CHAR 4   0   Plant T001W
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_EWAOBJROUTE ARBID1 CRID OBJID    
2 V_EWAOBJROUTE ARBID2 CRID OBJID    
3 V_EWAOBJROUTE ARBID3 CRID OBJID    
4 V_EWAOBJROUTE CAL_ID_RO TFACD IDENT    
5 V_EWAOBJROUTE ESHIFT TEWASHIFTS ESHIFT 1 CN
6 V_EWAOBJROUTE FLEET_EQUNR1 EQUI EQUNR    
7 V_EWAOBJROUTE FLEET_EQUNR2 EQUI EQUNR    
8 V_EWAOBJROUTE FLEET_EQUNR3 EQUI EQUNR    
9 V_EWAOBJROUTE MANDT T000 MANDT    
10 V_EWAOBJROUTE OBJNR EWAOBJ OBJNR    
11 V_EWAOBJROUTE WERKS1 T001W WERKS    
12 V_EWAOBJROUTE WERKS3 T001W WERKS    
History
Last changed by/on SAP  20130529 
SAP Release Created in