SAP ABAP Table /DSD/RP_VTTK_ALV (Transmission Structure for General List View (ALV))
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   LE-DSD-RP (Application Component) Transportation Planning
     /DSD/RP (Package) Transportation planning
Basic Data
Table Category INTTAB    Structure 
Structure /DSD/RP_VTTK_ALV   Table Relationship Diagram
Short Description Transmission Structure for General List View (ALV)    
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 .INCLUDE       0   0   Transmission Structure for General List View (ALV)  
2 .INCLUDE       0   0   Shipment Header  
3 MANDT MANDT MANDT CLNT 3   0   Client T000
4 TKNUM TKNUM TKNUM CHAR 10   0   Shipment Number *
5 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
6 SHTYP SHTYP SHTYP CHAR 4   0   Shipment type TVTK
7 TPLST TPLST TPLST CHAR 4   0   Transportation planning point TTDS
8 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
9 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
10 ERZET ERZET UZEIT TIMS 6   0   Entry time  
11 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
12 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
13 AEZET AEZET UZEIT TIMS 6   0   Time last change was made  
14 STERM STERM STERM CHAR 1   0   Leg determination  
15 ABFER ABFER ABFER CHAR 1   0   Shipment completion type  
16 ABWST ABWST ABWST CHAR 1   0   Processing control  
17 BFART BFART BFART CHAR 1   0   Service level  
18 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
19 VSAVL VSAVL VERSART CHAR 2   0   Shipping type of preliminary leg T173
20 VSANL VSANL VERSART CHAR 2   0   Shipping type of subsequent leg T173
21 LAUFK LAUFK LAUFK CHAR 1   0   Leg Indicator  
22 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
23 ROUTE ROUTR ROUTE CHAR 6   0   Shipment route TVRO
24 SIGNI SIGNI TEXT20 CHAR 20   0   Container ID  
25 EXTI1 EXTI1 TEXT20 CHAR 20   0   External identification 1  
26 EXTI2 EXTI2 TEXT20 CHAR 20   0   External identification 2  
27 TPBEZ TPBEZ TEXT20 CHAR 20   0   Description of Shipment  
28 STDIS STDIS STTRA CHAR 1   0   Status of transportation planning  
29 DTDIS DTDIS DATUM DATS 8   0   Date of end of planning  
30 UZDIS UZDIS UZEIT TIMS 6   0   Scheduling end time  
31 STREG STREG STTRA CHAR 1   0   Status of check-in  
32 DPREG DPREG DATUM DATS 8   0   Planned date of check-in  
33 UPREG UPREG UZEIT TIMS 6   0   Planned check-in time  
34 DAREG DAREG DATUM DATS 8   0   Actual date of check-in  
35 UAREG UAREG UZEIT TIMS 6   0   Current time of check-in  
36 STLBG STLBG STTRA CHAR 1   0   Status for start of loading  
37 DPLBG DPLBG DATUM DATS 8   0   Planned date for start of loading  
38 UPLBG UPLBG UZEIT TIMS 6   0   Planned loading start time  
39 DALBG DALBG DATUM DATS 8   0   Current date for start of loading  
40 UALBG UALBG UZEIT TIMS 6   0   Actual loading start time  
41 STLAD STLAD STTRA CHAR 1   0   Status for end of loading  
42 DPLEN DPLEND DATUM DATS 8   0   Planned date for end of loading  
43 UPLEN UPLEND UZEIT TIMS 6   0   Planned loading end time  
44 DALEN DALEND DATUM DATS 8   0   Actual date for end of loading  
45 UALEN UALEND UZEIT TIMS 6   0   Actual loading end time  
46 STABF STABF STTRA CHAR 1   0   Status of shipment completion  
47 DPABF DPABF DATUM DATS 8   0   Planned date for shipment completion  
48 UPABF UPABF UZEIT TIMS 6   0   Planned time for processing  
49 DTABF DTABF DATUM DATS 8   0   Current date of shipment completion  
50 UZABF UZABF UZEIT TIMS 6   0   Time of transportation processing  
51 STTBG STTBG STTRA CHAR 1   0   Status for start of shipment  
52 DPTBG DPTBG DATUM DATS 8   0   Planned date for start of shipment  
53 UPTBG UPTBG UZEIT TIMS 6   0   Planned transport start time  
54 DATBG DATBG DATUM DATS 8   0   Current date for start of shipment  
55 UATBG UATBG UZEIT TIMS 6   0   Actual transport start time  
56 STTEN STTEN STTRA CHAR 1   0   Status for end of shipment  
57 DPTEN DPTEN DATUM DATS 8   0   Planned date for end of shipment  
58 UPTEN UPTEN UZEIT TIMS 6   0   Planned transport end time  
59 DATEN DATEND DATUM DATS 8   0   Actual Date for End of Shipment  
60 UATEN UATEND UZEIT TIMS 6   0   Actual shipment end time  
61 STTRG STTRG STTRG CHAR 1   0   Overall transportation status  
62 TDLNR TDLNR LIFNR CHAR 10   0   Number of forwarding agent LFA1
63 TERNR AUFNR AUFNR CHAR 12   0   Order Number *
64 PKSTK PKSTK_VTTK XFELD CHAR 1   0   Shipment Contains Handling Units  
65 DTMEG DTMEG MEINS UNIT 3   0   Unit of Weight for Transportation Planning *
66 DTMEV DTMEV MEINS UNIT 3   0   Volume Unit for Transportation Planning *
67 DISTZ DISTZ MENG13 QUAN 13   3   Distance  
68 MEDST MEDST MEINS UNIT 3   0   Unit of measure for distance *
69 FAHZT FAHZT FAHZT QUAN 5   2   Travelling time only between two locations  
70 GESZT GESZT FAHZT QUAN 5   2   Total travelling time between two locations incl. breaks  
71 MEIZT MEIZT MEINS UNIT 3   0   Unit of measure for travelling times *
72 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
73 FBSTA FBSTA FBSTA CHAR 1   0   Status of shipment costs calculation  
74 FBGST FBGST FBGST CHAR 1   0   Overall status of calculation of shipment costs for shipment  
75 ARSTA ARSTA ARSTA CHAR 1   0   Status of shipment costs settlement  
76 ARGST ARGST ARGST CHAR 1   0   Total status of shipment costs settlement for shipment  
77 STERM_DONE STERM_DONE STERM_DONE CHAR 1   0   Leg determination complete  
78 VSE_FRK VSE_FRK VSE_FRK CHAR 1   0   Handling Unit Data are Referred in Shipment Cost Document  
79 KKALSM KALSM_KOPF KALSM CHAR 6   0   Pricing procedure in shipment header T683
80 SDABW SDABW SDABW CHAR 4   0   Special Processing Indicator TVSAK
81 FRKRL KFRKRL FRKRL CHAR 1   0   Shipment costs relevance  
82 GESZTD KP_GESZTDP TSTRDURAG DEC 11   0   Planned total time of transportation (in days)  
83 FAHZTD KP_EFFZTDP TSTRDURAN DEC 11   0   Planned duration of transportation (in hours:minutes)  
84 GESZTDA KP_GESZTDA TSTRDURAG DEC 11   0   Actual total time of shipment (in days)  
85 FAHZTDA KP_EFFZTDA TSTRDURAN DEC 11   0   Actual time needed for transporation (in hours:minutes)  
86 ROCPY_DONE ROCPY_DONE ROCPY_DONE CHAR 1   0   Route copied from delivery  
87 HANDLE TSEGGUID SYSUUID_22 CHAR 22   0   Globally unique identifier (linked to time segment, etc)  
88 TSEGFL TSEGEXISTS FLAG CHAR 1   0   Time segment exists  
89 TSEGTP TSEGTPLVTT TSEGTEMPLA CHAR 10   0   Time segment event group shipment header *
90 ADD01 VTTK_ADD01 VTTK_ADD01 CHAR 10   0   Suppl. 1 VTADD01
91 ADD02 VTTK_ADD02 VTTK_ADD02 CHAR 10   0   Suppl. 2 VTADD02
92 ADD03 VTTK_ADD03 VTTK_ADD03 CHAR 10   0   Suppl. 3 VTADD03
93 ADD04 VTTK_ADD04 VTTK_ADD04 CHAR 10   0   Suppl. 4 VTADD04
94 TEXT1 VTTK_TEXT1 TEXT40 CHAR 40   0   Addit.text 1  
95 TEXT2 VTTK_TEXT2 TEXT40 CHAR 40   0   Addit.text 2  
96 TEXT3 VTTK_TEXT3 TEXT40 CHAR 40   0   Addit.text 3  
97 TEXT4 VTTK_TEXT4 TEXT40 CHAR 40   0   Addit.text 4  
98 PROLI ADGE_PROLI ADGD_PROLI CHAR 3   0   Dangerous Goods Management Profile in SD Documents TDGC5
99 DGTLOCK ADGE_TLOCK X CHAR 1   0   Block Indicator for Dangerous Goods  
100 DGMDDAT ADGE_MDDAT DATUM DATS 8   0   Selection date dangerous goods master data  
101 CONT_DG ADGE_NCDG X CHAR 1   0   Indicator: Document contains dangerous goods  
102 WARZTD KP_WARZTDP TSTRDURAN DEC 11   0   Planned waiting time of shipment (in hours:minutes)  
103 WARZTDA KP_WARZTDA TSTRDURAN DEC 11   0   Current waiting time of shipment (in hours:minutes)  
104 AULWE AULWE AULWE CHAR 10   0   Route Schedule *
105 TNDRST TNDRST TNDRST CHAR 2   0   Tender Status  
106 TNDRRC TNDRRC TNDRRC CHAR 2   0   Acceptance Condition/Rejection Reason  
107 TNDR_TEXT TNDR_TEXT TEXT80 CHAR 80   0   Tendering Text  
108 TNDRDAT TNDRDAT DATUM DATS 8   0   Date of tender status  
109 TNDRZET TNDRZET UZEIT TIMS 6   0   Time of tender status  
110 TNDR_MAXP TNDR_MAXP WERT15 CURR 15   2   Maximum Price for Shipment  
111 TNDR_MAXC TNDR_MAXC WAERS CUKY 5   0   Currency of Maximum Price TCURC
112 TNDR_ACTP TNDR_ACTP WERT15 CURR 15   2   Actual Shipment Costs for Shipment  
113 TNDR_ACTC TNDR_ACTC WAERS CUKY 5   0   Currency of Actual Shipment Costs TCURC
114 TNDR_CARR TNDR_CARR TEXT10 CHAR 10   0   Forwarding Agent Who Accepted the Shipment  
115 TNDR_CRNM TNDR_CRNM NAME CHAR 35   0   Name of Carrier Who Accepted the Shipment  
116 TNDR_TRKID TNDR_TRKID TEXT35 CHAR 35   0   Forwarding Agent Tracking ID  
117 TNDR_EXPD TNDR_EXPD DATUM DATS 8   0   Date on Which Offer Expires  
118 TNDR_EXPT TNDR_EXPT UZEIT TIMS 6   0   Time at Which Quotation Expires  
119 TNDR_ERPD TNDR_ERPD DATUM DATS 8   0   Earliest Pickup Date  
120 TNDR_ERPT TNDR_ERPT UZEIT TIMS 6   0   Earliest Pickup Time  
121 TNDR_LTPD TNDR_LTPD DATUM DATS 8   0   Latest Pickup Date  
122 TNDR_LTPT TNDR_LTPT UZEIT TIMS 6   0   Latest Pickup Time  
123 TNDR_ERDD TNDR_ERDD DATUM DATS 8   0   Earliest Delivery Date  
124 TNDR_ERDT TNDR_ERDT UZEIT TIMS 6   0   Earliest Delivery Time  
125 TNDR_LTDD TNDR_LTDD DATUM DATS 8   0   Latest Delivery Date  
126 TNDR_LTDT TNDR_LTDT UZEIT TIMS 6   0   Latest Delivery Time  
127 TNDR_LDLG TNDR_LDLG MENG13 QUAN 13   3   Length of Loading Platform  
128 TNDR_LDLU TNDR_LDLU MEINS UNIT 3   0   Unit of Measure for Load Length *
129 KZHULFR KZHULFR KZHULFR CHAR 1   0   Indicator: HUs Relevant for Delivery Item Generation  
130 ALLOWED_TWGT ALLOWED_TWGT MENG12_0 QUAN 8   0   Allowed total weight of shipment  
131 VLSTK VLSTK VLSTK CHAR 1   0   Distribution Status (Decentralized Warehouse Processing)  
132 VERURSYS TRA_VERURSYS LOGSYS CHAR 10   0   Shipment Distribution: Original System *
133 CM_IDENT CMIDENTIFIER CHAR12 CHAR 12   0   Identification Number for Continuous Moves  
134 CM_SEQUENCE CMSEQUENCE SEQUENCE1 NUMC 4   0   Sequence of Transports in Connecting Traffice  
135 EXT_FREIGHT_ORD EXT_FREIGHT_ORDER EXT_FREIGHT_ORDER CHAR 20   0   External Freight Order ID  
136 EXT_TM_SYS SLD_BSKEY SLD_BSKEY CHAR 60   0   Key Name of Business System  
137 .INCLU--AP       0   0   Extension of Shipment Header (Transportation Planning)  
138 .INCLUDE       0   0   Include Transportation Planning Staff and Vehicles  
139 /BEV1/RPFAR1 /DSD/RP_DRIVER1 KUNNR CHAR 10   0   Driver 1 KNA1
140 /BEV1/RPFAR2 /DSD/RP_DRIVER2 KUNNR CHAR 10   0   Driver 2 KNA1
141 /BEV1/RPMOWA /DSD/RP_TRUCK EQUNR CHAR 18   0   Vehicle *
142 /BEV1/RPANHAE /DSD/RP_TRAIL EQUNR CHAR 18   0   Trailer *
143 /BEV1/RPFLGNR /DSD/RP_SEQUENCENR /DSD/RP_SEQUENCENR NUMC 5   0   Loading Sequence Number in the Tour  
144 .INCLU--AP       0   0   Append to VTTK for VSO  
145 .INCLUDE       0   0   Include for Append to VTTK for VSO  
146 /VSO/R_STATUS /VSO/M_VSO_STATUS /VSO/M_VSO_STATUS CHAR 1   0   Status of Vehicle Space Optimization  
147 .INCLUDE       0   0   Text descriptions  
148 VBTYP_TXT VBTYP_TXT AS4TEXT CHAR 60   0   Description of sales and distribution document category  
149 TPLST_TXT TPLST_TXT TEXT20 CHAR 20   0   Description of transportation planning point  
150 SHTYP_TXT SHTYP_TXT TEXT20 CHAR 20   0   Description of shipment type  
151 STERM_TXT STERM_TXT AS4TEXT CHAR 60   0   Indicator for leg determination  
152 ABFER_TXT ABFER_TXT AS4TEXT CHAR 60   0   Description of processing type  
153 ABWST_TXT ABWST_TXT AS4TEXT CHAR 60   0   Description of processing control  
154 BFART_TXT BFART_TXT AS4TEXT CHAR 60   0   Description of mode of transport  
155 VSART_TXT VSART_TXT TEXT15 CHAR 15   0   Description of shipping type  
156 VSAVL_TXT VSAVL_TXT TEXT20 CHAR 20   0   Description of shipping type - Preliminary leg  
157 VSANL_TXT VSANL_TXT TEXT20 CHAR 20   0   Description of shipping type - Subsequent leg  
158 LAUFK_TXT LAUFK_TXT CHAR15 CHAR 15   0   Leg indicator description  
159 VSBED_TXT VSBED_TXT TEXT20 CHAR 20   0   Description of shipping condition  
160 ROUTE_TXT ROUTE_TXT TEXT30 CHAR 30   0   Name of shipment route  
161 TDLNR_TXT TDLNR_TXT NAME CHAR 35   0   Forwarding agent name  
162 STTRG_TXT STTRG_TXT AS4TEXT CHAR 60   0   Description of overall status of shipment  
163 SDABW_TXT SDABW_TXT TEXT35 CHAR 35   0   Description of special processing indicator  
164 FRKRL_TXT FRKRL_TXT TEXT40 CHAR 40   0   Description of freight costs relevance  
165 FBSTA_TXT FBSTA_TXT TEXT30 CHAR 30   0   Status of shipment costs calculation  
166 ARSTA_TXT ARSTA_TXT TEXT30 CHAR 30   0   Status of shipment cost settlement (description)  
167 FBGST_TXT FBGST_TXT TEXT30 CHAR 30   0   Total status of shipment costs calculation  
168 ARGST_TXT ARGST_TXT TEXT30 CHAR 30   0   Total status of shipment cost settlement (description)  
169 KKALSM_TXT KKALSM_TXT TEXT30 CHAR 30   0   Name of procedure in shipment header  
170 ROUTID ROUTID CHAR100 CHAR 100   0   Route identification  
171 ADD01_TXT VTTK_ADD01_T TEXT40 CHAR 40   0   Description for supplement 1  
172 ADD02_TXT VTTK_ADD02_T TEXT40 CHAR 40   0   Description of supplement 2  
173 ADD03_TXT VTTK_ADD03_T TEXT40 CHAR 40   0   Description of supplement 3  
174 ADD04_TXT VTTK_ADD04_T TEXT40 CHAR 40   0   Description of supplement 4  
175 ICON ICON_VT06_STATUS TEXT15 CHAR 15   0   Symbol Representing Status of a Shipment Header  
176 LOCKED CBOX XFELD CHAR 1   0   Checkbox  
177 SELFIELD CBOX XFELD CHAR 1   0   Checkbox  
178 CBOX CBOX XFELD CHAR 1   0   Checkbox  
179 AMPEL AMPEL_ALV AMPEL_ALV CHAR 1   0   Status of traffic light  
180 UPDKZ UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
181 .INCLU--AP       0   0   Dyn.Part Shipment Header Loading Unit (Transportation Plng)  
182 .INCLUDE       0   0   Include Basic Structure (1Feld) for Appends  
183 /BEV1/LULEINH /BEV1/LULEINH /BEV1/LULEINH NUMC 8   0   Loading Units  
184 .INCLU--AP       0   0   Dyn. Part Shipment Header Capacity Usage (Transp. Planning)  
185 .INCLUDE       0   0   Dyn. Part Shipment Header Capacity Usage (Transp. Planning)  
186 /BEV1/RPNUTZLAST /BEV1/RPNUTZLAST MENG13 QUAN 13   3   Usable Load  
187 /BEV1/RP_WEIGTH_U WEIGHT_UNIT MEINS UNIT 3   0   Unit of weight *
188 /BEV1/RPFRKAPA /BEV1/RPFRKAPA MENG13 QUAN 13   3   Free Capacity for Shipment (Transportation Planning)  
189 /BEV1/RPMNGTR /BEV1/RPMNGTR /BEV1/RPVARKAP QUAN 7   2   Shipment Quantity Calculated in Var. Capacity Unit of Truck  
190 /BEV1/RPKAPTR /BEV1/RPVARKAP /BEV1/RPVARKAP QUAN 7   2   Free Capacity Field with Variable Unit of Measure  
191 /BEV1/RPKAPUNIT /BEV1/RPKAPUNIT MEINS UNIT 3   0   Unit of Measure for Var. Capacity Field *
192 /BEV1/RPAUSLA /BEV1/RPAUSLA DEC3_2 DEC 5   2   Capacity Utilization of Vehicle as a Percentage  
193 /BEV1/RPGEWNL /BEV1/RPGEWNL DEC03_2 DEC 5   2   Ratio of Shipment Weight to Usable Load of Truck as Percent.  
194 .INCLUDE       0   0   Totals Fields Statistics Shipment Header from Deliveries  
195 /BEV1/RPFAESS /BEV1/RPFAESSER DEC7 DEC 7   0   Number Category 1  
196 /BEV1/RPKIST /BEV1/RPKISTEN DEC7 DEC 7   0   Number Category 2  
197 /BEV1/RPCONT /BEV1/RPONTAIN DEC7 DEC 7   0   Number Category 3  
198 /BEV1/RPSONST /BEV1/RPSONST DEC7 DEC 7   0   Number Category 4  
199 .INCLU--AP       0   0   VSO Append to VTTK_ALV for VSO  
200 .INCLUDE       0   0   Include for Append to VTTK_ALV for VSO  
201 /VSO/RSTATUSICON /VSO/R_VSO_STATUS_ICON /VSO/R_VSO_STATUS_ICON CHAR 46   0   Icon for Status Display of Vehicle Space Optimization (VSO)  
202 /VSO/PSTATUSICON /VSO/R_SHP_PICK_STS_ICON /VSO/R_SHP_PICK_STS_ICON CHAR 46   0   Icon Aggr.Picking Status of All Deliveries in Shipment (LRO)  
203 /VSO/P_STATUS /VSO/R_SHP_PICK_STS STATV CHAR 1   0   Aggr. Picking Status of All Deliveries in a Shipment (VSO)  
204 /VSO/P_D1_NAME1 /DSD/RP_DRIVER1_NAME NAME CHAR 35   0   Name of Driver 1  
205 /VSO/P_D2_NAME1 /DSD/RP_DRIVER2_NAME NAME CHAR 35   0   Name of Driver 2  
206 .INCLUDE       0   0   Include Route Planning Quantities (from Deliveries)  
207 /BEV1/RPKUNDEN /BEV1/RPKUNDEN NUMC03 NUMC 3   0   Number of Customers  
208 /BEV1/RPMENGE /BEV1/RPMENGE MENG13 QUAN 13   3   Order Volume  
209 /BEV1/RPVOL_U /BEV1/RPVOL_U MEINS UNIT 3   0   Volume Unit *
210 /BEV1/RPAGEW /BEV1/RPAGEW MENG13 QUAN 13   3   Order Weight  
211 /BEV1/RPMASS_U GEWEI MEINS UNIT 3   0   Weight Unit *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /DSD/RP_VTTK_ALV /BEV1/RPFAR1 KNA1 KUNNR    
2 /DSD/RP_VTTK_ALV /BEV1/RPFAR2 KNA1 KUNNR    
3 /DSD/RP_VTTK_ALV ADD01 VTADD01 ADD_INFO    
4 /DSD/RP_VTTK_ALV ADD02 VTADD02 ADD_INFO    
5 /DSD/RP_VTTK_ALV ADD03 VTADD03 ADD_INFO    
6 /DSD/RP_VTTK_ALV ADD04 VTADD04 ADD_INFO    
7 /DSD/RP_VTTK_ALV KKALSM T683 KALSM    
8 /DSD/RP_VTTK_ALV MANDT T000 MANDT KEY 1 CN
9 /DSD/RP_VTTK_ALV PROLI TDGC5 PROLI    
10 /DSD/RP_VTTK_ALV ROUTE TVRO ROUTE REF C CN
11 /DSD/RP_VTTK_ALV SDABW TVSAK SDABW    
12 /DSD/RP_VTTK_ALV SHTYP TVTK SHTYP REF 1 CN
13 /DSD/RP_VTTK_ALV TDLNR LFA1 LIFNR REF 1 CN
14 /DSD/RP_VTTK_ALV TNDR_ACTC TCURC WAERS REF 1 CN
15 /DSD/RP_VTTK_ALV TNDR_MAXC TCURC WAERS REF 1 CN
16 /DSD/RP_VTTK_ALV TPLST TTDS TPLST REF 1 CN
17 /DSD/RP_VTTK_ALV VSANL T173 VSART REF C CN
18 /DSD/RP_VTTK_ALV VSART T173 VSART REF C CN
19 /DSD/RP_VTTK_ALV VSAVL T173 VSART REF C CN
20 /DSD/RP_VTTK_ALV VSBED TVSB VSBED REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in