SAP table VTTK (Shipment Header)

SAP table VTTK has 2 primary key fields being MANDT,TKNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TKNUM Shipment Number CHAR 10 0 TKNUM
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
SHTYP Shipment type CHAR 4 0 TVTK SHTYP
TPLST Transportation planning point CHAR 4 0 TTDS TPLST
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
STERM Leg determination CHAR 1 0 STERM
Blank: No legs to be determined
0 0: Only determine assignment of deliveries to stages
1 1: Legs determined according to departure point & itinerary
2 2: Prelim.leg per loading point, subsqnt leg per ship-to pty
3 3: Determine preliminary and subsequent leg by delivery note
4 4: As 1, but ship. type for prel. and subs. legs changeable
ABFER Shipment completion type CHAR 1 0 ABFER
1 Loaded outbound shipment
2 Loaded inbound shipment
3 Empty outbound shipment
4 Empty inbound shipment
ABWST Processing control CHAR 1 0 ABWST
1 Individual shipment using one mode of transport
2 Individual shipment using several modes of transport
3 Collective shipment using one mode of transport
4 Collective shipment using several modes of transport
BFART Service Level CHAR 1 0 BFART
1 Load
2 General cargo
3 Groupage
4 Express
VSART Shipping Type CHAR 2 0 T173 VSARTTR
VSAVL Shipping type of preliminary leg CHAR 2 0 T173 VSAVL
VSANL Shipping type of subsequent leg CHAR 2 0 T173 VSANL
LAUFK Leg Indicator CHAR 1 0 LAUFK
1 Preliminary leg
2 Main leg
3 Subsequent leg
4 Direct leg
5 Return leg
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
ROUTE Shipment route CHAR 6 0 TVRO ROUTR
SIGNI Container ID CHAR 20 0 SIGNI
EXTI1 External identification 1 CHAR 20 0 EXTI1
EXTI2 External identification 2 CHAR 20 0 EXTI2
TPBEZ Description of Shipment CHAR 20 0 TPBEZ
STDIS Status of transportation planning CHAR 1 0 STDIS
DTDIS Date of end of planning DATS 8 0 DTDIS
UZDIS Scheduling end time TIMS 6 0 UZDIS
STREG Status of check-in CHAR 1 0 STREG
DPREG Planned date of check-in DATS 8 0 DPREG
UPREG Planned check-in time TIMS 6 0 UPREG
DAREG Actual date of check-in DATS 8 0 DAREG
UAREG Current time of check-in TIMS 6 0 UAREG
STLBG Status for start of loading CHAR 1 0 STLBG
DPLBG Planned date for start of loading DATS 8 0 DPLBG
UPLBG Planned loading start time TIMS 6 0 UPLBG
DALBG Current date for start of loading DATS 8 0 DALBG
UALBG Actual loading start time TIMS 6 0 UALBG
STLAD Status for end of loading CHAR 1 0 STLAD
DPLEN Planned date for end of loading DATS 8 0 DPLEND
UPLEN Planned loading end time TIMS 6 0 UPLEND
DALEN Actual date for end of loading DATS 8 0 DALEND
UALEN Actual loading end time TIMS 6 0 UALEND
STABF Status of shipment completion CHAR 1 0 STABF
DPABF Planned date for shipment completion DATS 8 0 DPABF
UPABF Planned time for processing TIMS 6 0 UPABF
DTABF Current date of shipment completion DATS 8 0 DTABF
UZABF Time of transportation processing TIMS 6 0 UZABF
STTBG Status for start of shipment CHAR 1 0 STTBG
DPTBG Planned date for start of shipment DATS 8 0 DPTBG
UPTBG Planned transport start time TIMS 6 0 UPTBG
DATBG Current date for start of shipment DATS 8 0 DATBG
UATBG Actual transport start time TIMS 6 0 UATBG
STTEN Status for end of shipment CHAR 1 0 STTEN
DPTEN Planned date for end of shipment DATS 8 0 DPTEN
UPTEN Planned transport end time TIMS 6 0 UPTEN
DATEN Actual Date for End of Shipment DATS 8 0 DATEND
UATEN Actual shipment end time TIMS 6 0 UATEND
STTRG Overall transportation status CHAR 1 0 STTRG
0 Planned
1 Planning completed
2 Check-in
3 Loading start
4 Loading end
5 Shipment completion
6 Shipment start
7 Shipment end
TDLNR Number of forwarding agent CHAR 10 0 LFA1 TDLNR
TERNR Order Number CHAR 12 0 AUFNR
PKSTK Shipment Contains Handling Units CHAR 1 0 PKSTK_VTTK
DTMEG Unit of Weight for Transportation Planning UNIT 3 0 DTMEG
DTMEV Volume Unit for Transportation Planning UNIT 3 0 DTMEV
DISTZ Distance QUAN 13 3 DISTZ
MEDST Distance Unit of Measure UNIT 3 0 MEDST
FAHZT Travelling time only between two locations QUAN 5 2 FAHZT
GESZT Total travelling time between two locations incl. breaks QUAN 5 2 GESZT
MEIZT Unit of measure for travelling times UNIT 3 0 MEIZT
STAFO Update Group for statistics update CHAR 6 0 STAFO
FBSTA Status of shipment costs calculation CHAR 1 0 FBSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
FBGST Overall status of calculation of shipment costs for shipment CHAR 1 0 FBGST
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARSTA Status of shipment costs settlement CHAR 1 0 ARSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARGST Total status of shipment costs settlement for shipment CHAR 1 0 ARGST
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
STERM_DONE Leg determination complete CHAR 1 0 STERM_DONE
Leg determination not executed
X Leg determination executed
VSE_FRK Handling Unit Data are Referred in Shipment Cost Document CHAR 1 0 VSE_FRK
No
X Yes
KKALSM Pricing procedure in shipment header CHAR 6 0 T683 KALSM_KOPF
SDABW Special Processing Indicator CHAR 4 0 TVSAK SDABW
FRKRL Shipment costs relevance CHAR 1 0 KFRKRL
GESZTD Planned total time of transportation (in days) DEC 11 0 KP_GESZTDP
FAHZTD Planned duration of transportation (in hours:minutes) DEC 11 0 KP_EFFZTDP
GESZTDA Actual total time of shipment (in days) DEC 11 0 KP_GESZTDA
FAHZTDA Actual time needed for transporation (in hours:minutes) DEC 11 0 KP_EFFZTDA
ROCPY_DONE Route copied from delivery CHAR 1 0 ROCPY_DONE
Route not copied from delivery
X Route copied from delivery
HANDLE Globally unique identifier (linked to time segment, etc) CHAR 22 0 TSEGGUID
TSEGFL Time segment exists CHAR 1 0 TSEGEXISTS
TSEGTP Time segment event group shipment header CHAR 10 0 TSEGTPLVTT
ADD01 Suppl. 1 CHAR 10 0 VTADD01 VTTK_ADD01
ADD02 Suppl. 2 CHAR 10 0 VTADD02 VTTK_ADD02
ADD03 Suppl. 3 CHAR 10 0 VTADD03 VTTK_ADD03
ADD04 Suppl. 4 CHAR 10 0 VTADD04 VTTK_ADD04
TEXT1 Addit.text 1 CHAR 40 0 VTTK_TEXT1
TEXT2 Addit.text 2 CHAR 40 0 VTTK_TEXT2
TEXT3 Addit.text 3 CHAR 40 0 VTTK_TEXT3
TEXT4 Addit.text 4 CHAR 40 0 VTTK_TEXT4
PROLI Dangerous Goods Management Profile in SD Documents CHAR 3 0 TDGC5 ADGE_PROLI
DGTLOCK Block Indicator for Dangerous Goods CHAR 1 0 ADGE_TLOCK
DGMDDAT Selection date dangerous goods master data DATS 8 0 ADGE_MDDAT
CONT_DG Indicator: Document contains dangerous goods CHAR 1 0 ADGE_NCDG
WARZTD Planned waiting time of shipment (in hours:minutes) DEC 11 0 KP_WARZTDP
WARZTDA Current waiting time of shipment (in hours:minutes) DEC 11 0 KP_WARZTDA
AULWE Route Schedule CHAR 10 0 AULWE
TNDRST Tender Status CHAR 2 0 TNDRST
Not offered to forwarding agent
AC Accepted by forwarding agent
AW Accepted by forwarding agent with conditions
CF Confirmed by shipper
CN Offer canceled
EX Exception triggered by forwarding agent
NW New offer from shipper
RJ Rejected by forwarding agent
TNDRRC Acceptance Condition/Rejection Reason CHAR 2 0 TNDRRC
DL Delays
SE Shortage of Equipment
TNDR_TEXT Tendering Text CHAR 80 0 TNDR_TEXT
TNDRDAT Date of tender status DATS 8 0 TNDRDAT
TNDRZET Time of tender status TIMS 6 0 TNDRZET
TNDR_MAXP Maximum Price for Shipment CURR 15 2 TNDR_MAXP
TNDR_MAXC Currency of Maximum Price CUKY 5 0 TCURC TNDR_MAXC
TNDR_ACTP Actual Shipment Costs for Shipment CURR 15 2 TNDR_ACTP
TNDR_ACTC Currency of Actual Shipment Costs CUKY 5 0 TCURC TNDR_ACTC
TNDR_CARR Forwarding Agent Who Accepted the Shipment CHAR 10 0 TNDR_CARR
TNDR_CRNM Name of Carrier Who Accepted the Shipment CHAR 35 0 TNDR_CRNM
TNDR_TRKID Forwarding Agent Tracking ID CHAR 35 0 TNDR_TRKID
TNDR_EXPD Date on Which Offer Expires DATS 8 0 TNDR_EXPD
TNDR_EXPT Time at Which Quotation Expires TIMS 6 0 TNDR_EXPT
TNDR_ERPD Earliest Pickup Date DATS 8 0 TNDR_ERPD
TNDR_ERPT Earliest Pickup Time TIMS 6 0 TNDR_ERPT
TNDR_LTPD Latest Pickup Date DATS 8 0 TNDR_LTPD
TNDR_LTPT Latest Pickup Time TIMS 6 0 TNDR_LTPT
TNDR_ERDD Earliest Delivery Date DATS 8 0 TNDR_ERDD
TNDR_ERDT Earliest Delivery Time TIMS 6 0 TNDR_ERDT
TNDR_LTDD Latest Delivery Date DATS 8 0 TNDR_LTDD
TNDR_LTDT Latest Delivery Time TIMS 6 0 TNDR_LTDT
TNDR_LDLG Length of Loading Platform QUAN 13 3 TNDR_LDLG
TNDR_LDLU Unit of Measure for Load Length UNIT 3 0 TNDR_LDLU
KZHULFR Indicator: HUs Relevant for Delivery Item Generation CHAR 1 0 KZHULFR
HU not relevant for delivery item generation
X HUs are relevant, but no delivery items have been generated
Y HUs relevant. Del.items have been generated at least once
ALLOWED_TWGT Allowed total weight of shipment QUAN 8 0 ALLOWED_TWGT
VLSTK Distribution Status (Decentralized Warehouse Processing) CHAR 1 0 VLSTK
Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
VERURSYS Shipment Distribution: Original System CHAR 10 0 TRA_VERURSYS
CM_IDENT Identification Number for Continuous Moves CHAR 12 0 CMIDENTIFIER
CM_SEQUENCE Sequence of Transports in Connecting Traffice NUMC 4 0 CMSEQUENCE
EXT_FREIGHT_ORD External Freight Order ID CHAR 20 0 EXT_FREIGHT_ORDER
EXT_TM_SYS Key Name of Business System CHAR 60 0 SLD_BSKEY
/BEV1/RPFAR1 Driver 1 CHAR 10 0 KNA1 /DSD/RP_DRIVER1
/BEV1/RPFAR2 Driver 2 CHAR 10 0 KNA1 /DSD/RP_DRIVER2
/BEV1/RPMOWA Vehicle CHAR 18 0 * /DSD/RP_TRUCK
/BEV1/RPANHAE Trailer CHAR 18 0 * /DSD/RP_TRAIL
/BEV1/RPFLGNR Loading Sequence Number in the Tour NUMC 5 0 /DSD/RP_SEQUENCENR
/VSO/R_STATUS Status of Vehicle Space Optimization CHAR 1 0 /VSO/M_VSO_STATUS
0 Blank
1 OK
2 OK with Warnings
3 OK, Set Manually
4 Incorrect
5 Failed, Set Manually

VTTK foreign key relationships

Table Field Check Table Check Field
0 VTTK /BEV1/RPFAR1 KNA1 General Data in Customer Master MANDT
0 VTTK /BEV1/RPFAR1 KNA1 General Data in Customer Master KUNNR
1 VTTK /BEV1/RPFAR2 KNA1 General Data in Customer Master MANDT
1 VTTK /BEV1/RPFAR2 KNA1 General Data in Customer Master KUNNR
0 VTTK ADD01 VTADD01 Checking Table Supplement 1 MANDT
0 VTTK ADD01 VTADD01 Checking Table Supplement 1 ADD_INFO
1 VTTK ADD02 VTADD02 Checking Table Supplement 2 MANDT
1 VTTK ADD02 VTADD02 Checking Table Supplement 2 ADD_INFO
0 VTTK ADD03 VTADD03 Checking Table Supplement 3 MANDT
0 VTTK ADD03 VTADD03 Checking Table Supplement 3 ADD_INFO
1 VTTK ADD04 VTADD04 Checking Table Supplement 4 MANDT
1 VTTK ADD04 VTADD04 Checking Table Supplement 4 ADD_INFO
0 VTTK KKALSM T683 Pricing procedures KAPPL
0 VTTK KKALSM T683 Pricing procedures KALSM
1 VTTK MANDT T000 Clients MANDT
0 VTTK PROLI TDGC5 DG: Dangerous Goods Management Profile for SD Documents MANDT
0 VTTK PROLI TDGC5 DG: Dangerous Goods Management Profile for SD Documents PROLI
1 VTTK ROUTE TVRO Routes MANDT
1 VTTK ROUTE TVRO Routes ROUTE
0 VTTK SDABW TVSAK Special Processing Indicator SDABW
1 VTTK SHTYP TVTK Shipment Types MANDT
0 VTTK TDLNR LFA1 Supplier Master (General Section) MANDT
0 VTTK TDLNR LFA1 Supplier Master (General Section) LIFNR
1 VTTK TNDR_ACTC TCURC Currency Codes MANDT
1 VTTK TNDR_ACTC TCURC Currency Codes WAERS
0 VTTK TNDR_MAXC TCURC Currency Codes MANDT
0 VTTK TNDR_MAXC TCURC Currency Codes WAERS
1 VTTK TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 VTTK VSANL T173 Routes: Mode of Transport for Each Shipping Type MANDT
0 VTTK VSANL T173 Routes: Mode of Transport for Each Shipping Type VSART
1 VTTK VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
1 VTTK VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
0 VTTK VSAVL T173 Routes: Mode of Transport for Each Shipping Type MANDT
0 VTTK VSAVL T173 Routes: Mode of Transport for Each Shipping Type VSART
1 VTTK VSBED TVSB Shipping Conditions MANDT
1 VTTK VSBED TVSB Shipping Conditions VSBED