SAP ABAP Table MCVTTKB (Reference Structure for MCVTTK)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   LE-TRA (Application Component) Transportation
     MCT (Package) Application Development R/3 Transportation Inform. System
Basic Data
Table Category INTTAB    Structure 
Structure MCVTTKB   Table Relationship Diagram
Short Description Reference Structure for MCVTTK    
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   Update Indicator for Statistics Updating  
2 SUPKZ SUPKZ SUPKZ CHAR 1   0   Statistics update indicator (post in/post out)  
3 .INCLUDE       0   0   LIS Shipment - Header Data  
4 .INCLUDE       0   0   Shipment Header  
5 MANDT MANDT MANDT CLNT 3   0   Client T000
6 TKNUM TKNUM TKNUM CHAR 10   0   Shipment Number *
7 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
8 SHTYP SHTYP SHTYP CHAR 4   0   Shipment type TVTK
9 TPLST TPLST TPLST CHAR 4   0   Transportation planning point TTDS
10 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
11 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
12 ERZET ERZET UZEIT TIMS 6   0   Entry time  
13 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
14 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
15 AEZET AEZET UZEIT TIMS 6   0   Time last change was made  
16 STERM STERM STERM CHAR 1   0   Leg determination  
17 ABFER ABFER ABFER CHAR 1   0   Shipment completion type  
18 ABWST ABWST ABWST CHAR 1   0   Processing control  
19 BFART BFART BFART CHAR 1   0   Service level  
20 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
21 VSAVL VSAVL VERSART CHAR 2   0   Shipping type of preliminary leg T173
22 VSANL VSANL VERSART CHAR 2   0   Shipping type of subsequent leg T173
23 LAUFK LAUFK LAUFK CHAR 1   0   Leg Indicator  
24 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
25 ROUTE ROUTR ROUTE CHAR 6   0   Shipment route TVRO
26 SIGNI SIGNI TEXT20 CHAR 20   0   Container ID  
27 EXTI1 EXTI1 TEXT20 CHAR 20   0   External identification 1  
28 EXTI2 EXTI2 TEXT20 CHAR 20   0   External identification 2  
29 TPBEZ TPBEZ TEXT20 CHAR 20   0   Description of Shipment  
30 STDIS STDIS STTRA CHAR 1   0   Status of transportation planning  
31 DTDIS DTDIS DATUM DATS 8   0   Date of end of planning  
32 UZDIS UZDIS UZEIT TIMS 6   0   Scheduling end time  
33 STREG STREG STTRA CHAR 1   0   Status of check-in  
34 DPREG DPREG DATUM DATS 8   0   Planned date of check-in  
35 UPREG UPREG UZEIT TIMS 6   0   Planned check-in time  
36 DAREG DAREG DATUM DATS 8   0   Actual date of check-in  
37 UAREG UAREG UZEIT TIMS 6   0   Current time of check-in  
38 STLBG STLBG STTRA CHAR 1   0   Status for start of loading  
39 DPLBG DPLBG DATUM DATS 8   0   Planned date for start of loading  
40 UPLBG UPLBG UZEIT TIMS 6   0   Planned loading start time  
41 DALBG DALBG DATUM DATS 8   0   Current date for start of loading  
42 UALBG UALBG UZEIT TIMS 6   0   Actual loading start time  
43 STLAD STLAD STTRA CHAR 1   0   Status for end of loading  
44 DPLEN DPLEND DATUM DATS 8   0   Planned date for end of loading  
45 UPLEN UPLEND UZEIT TIMS 6   0   Planned loading end time  
46 DALEN DALEND DATUM DATS 8   0   Actual date for end of loading  
47 UALEN UALEND UZEIT TIMS 6   0   Actual loading end time  
48 STABF STABF STTRA CHAR 1   0   Status of shipment completion  
49 DPABF DPABF DATUM DATS 8   0   Planned date for shipment completion  
50 UPABF UPABF UZEIT TIMS 6   0   Planned time for processing  
51 DTABF DTABF DATUM DATS 8   0   Current date of shipment completion  
52 UZABF UZABF UZEIT TIMS 6   0   Time of transportation processing  
53 STTBG STTBG STTRA CHAR 1   0   Status for start of shipment  
54 DPTBG DPTBG DATUM DATS 8   0   Planned date for start of shipment  
55 UPTBG UPTBG UZEIT TIMS 6   0   Planned transport start time  
56 DATBG DATBG DATUM DATS 8   0   Current date for start of shipment  
57 UATBG UATBG UZEIT TIMS 6   0   Actual transport start time  
58 STTEN STTEN STTRA CHAR 1   0   Status for end of shipment  
59 DPTEN DPTEN DATUM DATS 8   0   Planned date for end of shipment  
60 UPTEN UPTEN UZEIT TIMS 6   0   Planned transport end time  
61 DATEN DATEND DATUM DATS 8   0   Actual Date for End of Shipment  
62 UATEN UATEND UZEIT TIMS 6   0   Actual shipment end time  
63 STTRG STTRG STTRG CHAR 1   0   Overall transportation status  
64 TDLNR TDLNR LIFNR CHAR 10   0   Number of forwarding agent LFA1
65 TERNR AUFNR AUFNR CHAR 12   0   Order Number *
66 PKSTK PKSTK_VTTK XFELD CHAR 1   0   Shipment Contains Handling Units  
67 DTMEG DTMEG MEINS UNIT 3   0   Unit of Weight for Transportation Planning *
68 DTMEV DTMEV MEINS UNIT 3   0   Volume Unit for Transportation Planning *
69 DISTZ DISTZ MENG13 QUAN 13   3   Distance  
70 MEDST MEDST MEINS UNIT 3   0   Unit of measure for distance *
71 FAHZT FAHZT FAHZT QUAN 5   2   Travelling time only between two locations  
72 GESZT GESZT FAHZT QUAN 5   2   Total travelling time between two locations incl. breaks  
73 MEIZT MEIZT MEINS UNIT 3   0   Unit of measure for travelling times *
74 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
75 FBSTA FBSTA FBSTA CHAR 1   0   Status of shipment costs calculation  
76 FBGST FBGST FBGST CHAR 1   0   Overall status of calculation of shipment costs for shipment  
77 ARSTA ARSTA ARSTA CHAR 1   0   Status of shipment costs settlement  
78 ARGST ARGST ARGST CHAR 1   0   Total status of shipment costs settlement for shipment  
79 STERM_DONE STERM_DONE STERM_DONE CHAR 1   0   Leg determination complete  
80 VSE_FRK VSE_FRK VSE_FRK CHAR 1   0   Handling Unit Data are Referred in Shipment Cost Document  
81 KKALSM KALSM_KOPF KALSM CHAR 6   0   Pricing procedure in shipment header T683
82 SDABW SDABW SDABW CHAR 4   0   Special Processing Indicator TVSAK
83 FRKRL KFRKRL FRKRL CHAR 1   0   Shipment costs relevance  
84 GESZTD KP_GESZTDP TSTRDURAG DEC 11   0   Planned total time of transportation (in days)  
85 FAHZTD KP_EFFZTDP TSTRDURAN DEC 11   0   Planned duration of transportation (in hours:minutes)  
86 GESZTDA KP_GESZTDA TSTRDURAG DEC 11   0   Actual total time of shipment (in days)  
87 FAHZTDA KP_EFFZTDA TSTRDURAN DEC 11   0   Actual time needed for transporation (in hours:minutes)  
88 ROCPY_DONE ROCPY_DONE ROCPY_DONE CHAR 1   0   Route copied from delivery  
89 HANDLE TSEGGUID SYSUUID_22 CHAR 22   0   Globally unique identifier (linked to time segment, etc)  
90 TSEGFL TSEGEXISTS FLAG CHAR 1   0   Time segment exists  
91 TSEGTP TSEGTPLVTT TSEGTEMPLA CHAR 10   0   Time segment event group shipment header *
92 ADD01 VTTK_ADD01 VTTK_ADD01 CHAR 10   0   Suppl. 1 VTADD01
93 ADD02 VTTK_ADD02 VTTK_ADD02 CHAR 10   0   Suppl. 2 VTADD02
94 ADD03 VTTK_ADD03 VTTK_ADD03 CHAR 10   0   Suppl. 3 VTADD03
95 ADD04 VTTK_ADD04 VTTK_ADD04 CHAR 10   0   Suppl. 4 VTADD04
96 TEXT1 VTTK_TEXT1 TEXT40 CHAR 40   0   Addit.text 1  
97 TEXT2 VTTK_TEXT2 TEXT40 CHAR 40   0   Addit.text 2  
98 TEXT3 VTTK_TEXT3 TEXT40 CHAR 40   0   Addit.text 3  
99 TEXT4 VTTK_TEXT4 TEXT40 CHAR 40   0   Addit.text 4  
100 PROLI ADGE_PROLI ADGD_PROLI CHAR 3   0   Dangerous Goods Management Profile in SD Documents TDGC5
101 DGTLOCK ADGE_TLOCK X CHAR 1   0   Block Indicator for Dangerous Goods  
102 DGMDDAT ADGE_MDDAT DATUM DATS 8   0   Selection date dangerous goods master data  
103 CONT_DG ADGE_NCDG X CHAR 1   0   Indicator: Document contains dangerous goods  
104 WARZTD KP_WARZTDP TSTRDURAN DEC 11   0   Planned waiting time of shipment (in hours:minutes)  
105 WARZTDA KP_WARZTDA TSTRDURAN DEC 11   0   Current waiting time of shipment (in hours:minutes)  
106 AULWE AULWE AULWE CHAR 10   0   Route Schedule *
107 TNDRST TNDRST TNDRST CHAR 2   0   Tender Status  
108 TNDRRC TNDRRC TNDRRC CHAR 2   0   Acceptance Condition/Rejection Reason  
109 TNDR_TEXT TNDR_TEXT TEXT80 CHAR 80   0   Tendering Text  
110 TNDRDAT TNDRDAT DATUM DATS 8   0   Date of tender status  
111 TNDRZET TNDRZET UZEIT TIMS 6   0   Time of tender status  
112 TNDR_MAXP TNDR_MAXP WERT15 CURR 15   2   Maximum Price for Shipment  
113 TNDR_MAXC TNDR_MAXC WAERS CUKY 5   0   Currency of Maximum Price TCURC
114 TNDR_ACTP TNDR_ACTP WERT15 CURR 15   2   Actual Shipment Costs for Shipment  
115 TNDR_ACTC TNDR_ACTC WAERS CUKY 5   0   Currency of Actual Shipment Costs TCURC
116 TNDR_CARR TNDR_CARR TEXT10 CHAR 10   0   Forwarding Agent Who Accepted the Shipment  
117 TNDR_CRNM TNDR_CRNM NAME CHAR 35   0   Name of Carrier Who Accepted the Shipment  
118 TNDR_TRKID TNDR_TRKID TEXT35 CHAR 35   0   Forwarding Agent Tracking ID  
119 TNDR_EXPD TNDR_EXPD DATUM DATS 8   0   Date on Which Offer Expires  
120 TNDR_EXPT TNDR_EXPT UZEIT TIMS 6   0   Time at Which Quotation Expires  
121 TNDR_ERPD TNDR_ERPD DATUM DATS 8   0   Earliest Pickup Date  
122 TNDR_ERPT TNDR_ERPT UZEIT TIMS 6   0   Earliest Pickup Time  
123 TNDR_LTPD TNDR_LTPD DATUM DATS 8   0   Latest Pickup Date  
124 TNDR_LTPT TNDR_LTPT UZEIT TIMS 6   0   Latest Pickup Time  
125 TNDR_ERDD TNDR_ERDD DATUM DATS 8   0   Earliest Delivery Date  
126 TNDR_ERDT TNDR_ERDT UZEIT TIMS 6   0   Earliest Delivery Time  
127 TNDR_LTDD TNDR_LTDD DATUM DATS 8   0   Latest Delivery Date  
128 TNDR_LTDT TNDR_LTDT UZEIT TIMS 6   0   Latest Delivery Time  
129 TNDR_LDLG TNDR_LDLG MENG13 QUAN 13   3   Length of Loading Platform  
130 TNDR_LDLU TNDR_LDLU MEINS UNIT 3   0   Unit of Measure for Load Length *
131 KZHULFR KZHULFR KZHULFR CHAR 1   0   Indicator: HUs Relevant for Delivery Item Generation  
132 ALLOWED_TWGT ALLOWED_TWGT MENG12_0 QUAN 8   0   Allowed total weight of shipment  
133 VLSTK VLSTK VLSTK CHAR 1   0   Distribution Status (Decentralized Warehouse Processing)  
134 VERURSYS TRA_VERURSYS LOGSYS CHAR 10   0   Shipment Distribution: Original System *
135 CM_IDENT CMIDENTIFIER CHAR12 CHAR 12   0   Identification Number for Continuous Moves  
136 CM_SEQUENCE CMSEQUENCE SEQUENCE1 NUMC 4   0   Sequence of Transports in Connecting Traffice  
137 EXT_FREIGHT_ORD EXT_FREIGHT_ORDER EXT_FREIGHT_ORDER CHAR 20   0   External Freight Order ID  
138 EXT_TM_SYS SLD_BSKEY SLD_BSKEY CHAR 60   0   Key Name of Business System  
139 .INCLU--AP       0   0   Extension of Shipment Header (Transportation Planning)  
140 .INCLUDE       0   0   Include Transportation Planning Staff and Vehicles  
141 /BEV1/RPFAR1 /DSD/RP_DRIVER1 KUNNR CHAR 10   0   Driver 1 KNA1
142 /BEV1/RPFAR2 /DSD/RP_DRIVER2 KUNNR CHAR 10   0   Driver 2 KNA1
143 /BEV1/RPMOWA /DSD/RP_TRUCK EQUNR CHAR 18   0   Vehicle *
144 /BEV1/RPANHAE /DSD/RP_TRAIL EQUNR CHAR 18   0   Trailer *
145 /BEV1/RPFLGNR /DSD/RP_SEQUENCENR /DSD/RP_SEQUENCENR NUMC 5   0   Loading Sequence Number in the Tour  
146 .INCLU--AP       0   0   Append to VTTK for VSO  
147 .INCLUDE       0   0   Include for Append to VTTK for VSO  
148 /VSO/R_STATUS /VSO/M_VSO_STATUS /VSO/M_VSO_STATUS CHAR 1   0   Status of Vehicle Space Optimization  
149 .INCLUDE       0   0   Additional Fields: Shipment Header for LIS Updating  
150 ADUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
151 VSTELA VSTEL_TBG VSTEL CHAR 4   0   First shipping point in transportation (LIS) *
152 WERKSZ WERKSZ WERKS CHAR 4   0   Plant at destination point *
153 PSTLZA PSTLZ_TBG PSTLZ CHAR 10   0   Postal code: shipment start  
154 PSTLZZ PSTLZ_TEN PSTLZ CHAR 10   0   Postal code: shipment end  
155 ALAND ALAND_TBG LAND1 CHAR 3   0   Country: shipment start *
156 LLAND LLAND_TEN LAND1 CHAR 3   0   Country: shipment end *
157 AZONE AZONE_TBG ZONE CHAR 10   0   Zone: shipment start *
158 LZONE LZONE_TEN ZONE CHAR 10   0   Zone: shipment end *
159 REGIOA REGIO_TBG REGIO CHAR 3   0   Region: shipment start *
160 REGIOZ REGIO_TEN REGIO CHAR 3   0   Region: shipment end *
161 STADIS STADIS MEINS UNIT 3   0   Distance unit for statistics update *
162 STAVOL STAVOL MEINS UNIT 3   0   Volume unit for statistics update *
163 STAGEW STAGEW MEINS UNIT 3   0   Weight unit for statistics update *
164 ANZHV ANZHV_VET ANZGL INT4 10   0   LIS: Number of main shpg units in shipment  
165 ANZHVG ANZVG_VET ANZGL INT4 10   0   LIS: Number of main shipping unit groups in transport  
166 ANZVGES ANZVGES_VET ANZGL INT4 10   0   LIS: Number of shipping units in transport  
167 ANZVGL ANZGL_VET ANZGL INT4 10   0   LIS: Number of shipping unit groups in shipment  
168 BRGEW_VE BRGEW_VET MENG15 QUAN 15   3   LIS: Gross weight of all main shipping units in shipment  
169 NTGEW_VE NTGEW_VET MENG15 QUAN 15   3   LIS: Net weight of all main shipping units in shipment  
170 MAGEW_VE MAGEW_VET MENG15 QUAN 15   3   LIS: Max. freight weight of all main shipping units in shpmt  
171 TARAG_VE TARAG_VET MENG15 QUAN 15   3   LIS: Tare weight of all main shipping units in shipment  
172 GEWEI_MAX GEWEI_VE MEINS UNIT 3   0   Weight unit: shipping unit content *
173 GEWEI_TAR GEWEI_VT MEINS UNIT 3   0   Weight unit shippint unit tare *
174 AUSLG_VE PRGEW_CAPD DEC3 DEC 3   0   Utilization percentage: Weight  
175 BRVOL_VE BRVOL_VET MENG15 QUAN 15   3   LIS: Gross volume of all main shipping units in shipment  
176 NTVOL_VE NTVOL_VET MENG15 QUAN 15   3   LIS: Net volume of all main shipping units in shipment  
177 MAVOL_VE MAVOL_VET MENG15 QUAN 15   3   LIS: Max. freight volume of all main shipping units in shpmt  
178 TAVOL_VE TAVOL_VET MENG15 QUAN 15   3   LIS: Tare volume of all main shipping units in shipment  
179 VOLEH_TAR VOLEH_VT MEINS UNIT 3   0   Unit of volume for shipping unit tare *
180 VOLEH_MAX VOLEH_VE MEINS UNIT 3   0   Volume unit, shipping unit contents *
181 AUSLV_VE PRVOL_CAPD DEC3 DEC 3   0   Utilization percentage: volume  
182 VHILM_VE VHILM_VET MATNR CHAR 18   0   LIS: Highest shipping element in transport *
183 DURLP MC_TPDURLDP TDURAMIN DEC 11   0   TIS: planned shipment loading time  
184 DURLA MC_TPDURLDA TDURAMIN DEC 11   0   TIS: actual shipment loading time  
185 DURTP MC_TPDURTPP TDURAMIN DEC 11   0   TIS: planned shipment duration  
186 DURTA MC_TPDURTPA TDURAMIN DEC 11   0   TIS: actual shipment duration  
187 LATEL MC_TPDURLDU TDURAMIN DEC 11   0   TIS: Amount of time the planned loading time was exceeded  
188 LATET MC_TPDURTPU TDURAMIN DEC 11   0   TIS: Amount of time the planned shipment time was exceeded  
189 LATES MC_TPDURTPV TDURAMIN DEC 11   0   TIS: amount of time shipment start was delayed (planned-act)  
190 LATEE MC_TPDURTPZ TDURAMIN DEC 11   0   TIS: delay of the actual shipment end (planned - actual)  
191 LATER MC_TPDURRGV TDURAMIN DEC 11   0   TIS: Check-in delay (planned - actual)  
192 LATEB MC_TPDURLDV TDURAMIN DEC 11   0   TIS: Loading start delay (planned - actual)  
193 DURGES MC_TPDURGES TDURAMIN DEC 11   0   Total duration in minutes  
194 DURFAH MC_TPDURFAH TDURAMIN DEC 11   0   Travel duration in real travel time (minutes)  
195 DURGESP MC_TPDURGESP TDURAMIN DEC 11   0   Planned total duration in minutes  
196 DURFAHP MC_TPDURFAHP TDURAMIN DEC 11   0   Planned travel time in minutes  
197 STACUR STACUR WAERS CUKY 5   0   Currency Unit for Statistical Update *
198 HWAER HWAER WAERS CUKY 5   0   Local Currency *
199 ALLOW_TWG ALLOWED_TWGT MENG12_0 QUAN 8   0   Allowed total weight of shipment  
200 .INCLUDE       0   0   Partner Structures for Transport from VBPA  
201 PKUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
202 PKUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
203 PKUNRE KUNRE KUNNR CHAR 10   0   Bill-to party *
204 PKUNRG KUNRG KUNNR CHAR 10   0   Payer *
205 PTDLNR TDLNR LIFNR CHAR 10   0   Number of forwarding agent *
206 PTFRNR TFRNR LIFNR CHAR 10   0   Name of carrier in transportation *
207 PTRFNR TRFNR LIFNR CHAR 10   0   Number of cleaning company in the shipment *
208 PTVENR TVENR LIFNR CHAR 10   0   Number of transportation insurance in the shipment *
209 PLAAG PLAAG LAND1 CHAR 3   0   Country of the sold-to party *
210 PLAWE PLAWE LAND1 CHAR 3   0   Country of ship-to party *
211 PLARE PLARE LAND1 CHAR 3   0   Country of the bill-to party *
212 PLARG PLARG LAND1 CHAR 3   0   Country of the payer *
213 PLASP PLASP LAND1 CHAR 3   0   Country of the carrier *
214 PLAFF PLAFF LAND1 CHAR 3   0   Country of carrier *
215 PLARF PLARF LAND1 CHAR 3   0   Country of cleaning company *
216 PLATV PLATV LAND1 CHAR 3   0   Country of transportation insurer *
217 PABLA PABLA TEXT25 CHAR 25   0   Unloading point of the ship-to party  
218 PZONE PZONE ZONE CHAR 10   0   Transportation zone of the ship-to party *
219 .INCLUDE       0   0   User Section: Additional Partner(s) from VBPA  
220 PDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
221 .INCLUDE       0   0   User Structure: Shipment Header for LIS Updating  
222 UDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MCVTTKB /BEV1/RPFAR1 KNA1 KUNNR    
2 MCVTTKB /BEV1/RPFAR2 KNA1 KUNNR    
3 MCVTTKB ADD01 VTADD01 ADD_INFO    
4 MCVTTKB ADD02 VTADD02 ADD_INFO    
5 MCVTTKB ADD03 VTADD03 ADD_INFO    
6 MCVTTKB ADD04 VTADD04 ADD_INFO    
7 MCVTTKB KKALSM T683 KALSM    
8 MCVTTKB MANDT T000 MANDT KEY 1 CN
9 MCVTTKB PROLI TDGC5 PROLI    
10 MCVTTKB ROUTE TVRO ROUTE REF C CN
11 MCVTTKB SDABW TVSAK SDABW    
12 MCVTTKB SHTYP TVTK SHTYP REF 1 CN
13 MCVTTKB TDLNR LFA1 LIFNR REF 1 CN
14 MCVTTKB TNDR_ACTC TCURC WAERS REF 1 CN
15 MCVTTKB TNDR_MAXC TCURC WAERS REF 1 CN
16 MCVTTKB TPLST TTDS TPLST REF 1 CN
17 MCVTTKB VSANL T173 VSART REF C CN
18 MCVTTKB VSART T173 VSART REF C CN
19 MCVTTKB VSAVL T173 VSART REF C CN
20 MCVTTKB VSBED TVSB VSBED REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in