SAP ABAP Table V_ORDERALL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_ORDERALL   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  
2 ORDERNR EORDERNR EORDERNR CHAR 20   0   Internal Number for Identifying a Waste Disposal Order  
3 ORDER_LAUFNR ORDER_LAUFNR NUMC4 NUMC 4   0   Consecutive Number for Waste Disposal Order Item  
4 ORDER_DATE EORDER_DATE DATS DATS 8   0   Planned Date for the Execution of the Waste Disposal Order  
5 PLANED_START EWASTART UZEIT TIMS 6   0   Planned Start Time of Waste Disposal Order  
6 PLANED_END EWAEND UZEIT TIMS 6   0   Planned Finish Time of Waste Disposal Order  
7 ROUTE EROUTE EROUTE CHAR 10   0   Planned Waste Disposal Order Route  
8 TIMEFRAME TIMEFRAME TIMEFRAME CHAR 2   0   Service window  
9 START_TIME START_TIME UZEIT TIMS 6   0   Start time of a service window  
10 END_TIME STOP_TIME UZEIT TIMS 6   0   End of service window  
11 SERVFREQNR EOBJNR EOBJNR CHAR 10   0   Number of service frequency EWAOBJ
12 SDAUFNR VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
13 ADDRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
14 EORDER_STATUS EORDER_STATUS EORDER_STATUS CHAR 2   0   Status of the waste disposal order  
15 SERVFREQ_LFNR LAUFNR NUMC5 NUMC 5   0   Consecutive number of service frequency  
16 ROUTE_SEQUENCE ROUTE_SEQUENCE SEQUENCE CHAR 4   0   Number of stop in route  
17 BEH_TYPE BEH_TYPE MATNR CHAR 18   0   Container category MARA
18 SERNR GERNR GERNR CHAR 18   0   Serial Number  
19 SERVICE_TYPE SERVICE_TYPE SERVICE_TYPE CHAR 2   0   Service Type  
20 SMAUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
21 SERVLOC SERVLOC TPLNR CHAR 30   0   Location of Container IFLOT
22 ROB EEWA_CLEAN_ROB ROB CHAR 16   0   Cleaning Object  
23 CAPAB EEWA_CAPAB EEWA_CAPAB NUMC 10   0   Capacity Number  
24 WINTERLEVEL EEWA_WINTERLEVEL EEWA_WINTERLEVEL CHAR 3   0   Winter Maintenance Level  
25 EPROP EEWA_CLEAN_PROP EEWA_CLEAN_PROP CHAR 12   0   Property EEWA_PROP_H
26 KUNNR BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
27 ORDER_TYPE EORDER_TYPE EORDER_TYPE CHAR 2   0   Processing of Waste Disposal Order  
28 ROBTYP EEWA_ROB_ROBTYP ROBTYP CHAR 3   0   Cleaning object category  
29 BEHGRP BEHGRP DEVGRP CHAR 8   0   Container Group  
30 BELNR E_BELNR E_BELNR CHAR 12   0   Number of a billing document  
31 GGVERTRAG E_GUARANTOR_CONTRACT E_GUARANTOR_CONTRACT CHAR 18   0   Guarantor Contract  
32 EHS_PARTNER EHS_PARTNER EHS_PARTNER CHAR 10   0   Waste Management Business Partner  
33 INTAPPNO EWA_EHS_APPNOINT EWA_EHS_APPNOINT CHAR 10   0   Waste Approval  
34 APPNO EWA_EHS_APPNO EWA_EHS_APPNO CHAR 20   0   Authority-Assigned Waste Approval Number  
35 E_WERKS WERKS_D WERKS CHAR 4   0   Plant  
36 E_LGORT LGORT_D LGORT CHAR 4   0   Storage location  
37 WASTE WASTE_TYPE MATNR CHAR 18   0   Waste  
38 SDPOSNR POSNR POSNR NUMC 6   0   Item number of the SD document  
39 POBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number  
40 HOBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number  
41 STAT J_STATUS J_STATUS CHAR 5   0   Object status  
42 INACT J_INACT J_INACT CHAR 1   0   Indicator: Status Is Inactive  
43 PWINTERLEVEL EEWA_WINTERLEVEL EEWA_WINTERLEVEL CHAR 3   0   Winter Maintenance Level  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_ORDERALL BEH_TYPE MARA MATNR    
2 V_ORDERALL EPROP EEWA_PROP_H MANDT    
3 V_ORDERALL KUNNR BUT000 PARTNER    
4 V_ORDERALL SDAUFNR VBUK VBELN    
5 V_ORDERALL SERVFREQNR EWAOBJ OBJNR    
6 V_ORDERALL SERVLOC IFLOT TPLNR    
7 V_ORDERALL SMAUFNR AUFK AUFNR    
History
Last changed by/on SAP  20110901 
SAP Release Created in