SAP ABAP Table VTTKF (Shipment Header: Structure for Shipment Costing)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     VTRA (Package) Shipment costs
Basic Data
Table Category INTTAB    Structure 
Structure VTTKF   Table Relationship Diagram
Short Description Shipment Header: Structure for Shipment Costing    
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   Shipment Header: Dynamic Part  
147 TKNUM_OLD TKNUM TKNUM CHAR 10   0   Shipment Number *
148 TPNUML TPNUML TPNUM NUMC 4   0   Last transport item *
149 TPRFOL TPRFOL TPRFO NUMC 4   0   Last assigned number in sequence (shipping items)  
150 TSNUML TSNUML TSNUM NUMC 4   0   Last number of stage of transport *
151 TSRFOL TSRFOL TSRFO NUMC 4   0   Last assigned number in the sequence  
152 SORT TR_SORT NUM08 NUMC 8   0   Sort field for shipments  
153 PROFIDNETZ PROFIDNZPL PROFILID CHAR 7   0   Network profile *
154 TXDIL NAME1_GP NAME CHAR 35   0   Name 1  
155 TXROU BEZEI40 TEXT40 CHAR 40   0   Description  
156 EXTNO TR_EXTNO XFELD CHAR 1   0   Indicator for external shipment number  
157 UPDTX UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
158 UPDTE UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
159 UPDNA UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
160 UPDVE UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
161 UPDPA UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
162 UPDKZ UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
163 AENDERUNG UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
164 TKNUM_TMP TKNUM TKNUM CHAR 10   0   Shipment Number *
165 TXTSP TXTSP   CHAR 130   0   Output Text for Short Address of Forwarding Agent  
166 ICON_TNDRST ICONSUBST ICONSUBST CHAR 4   0   Icon: Replacement character  
167 TRMTYP TRMTYP MATNR CHAR 18   0   Means of Transportation *
168 TRATY TRATY TRATY CHAR 4   0   Means-of-Transport Type *
169 ADRNR ADRNR ADRNR CHAR 10   0   Address *
170 ADRDA ADRDA ADRDA CHAR 1   0   Address indicator  
171 TNDR_REST TNDR_REST FLAG CHAR 1   0   Ind.: Restrictive handling of tender to forwarding agent  
172 SPLFLG SPLFLG XFELD CHAR 1   0   Indicator: Delivery Split Executed  
173 TRXFLAG XFELD XFELD CHAR 1   0   Checkbox  
174 KZ_HULFG KZ_HULFG XFELD CHAR 1   0   Indicator: Generate Delivery Items for HUs  
175 BTGWD TRGEW MENG15 QUAN 15   3   Total gross weight of shipping items  
176 VOLMD TRVOL MENG15 QUAN 15   3   Total volume of shipping items  
177 GSGWD TRGSG MENG15 QUAN 15   3   Total of total weight of shipment items  
178 TSEGINIT XFELD XFELD CHAR 1   0   Checkbox  
179 .INCLU--AP       0   0   Dynamic Part of Shipment Header (Transportation Planning)  
180 .INCLUDE       0   0   Dyn. Part Shipment Header Capacity Usage (Transp. Planning)  
181 /BEV1/RPNUTZLAST /BEV1/RPNUTZLAST MENG13 QUAN 13   3   Usable Load  
182 /BEV1/RP_WEIGTH_U WEIGHT_UNIT MEINS UNIT 3   0   Unit of weight *
183 /BEV1/RPFRKAPA /BEV1/RPFRKAPA MENG13 QUAN 13   3   Free Capacity for Shipment (Transportation Planning)  
184 /BEV1/RPMNGTR /BEV1/RPMNGTR /BEV1/RPVARKAP QUAN 7   2   Shipment Quantity Calculated in Var. Capacity Unit of Truck  
185 /BEV1/RPKAPTR /BEV1/RPVARKAP /BEV1/RPVARKAP QUAN 7   2   Free Capacity Field with Variable Unit of Measure  
186 /BEV1/RPKAPUNIT /BEV1/RPKAPUNIT MEINS UNIT 3   0   Unit of Measure for Var. Capacity Field *
187 /BEV1/RPAUSLA /BEV1/RPAUSLA DEC3_2 DEC 5   2   Capacity Utilization of Vehicle as a Percentage  
188 /BEV1/RPGEWNL /BEV1/RPGEWNL DEC03_2 DEC 5   2   Ratio of Shipment Weight to Usable Load of Truck as Percent.  
189 .INCLUDE       0   0   Dyn. Part Shipment Header Overall Status (Transp. Planning)  
190 /BEV1/RPGSTATUS /BEV1/RPGSTATUS CHAR1 CHAR 1   0   Overall Status of Shipment in Transportation Planning  
191 .INCLUDE       0   0   Include Route Planning Quantities (from Deliveries)  
192 /BEV1/RPKUNDEN /BEV1/RPKUNDEN NUMC03 NUMC 3   0   Number of Customers  
193 /BEV1/RPMENGE /BEV1/RPMENGE MENG13 QUAN 13   3   Order Volume  
194 /BEV1/RPVOL_U /BEV1/RPVOL_U MEINS UNIT 3   0   Volume Unit *
195 /BEV1/RPAGEW /BEV1/RPAGEW MENG13 QUAN 13   3   Order Weight  
196 /BEV1/RPMASS_U GEWEI MEINS UNIT 3   0   Weight Unit *
197 .INCLUDE       0   0   Dynamic Values Staff and Vehicles for Transport Planning  
198 /BEV1/RPF1NA1 /DSD/RP_DRIVER1_NAME NAME CHAR 35   0   Name of Driver 1  
199 /BEV1/RPF2NA1 /DSD/RP_DRIVER2_NAME NAME CHAR 35   0   Name of Driver 2  
200 /BEV1/RPMOBEZ /DSD/RP_TRUCK_NAME TEXT40 CHAR 40   0   Description of Tractor  
201 /BEV1/RPAHBEZ /DSD/RP_TRAIL_NAME TEXT40 CHAR 40   0   Description of Trailer  
202 .INCLUDE       0   0   Fields from the Shipment Stage (Dispatch)  
203 KNOTA KNOTA KNOTN CHAR 10   0   Departure Point TVKN
204 .INCLU-A       0   0   Communication Fields from the Addresses (Dispatch)  
205 LAND1A LAND1A LAND1 CHAR 3   0   Country key for point of departure T005
206 PSTLZA PSTLZA PSTLZ CHAR 10   0   Departure postal code  
207 LZONEA LZONEA ZONE CHAR 10   0   Departure zone TZONE
208 REGIOA REGIOA REGIO CHAR 3   0   Departure region (federal state, county, province, duchy) T005S
209 TRFZNA TRFZNA TRFZN CHAR 10   0   Tariff zone of point of departure TVFTZ
210 .INCLUDE       0   0   Fields from the Shipment Stage (Target)  
211 KNOTZ KNOTZ KNOTN CHAR 10   0   Destination point TVKN
212 .INCLU-Z       0   0   Communication Fields from the Addresses (Target)  
213 LAND1Z LAND1Z LAND1 CHAR 3   0   Country key T005
214 PSTLZZ PSTLZZ PSTLZ CHAR 10   0   Target postal code  
215 LZONEZ LZONEZ ZONE CHAR 10   0   Destination zone TZONE
216 REGIOZ REGIOZ REGIO CHAR 3   0   Destination region (federal state, county, province, duchy) T005S
217 TRFZNZ TRFZNZ TRFZN CHAR 10   0   Tariff zone of point of destination TVFTZ
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VTTKF /BEV1/RPFAR1 KNA1 KUNNR    
2 VTTKF /BEV1/RPFAR2 KNA1 KUNNR    
3 VTTKF ADD01 VTADD01 ADD_INFO    
4 VTTKF ADD02 VTADD02 ADD_INFO    
5 VTTKF ADD03 VTADD03 ADD_INFO    
6 VTTKF ADD04 VTADD04 ADD_INFO    
7 VTTKF KKALSM T683 KALSM    
8 VTTKF KNOTA TVKN KNOTE    
9 VTTKF KNOTZ TVKN KNOTE    
10 VTTKF LAND1A T005 LAND1    
11 VTTKF LAND1Z T005 LAND1    
12 VTTKF LZONEA TZONE ZONE1    
13 VTTKF LZONEZ TZONE ZONE1    
14 VTTKF MANDT T000 MANDT KEY 1 CN
15 VTTKF PROLI TDGC5 PROLI    
16 VTTKF REGIOA T005S BLAND    
17 VTTKF REGIOZ T005S BLAND    
18 VTTKF ROUTE TVRO ROUTE REF C CN
19 VTTKF SDABW TVSAK SDABW    
20 VTTKF SHTYP TVTK SHTYP REF 1 CN
21 VTTKF TDLNR LFA1 LIFNR REF 1 CN
22 VTTKF TNDR_ACTC TCURC WAERS REF 1 CN
23 VTTKF TNDR_MAXC TCURC WAERS REF 1 CN
24 VTTKF TPLST TTDS TPLST REF 1 CN
25 VTTKF TRFZNA TVFTZ TRFZN    
26 VTTKF TRFZNZ TVFTZ TRFZN    
27 VTTKF VSANL T173 VSART REF C CN
28 VTTKF VSART T173 VSART REF C CN
29 VTTKF VSAVL T173 VSART REF C CN
30 VTTKF VSBED TVSB VSBED REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in