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