SAP ABAP Table VTTK (Shipment Header)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing
Basic Data
Table Category TRANSP    Transparent table 
Transparent table VTTK   Table Relationship Diagram
Short Description Shipment Header    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 T000
2 TKNUM TKNUM TKNUM CHAR 10   0   Shipment Number  
3 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
4 SHTYP SHTYP SHTYP CHAR 4   0   Shipment type TVTK
5 TPLST TPLST TPLST CHAR 4   0   Transportation planning point TTDS
6 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
7 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
8 ERZET ERZET UZEIT TIMS 6   0   Entry time  
9 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
10 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
11 AEZET AEZET UZEIT TIMS 6   0   Time last change was made  
12 STERM STERM STERM CHAR 1   0   Leg determination  
13 ABFER ABFER ABFER CHAR 1   0   Shipment completion type  
14 ABWST ABWST ABWST CHAR 1   0   Processing control  
15 BFART BFART BFART CHAR 1   0   Service level  
16 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
17 VSAVL VSAVL VERSART CHAR 2   0   Shipping type of preliminary leg T173
18 VSANL VSANL VERSART CHAR 2   0   Shipping type of subsequent leg T173
19 LAUFK LAUFK LAUFK CHAR 1   0   Leg Indicator  
20 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
21 ROUTE ROUTR ROUTE CHAR 6   0   Shipment route TVRO
22 SIGNI SIGNI TEXT20 CHAR 20   0   Container ID  
23 EXTI1 EXTI1 TEXT20 CHAR 20   0   External identification 1  
24 EXTI2 EXTI2 TEXT20 CHAR 20   0   External identification 2  
25 TPBEZ TPBEZ TEXT20 CHAR 20   0   Description of Shipment  
26 STDIS STDIS STTRA CHAR 1   0   Status of transportation planning  
27 DTDIS DTDIS DATUM DATS 8   0   Date of end of planning  
28 UZDIS UZDIS UZEIT TIMS 6   0   Scheduling end time  
29 STREG STREG STTRA CHAR 1   0   Status of check-in  
30 DPREG DPREG DATUM DATS 8   0   Planned date of check-in  
31 UPREG UPREG UZEIT TIMS 6   0   Planned check-in time  
32 DAREG DAREG DATUM DATS 8   0   Actual date of check-in  
33 UAREG UAREG UZEIT TIMS 6   0   Current time of check-in  
34 STLBG STLBG STTRA CHAR 1   0   Status for start of loading  
35 DPLBG DPLBG DATUM DATS 8   0   Planned date for start of loading  
36 UPLBG UPLBG UZEIT TIMS 6   0   Planned loading start time  
37 DALBG DALBG DATUM DATS 8   0   Current date for start of loading  
38 UALBG UALBG UZEIT TIMS 6   0   Actual loading start time  
39 STLAD STLAD STTRA CHAR 1   0   Status for end of loading  
40 DPLEN DPLEND DATUM DATS 8   0   Planned date for end of loading  
41 UPLEN UPLEND UZEIT TIMS 6   0   Planned loading end time  
42 DALEN DALEND DATUM DATS 8   0   Actual date for end of loading  
43 UALEN UALEND UZEIT TIMS 6   0   Actual loading end time  
44 STABF STABF STTRA CHAR 1   0   Status of shipment completion  
45 DPABF DPABF DATUM DATS 8   0   Planned date for shipment completion  
46 UPABF UPABF UZEIT TIMS 6   0   Planned time for processing  
47 DTABF DTABF DATUM DATS 8   0   Current date of shipment completion  
48 UZABF UZABF UZEIT TIMS 6   0   Time of transportation processing  
49 STTBG STTBG STTRA CHAR 1   0   Status for start of shipment  
50 DPTBG DPTBG DATUM DATS 8   0   Planned date for start of shipment  
51 UPTBG UPTBG UZEIT TIMS 6   0   Planned transport start time  
52 DATBG DATBG DATUM DATS 8   0   Current date for start of shipment  
53 UATBG UATBG UZEIT TIMS 6   0   Actual transport start time  
54 STTEN STTEN STTRA CHAR 1   0   Status for end of shipment  
55 DPTEN DPTEN DATUM DATS 8   0   Planned date for end of shipment  
56 UPTEN UPTEN UZEIT TIMS 6   0   Planned transport end time  
57 DATEN DATEND DATUM DATS 8   0   Actual Date for End of Shipment  
58 UATEN UATEND UZEIT TIMS 6   0   Actual shipment end time  
59 STTRG STTRG STTRG CHAR 1   0   Overall transportation status  
60 TDLNR TDLNR LIFNR CHAR 10   0   Number of forwarding agent LFA1
61 TERNR AUFNR AUFNR CHAR 12   0   Order Number *
62 PKSTK PKSTK_VTTK XFELD CHAR 1   0   Shipment Contains Handling Units  
63 DTMEG DTMEG MEINS UNIT 3   0   Unit of Weight for Transportation Planning *
64 DTMEV DTMEV MEINS UNIT 3   0   Volume Unit for Transportation Planning *
65 DISTZ DISTZ MENG13 QUAN 13   3   Distance  
66 MEDST MEDST MEINS UNIT 3   0   Unit of measure for distance *
67 FAHZT FAHZT FAHZT QUAN 5   2   Travelling time only between two locations  
68 GESZT GESZT FAHZT QUAN 5   2   Total travelling time between two locations incl. breaks  
69 MEIZT MEIZT MEINS UNIT 3   0   Unit of measure for travelling times *
70 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
71 FBSTA FBSTA FBSTA CHAR 1   0   Status of shipment costs calculation  
72 FBGST FBGST FBGST CHAR 1   0   Overall status of calculation of shipment costs for shipment  
73 ARSTA ARSTA ARSTA CHAR 1   0   Status of shipment costs settlement  
74 ARGST ARGST ARGST CHAR 1   0   Total status of shipment costs settlement for shipment  
75 STERM_DONE STERM_DONE STERM_DONE CHAR 1   0   Leg determination complete  
76 VSE_FRK VSE_FRK VSE_FRK CHAR 1   0   Handling Unit Data are Referred in Shipment Cost Document  
77 KKALSM KALSM_KOPF KALSM CHAR 6   0   Pricing procedure in shipment header T683
78 SDABW SDABW SDABW CHAR 4   0   Special Processing Indicator TVSAK
79 FRKRL KFRKRL FRKRL CHAR 1   0   Shipment costs relevance  
80 GESZTD KP_GESZTDP TSTRDURAG DEC 11   0   Planned total time of transportation (in days)  
81 FAHZTD KP_EFFZTDP TSTRDURAN DEC 11   0   Planned duration of transportation (in hours:minutes)  
82 GESZTDA KP_GESZTDA TSTRDURAG DEC 11   0   Actual total time of shipment (in days)  
83 FAHZTDA KP_EFFZTDA TSTRDURAN DEC 11   0   Actual time needed for transporation (in hours:minutes)  
84 ROCPY_DONE ROCPY_DONE ROCPY_DONE CHAR 1   0   Route copied from delivery  
85 HANDLE TSEGGUID SYSUUID_22 CHAR 22   0   Globally unique identifier (linked to time segment, etc)  
86 TSEGFL TSEGEXISTS FLAG CHAR 1   0   Time segment exists  
87 TSEGTP TSEGTPLVTT TSEGTEMPLA CHAR 10   0   Time segment event group shipment header *
88 ADD01 VTTK_ADD01 VTTK_ADD01 CHAR 10   0   Suppl. 1 VTADD01
89 ADD02 VTTK_ADD02 VTTK_ADD02 CHAR 10   0   Suppl. 2 VTADD02
90 ADD03 VTTK_ADD03 VTTK_ADD03 CHAR 10   0   Suppl. 3 VTADD03
91 ADD04 VTTK_ADD04 VTTK_ADD04 CHAR 10   0   Suppl. 4 VTADD04
92 TEXT1 VTTK_TEXT1 TEXT40 CHAR 40   0   Addit.text 1  
93 TEXT2 VTTK_TEXT2 TEXT40 CHAR 40   0   Addit.text 2  
94 TEXT3 VTTK_TEXT3 TEXT40 CHAR 40   0   Addit.text 3  
95 TEXT4 VTTK_TEXT4 TEXT40 CHAR 40   0   Addit.text 4  
96 PROLI ADGE_PROLI ADGD_PROLI CHAR 3   0   Dangerous Goods Management Profile in SD Documents TDGC5
97 DGTLOCK ADGE_TLOCK X CHAR 1   0   Block Indicator for Dangerous Goods  
98 DGMDDAT ADGE_MDDAT DATUM DATS 8   0   Selection date dangerous goods master data  
99 CONT_DG ADGE_NCDG X CHAR 1   0   Indicator: Document contains dangerous goods  
100 WARZTD KP_WARZTDP TSTRDURAN DEC 11   0   Planned waiting time of shipment (in hours:minutes)  
101 WARZTDA KP_WARZTDA TSTRDURAN DEC 11   0   Current waiting time of shipment (in hours:minutes)  
102 AULWE AULWE AULWE CHAR 10   0   Route Schedule *
103 TNDRST TNDRST TNDRST CHAR 2   0   Tender Status  
104 TNDRRC TNDRRC TNDRRC CHAR 2   0   Acceptance Condition/Rejection Reason  
105 TNDR_TEXT TNDR_TEXT TEXT80 CHAR 80   0   Tendering Text  
106 TNDRDAT TNDRDAT DATUM DATS 8   0   Date of tender status  
107 TNDRZET TNDRZET UZEIT TIMS 6   0   Time of tender status  
108 TNDR_MAXP TNDR_MAXP WERT15 CURR 15   2   Maximum Price for Shipment  
109 TNDR_MAXC TNDR_MAXC WAERS CUKY 5   0   Currency of Maximum Price TCURC
110 TNDR_ACTP TNDR_ACTP WERT15 CURR 15   2   Actual Shipment Costs for Shipment  
111 TNDR_ACTC TNDR_ACTC WAERS CUKY 5   0   Currency of Actual Shipment Costs TCURC
112 TNDR_CARR TNDR_CARR TEXT10 CHAR 10   0   Forwarding Agent Who Accepted the Shipment  
113 TNDR_CRNM TNDR_CRNM NAME CHAR 35   0   Name of Carrier Who Accepted the Shipment  
114 TNDR_TRKID TNDR_TRKID TEXT35 CHAR 35   0   Forwarding Agent Tracking ID  
115 TNDR_EXPD TNDR_EXPD DATUM DATS 8   0   Date on Which Offer Expires  
116 TNDR_EXPT TNDR_EXPT UZEIT TIMS 6   0   Time at Which Quotation Expires  
117 TNDR_ERPD TNDR_ERPD DATUM DATS 8   0   Earliest Pickup Date  
118 TNDR_ERPT TNDR_ERPT UZEIT TIMS 6   0   Earliest Pickup Time  
119 TNDR_LTPD TNDR_LTPD DATUM DATS 8   0   Latest Pickup Date  
120 TNDR_LTPT TNDR_LTPT UZEIT TIMS 6   0   Latest Pickup Time  
121 TNDR_ERDD TNDR_ERDD DATUM DATS 8   0   Earliest Delivery Date  
122 TNDR_ERDT TNDR_ERDT UZEIT TIMS 6   0   Earliest Delivery Time  
123 TNDR_LTDD TNDR_LTDD DATUM DATS 8   0   Latest Delivery Date  
124 TNDR_LTDT TNDR_LTDT UZEIT TIMS 6   0   Latest Delivery Time  
125 TNDR_LDLG TNDR_LDLG MENG13 QUAN 13   3   Length of Loading Platform  
126 TNDR_LDLU TNDR_LDLU MEINS UNIT 3   0   Unit of Measure for Load Length *
127 KZHULFR KZHULFR KZHULFR CHAR 1   0   Indicator: HUs Relevant for Delivery Item Generation  
128 ALLOWED_TWGT ALLOWED_TWGT MENG12_0 QUAN 8   0   Allowed total weight of shipment  
129 VLSTK VLSTK VLSTK CHAR 1   0   Distribution Status (Decentralized Warehouse Processing)  
130 VERURSYS TRA_VERURSYS LOGSYS CHAR 10   0   Shipment Distribution: Original System *
131 CM_IDENT CMIDENTIFIER CHAR12 CHAR 12   0   Identification Number for Continuous Moves  
132 CM_SEQUENCE CMSEQUENCE SEQUENCE1 NUMC 4   0   Sequence of Transports in Connecting Traffice  
133 EXT_FREIGHT_ORD EXT_FREIGHT_ORDER EXT_FREIGHT_ORDER CHAR 20   0   External Freight Order ID  
134 EXT_TM_SYS SLD_BSKEY SLD_BSKEY CHAR 60   0   Key Name of Business System  
135 .INCLU--AP       0   0   Extension of Shipment Header (Transportation Planning)  
136 .INCLUDE       0   0   Include Transportation Planning Staff and Vehicles  
137 /BEV1/RPFAR1 /DSD/RP_DRIVER1 KUNNR CHAR 10   0   Driver 1 KNA1
138 /BEV1/RPFAR2 /DSD/RP_DRIVER2 KUNNR CHAR 10   0   Driver 2 KNA1
139 /BEV1/RPMOWA /DSD/RP_TRUCK EQUNR CHAR 18   0   Vehicle *
140 /BEV1/RPANHAE /DSD/RP_TRAIL EQUNR CHAR 18   0   Trailer *
141 /BEV1/RPFLGNR /DSD/RP_SEQUENCENR /DSD/RP_SEQUENCENR NUMC 5   0   Loading Sequence Number in the Tour  
142 .INCLU--AP       0   0   Append to VTTK for VSO  
143 .INCLUDE       0   0   Include for Append to VTTK for VSO  
144 /VSO/R_STATUS /VSO/M_VSO_STATUS /VSO/M_VSO_STATUS CHAR 1   0   Status of Vehicle Space Optimization  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VTTK /BEV1/RPFAR1 KNA1 KUNNR    
2 VTTK /BEV1/RPFAR2 KNA1 KUNNR    
3 VTTK ADD01 VTADD01 ADD_INFO    
4 VTTK ADD02 VTADD02 ADD_INFO    
5 VTTK ADD03 VTADD03 ADD_INFO    
6 VTTK ADD04 VTADD04 ADD_INFO    
7 VTTK KKALSM T683 KALSM    
8 VTTK MANDT T000 MANDT KEY 1 CN
9 VTTK PROLI TDGC5 PROLI    
10 VTTK ROUTE TVRO ROUTE REF C CN
11 VTTK SDABW TVSAK SDABW    
12 VTTK SHTYP TVTK SHTYP REF 1 CN
13 VTTK TDLNR LFA1 LIFNR REF 1 CN
14 VTTK TNDR_ACTC TCURC WAERS REF 1 CN
15 VTTK TNDR_MAXC TCURC WAERS REF 1 CN
16 VTTK TPLST TTDS TPLST REF 1 CN
17 VTTK VSANL T173 VSART REF C CN
18 VTTK VSART T173 VSART REF C CN
19 VTTK VSAVL T173 VSART REF C CN
20 VTTK VSBED TVSB VSBED REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in