SAP ABAP Table MCVTTK (LIS Shipment - Header Data)
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 MCVTTK   Table Relationship Diagram
Short Description LIS Shipment - Header Data    
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   Additional Fields: Shipment Header for LIS Updating  
147 ADUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
148 VSTELA VSTEL_TBG VSTEL CHAR 4   0   First shipping point in transportation (LIS) *
149 WERKSZ WERKSZ WERKS CHAR 4   0   Plant at destination point *
150 PSTLZA PSTLZ_TBG PSTLZ CHAR 10   0   Postal code: shipment start  
151 PSTLZZ PSTLZ_TEN PSTLZ CHAR 10   0   Postal code: shipment end  
152 ALAND ALAND_TBG LAND1 CHAR 3   0   Country: shipment start *
153 LLAND LLAND_TEN LAND1 CHAR 3   0   Country: shipment end *
154 AZONE AZONE_TBG ZONE CHAR 10   0   Zone: shipment start *
155 LZONE LZONE_TEN ZONE CHAR 10   0   Zone: shipment end *
156 REGIOA REGIO_TBG REGIO CHAR 3   0   Region: shipment start *
157 REGIOZ REGIO_TEN REGIO CHAR 3   0   Region: shipment end *
158 STADIS STADIS MEINS UNIT 3   0   Distance unit for statistics update *
159 STAVOL STAVOL MEINS UNIT 3   0   Volume unit for statistics update *
160 STAGEW STAGEW MEINS UNIT 3   0   Weight unit for statistics update *
161 ANZHV ANZHV_VET ANZGL INT4 10   0   LIS: Number of main shpg units in shipment  
162 ANZHVG ANZVG_VET ANZGL INT4 10   0   LIS: Number of main shipping unit groups in transport  
163 ANZVGES ANZVGES_VET ANZGL INT4 10   0   LIS: Number of shipping units in transport  
164 ANZVGL ANZGL_VET ANZGL INT4 10   0   LIS: Number of shipping unit groups in shipment  
165 BRGEW_VE BRGEW_VET MENG15 QUAN 15   3   LIS: Gross weight of all main shipping units in shipment  
166 NTGEW_VE NTGEW_VET MENG15 QUAN 15   3   LIS: Net weight of all main shipping units in shipment  
167 MAGEW_VE MAGEW_VET MENG15 QUAN 15   3   LIS: Max. freight weight of all main shipping units in shpmt  
168 TARAG_VE TARAG_VET MENG15 QUAN 15   3   LIS: Tare weight of all main shipping units in shipment  
169 GEWEI_MAX GEWEI_VE MEINS UNIT 3   0   Weight unit: shipping unit content *
170 GEWEI_TAR GEWEI_VT MEINS UNIT 3   0   Weight unit shippint unit tare *
171 AUSLG_VE PRGEW_CAPD DEC3 DEC 3   0   Utilization percentage: Weight  
172 BRVOL_VE BRVOL_VET MENG15 QUAN 15   3   LIS: Gross volume of all main shipping units in shipment  
173 NTVOL_VE NTVOL_VET MENG15 QUAN 15   3   LIS: Net volume of all main shipping units in shipment  
174 MAVOL_VE MAVOL_VET MENG15 QUAN 15   3   LIS: Max. freight volume of all main shipping units in shpmt  
175 TAVOL_VE TAVOL_VET MENG15 QUAN 15   3   LIS: Tare volume of all main shipping units in shipment  
176 VOLEH_TAR VOLEH_VT MEINS UNIT 3   0   Unit of volume for shipping unit tare *
177 VOLEH_MAX VOLEH_VE MEINS UNIT 3   0   Volume unit, shipping unit contents *
178 AUSLV_VE PRVOL_CAPD DEC3 DEC 3   0   Utilization percentage: volume  
179 VHILM_VE VHILM_VET MATNR CHAR 18   0   LIS: Highest shipping element in transport *
180 DURLP MC_TPDURLDP TDURAMIN DEC 11   0   TIS: planned shipment loading time  
181 DURLA MC_TPDURLDA TDURAMIN DEC 11   0   TIS: actual shipment loading time  
182 DURTP MC_TPDURTPP TDURAMIN DEC 11   0   TIS: planned shipment duration  
183 DURTA MC_TPDURTPA TDURAMIN DEC 11   0   TIS: actual shipment duration  
184 LATEL MC_TPDURLDU TDURAMIN DEC 11   0   TIS: Amount of time the planned loading time was exceeded  
185 LATET MC_TPDURTPU TDURAMIN DEC 11   0   TIS: Amount of time the planned shipment time was exceeded  
186 LATES MC_TPDURTPV TDURAMIN DEC 11   0   TIS: amount of time shipment start was delayed (planned-act)  
187 LATEE MC_TPDURTPZ TDURAMIN DEC 11   0   TIS: delay of the actual shipment end (planned - actual)  
188 LATER MC_TPDURRGV TDURAMIN DEC 11   0   TIS: Check-in delay (planned - actual)  
189 LATEB MC_TPDURLDV TDURAMIN DEC 11   0   TIS: Loading start delay (planned - actual)  
190 DURGES MC_TPDURGES TDURAMIN DEC 11   0   Total duration in minutes  
191 DURFAH MC_TPDURFAH TDURAMIN DEC 11   0   Travel duration in real travel time (minutes)  
192 DURGESP MC_TPDURGESP TDURAMIN DEC 11   0   Planned total duration in minutes  
193 DURFAHP MC_TPDURFAHP TDURAMIN DEC 11   0   Planned travel time in minutes  
194 STACUR STACUR WAERS CUKY 5   0   Currency Unit for Statistical Update *
195 HWAER HWAER WAERS CUKY 5   0   Local Currency *
196 ALLOW_TWG ALLOWED_TWGT MENG12_0 QUAN 8   0   Allowed total weight of shipment  
197 .INCLUDE       0   0   Partner Structures for Transport from VBPA  
198 PKUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
199 PKUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
200 PKUNRE KUNRE KUNNR CHAR 10   0   Bill-to party *
201 PKUNRG KUNRG KUNNR CHAR 10   0   Payer *
202 PTDLNR TDLNR LIFNR CHAR 10   0   Number of forwarding agent *
203 PTFRNR TFRNR LIFNR CHAR 10   0   Name of carrier in transportation *
204 PTRFNR TRFNR LIFNR CHAR 10   0   Number of cleaning company in the shipment *
205 PTVENR TVENR LIFNR CHAR 10   0   Number of transportation insurance in the shipment *
206 PLAAG PLAAG LAND1 CHAR 3   0   Country of the sold-to party *
207 PLAWE PLAWE LAND1 CHAR 3   0   Country of ship-to party *
208 PLARE PLARE LAND1 CHAR 3   0   Country of the bill-to party *
209 PLARG PLARG LAND1 CHAR 3   0   Country of the payer *
210 PLASP PLASP LAND1 CHAR 3   0   Country of the carrier *
211 PLAFF PLAFF LAND1 CHAR 3   0   Country of carrier *
212 PLARF PLARF LAND1 CHAR 3   0   Country of cleaning company *
213 PLATV PLATV LAND1 CHAR 3   0   Country of transportation insurer *
214 PABLA PABLA TEXT25 CHAR 25   0   Unloading point of the ship-to party  
215 PZONE PZONE ZONE CHAR 10   0   Transportation zone of the ship-to party *
216 .INCLUDE       0   0   User Section: Additional Partner(s) from VBPA  
217 PDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
218 .INCLUDE       0   0   User Structure: Shipment Header for LIS Updating  
219 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 MCVTTK /BEV1/RPFAR1 KNA1 KUNNR    
2 MCVTTK /BEV1/RPFAR2 KNA1 KUNNR    
3 MCVTTK ADD01 VTADD01 ADD_INFO    
4 MCVTTK ADD02 VTADD02 ADD_INFO    
5 MCVTTK ADD03 VTADD03 ADD_INFO    
6 MCVTTK ADD04 VTADD04 ADD_INFO    
7 MCVTTK KKALSM T683 KALSM    
8 MCVTTK MANDT T000 MANDT KEY 1 CN
9 MCVTTK PROLI TDGC5 PROLI    
10 MCVTTK ROUTE TVRO ROUTE C CN
11 MCVTTK SDABW TVSAK SDABW    
12 MCVTTK SHTYP TVTK SHTYP 1 CN
13 MCVTTK TDLNR LFA1 LIFNR 1 CN
14 MCVTTK TNDR_ACTC TCURC WAERS REF 1 CN
15 MCVTTK TNDR_MAXC TCURC WAERS REF 1 CN
16 MCVTTK TPLST TTDS TPLST 1 CN
17 MCVTTK VSANL T173 VSART C CN
18 MCVTTK VSART T173 VSART C CN
19 MCVTTK VSAVL T173 VSART C CN
20 MCVTTK VSBED TVSB VSBED C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in