SAP Table VTTK

Shipment Header

VTTK (Shipment Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VTTK to other SAP tables.

VTTK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TKNUM Shipment Number TKNUM CHAR 10 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
SHTYP Shipment type SHTYP TVTK CHAR 4 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
STERM Leg determination STERM CHAR 1 0
NULL 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 ABFER CHAR 1 0
1 Loaded outbound shipment
2 Loaded inbound shipment
3 Empty outbound shipment
4 Empty inbound shipment
ABWST Processing control ABWST CHAR 1 0
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 BFART CHAR 1 0
1 Load
2 General cargo
3 Groupage
4 Express
VSART Shipping type VSARTTR T173 CHAR 2 0
VSAVL Shipping type of preliminary leg VSAVL T173 CHAR 2 0
VSANL Shipping type of subsequent leg VSANL T173 CHAR 2 0
LAUFK Leg Indicator LAUFK CHAR 1 0
1 Preliminary leg
2 Main leg
3 Subsequent leg
4 Direct leg
5 Return leg
VSBED Shipping Conditions VSBED TVSB CHAR 2 0
ROUTE Shipment route ROUTR TVRO CHAR 6 0
SIGNI Container ID SIGNI CHAR 20 0
EXTI1 External identification 1 EXTI1 CHAR 20 0
EXTI2 External identification 2 EXTI2 CHAR 20 0
TPBEZ Description of Shipment TPBEZ CHAR 20 0
STDIS Status of transportation planning STDIS CHAR 1 0
NULL Not completed
X Completed
DTDIS Date of end of planning DTDIS DATS 8 0
UZDIS Scheduling end time UZDIS TIMS 6 0
STREG Status of check-in STREG CHAR 1 0
NULL Not completed
X Completed
DPREG Planned date of check-in DPREG DATS 8 0
UPREG Planned check-in time UPREG TIMS 6 0
DAREG Actual date of check-in DAREG DATS 8 0
UAREG Current time of check-in UAREG TIMS 6 0
STLBG Status for start of loading STLBG CHAR 1 0
NULL Not completed
X Completed
DPLBG Planned date for start of loading DPLBG DATS 8 0
UPLBG Planned loading start time UPLBG TIMS 6 0
DALBG Current date for start of loading DALBG DATS 8 0
UALBG Actual loading start time UALBG TIMS 6 0
STLAD Status for end of loading STLAD CHAR 1 0
NULL Not completed
X Completed
DPLEN Planned date for end of loading DPLEND DATS 8 0
UPLEN Planned loading end time UPLEND TIMS 6 0
DALEN Actual date for end of loading DALEND DATS 8 0
UALEN Actual loading end time UALEND TIMS 6 0
STABF Status of shipment completion STABF CHAR 1 0
NULL Not completed
X Completed
DPABF Planned date for shipment completion DPABF DATS 8 0
UPABF Planned time for processing UPABF TIMS 6 0
DTABF Current date of shipment completion DTABF DATS 8 0
UZABF Time of transportation processing UZABF TIMS 6 0
STTBG Status for start of shipment STTBG CHAR 1 0
NULL Not completed
X Completed
DPTBG Planned date for start of shipment DPTBG DATS 8 0
UPTBG Planned transport start time UPTBG TIMS 6 0
DATBG Current date for start of shipment DATBG DATS 8 0
UATBG Actual transport start time UATBG TIMS 6 0
STTEN Status for end of shipment STTEN CHAR 1 0
NULL Not completed
X Completed
DPTEN Planned date for end of shipment DPTEN DATS 8 0
UPTEN Planned transport end time UPTEN TIMS 6 0
DATEN Actual Date for End of Shipment DATEND DATS 8 0
UATEN Actual shipment end time UATEND TIMS 6 0
STTRG Overall transportation status STTRG CHAR 1 0
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 TDLNR LFA1 CHAR 10 0
TERNR Order Number AUFNR CHAR 12 0
PKSTK Shipment Contains Handling Units PKSTK_VTTK CHAR 1 0
X Yes
NULL No
DTMEG Unit of Weight for Transportation Planning DTMEG UNIT 3 0
DTMEV Volume Unit for Transportation Planning DTMEV UNIT 3 0
DISTZ Distance DISTZ QUAN 13 3
MEDST Unit of measure for distance MEDST UNIT 3 0
FAHZT Travelling time only between two locations FAHZT QUAN 5 2
GESZT Total travelling time between two locations incl. breaks GESZT QUAN 5 2
MEIZT Unit of measure for travelling times MEIZT UNIT 3 0
STAFO Update group for statistics update STAFO CHAR 6 0
FBSTA Status of shipment costs calculation FBSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
FBGST Overall status of calculation of shipment costs for shipment FBGST CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARSTA Status of shipment costs settlement ARSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARGST Total status of shipment costs settlement for shipment ARGST CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
STERM_DONE Leg determination complete STERM_DONE CHAR 1 0
X Leg determination executed
NULL Leg determination not executed
VSE_FRK Handling Unit Data are Referred in Shipment Cost Document VSE_FRK CHAR 1 0
X Yes
NULL No
KKALSM Pricing procedure in shipment header KALSM_KOPF T683 CHAR 6 0
SDABW Special processing indicator SDABW TVSAK CHAR 4 0
FRKRL Shipment costs relevance KFRKRL CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
GESZTD Planned total time of transportation (in days) KP_GESZTDP DEC 11 0
FAHZTD Planned duration of transportation (in hours:minutes) KP_EFFZTDP DEC 11 0
GESZTDA Actual total time of shipment (in days) KP_GESZTDA DEC 11 0
FAHZTDA Actual time needed for transporation (in hours:minutes) KP_EFFZTDA DEC 11 0
ROCPY_DONE Route copied from delivery ROCPY_DONE CHAR 1 0
X Route copied from delivery
NULL Route not copied from delivery
HANDLE Globally unique identifier (linked to time segment, etc) TSEGGUID CHAR 22 0
TSEGFL Time segment exists TSEGEXISTS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
TSEGTP Time segment event group shipment header TSEGTPLVTT CHAR 10 0
ADD01 Suppl. 1 VTTK_ADD01 VTADD01 CHAR 10 0
ADD02 Suppl. 2 VTTK_ADD02 VTADD02 CHAR 10 0
ADD03 Suppl. 3 VTTK_ADD03 VTADD03 CHAR 10 0
ADD04 Suppl. 4 VTTK_ADD04 VTADD04 CHAR 10 0
TEXT1 Addit.text 1 VTTK_TEXT1 CHAR 40 0
TEXT2 Addit.text 2 VTTK_TEXT2 CHAR 40 0
TEXT3 Addit.text 3 VTTK_TEXT3 CHAR 40 0
TEXT4 Addit.text 4 VTTK_TEXT4 CHAR 40 0
PROLI Dangerous Goods Management Profile in SD Documents ADGE_PROLI TDGC5 CHAR 3 0
DGTLOCK Block Indicator for Dangerous Goods ADGE_TLOCK CHAR 1 0
X Yes
NULL No
DGMDDAT Selection date dangerous goods master data ADGE_MDDAT DATS 8 0
CONT_DG Indicator: Document contains dangerous goods ADGE_NCDG CHAR 1 0
X Yes
NULL No
WARZTD Planned waiting time of shipment (in hours:minutes) KP_WARZTDP DEC 11 0
WARZTDA Current waiting time of shipment (in hours:minutes) KP_WARZTDA DEC 11 0
AULWE Route Schedule AULWE CHAR 10 0
TNDRST Tender Status TNDRST CHAR 2 0
NW New offer from shipper
AC Accepted by forwarding agent
AW Accepted by forwarding agent with conditions
RJ Rejected by forwarding agent
CF Confirmed by shipper
EX Exception triggered by forwarding agent
NULL Not offered to forwarding agent
CN Offer canceled
TNDRRC Acceptance Condition/Rejection Reason TNDRRC CHAR 2 0
SE Shortage of Equipment
DL Delays
NULL
TNDR_TEXT Tendering Text TNDR_TEXT CHAR 80 0
TNDRDAT Date of tender status TNDRDAT DATS 8 0
TNDRZET Time of tender status TNDRZET TIMS 6 0
TNDR_MAXP Maximum Price for Shipment TNDR_MAXP CURR 15 2
TNDR_MAXC Currency of Maximum Price TNDR_MAXC TCURC CUKY 5 0
TNDR_ACTP Actual Shipment Costs for Shipment TNDR_ACTP CURR 15 2
TNDR_ACTC Currency of Actual Shipment Costs TNDR_ACTC TCURC CUKY 5 0
TNDR_CARR Forwarding Agent Who Accepted the Shipment TNDR_CARR CHAR 10 0
TNDR_CRNM Name of Carrier Who Accepted the Shipment TNDR_CRNM CHAR 35 0
TNDR_TRKID Forwarding Agent Tracking ID TNDR_TRKID CHAR 35 0
TNDR_EXPD Date on Which Offer Expires TNDR_EXPD DATS 8 0
TNDR_EXPT Time at Which Quotation Expires TNDR_EXPT TIMS 6 0
TNDR_ERPD Earliest Pickup Date TNDR_ERPD DATS 8 0
TNDR_ERPT Earliest Pickup Time TNDR_ERPT TIMS 6 0
TNDR_LTPD Latest Pickup Date TNDR_LTPD DATS 8 0
TNDR_LTPT Latest Pickup Time TNDR_LTPT TIMS 6 0
TNDR_ERDD Earliest Delivery Date TNDR_ERDD DATS 8 0
TNDR_ERDT Earliest Delivery Time TNDR_ERDT TIMS 6 0
TNDR_LTDD Latest Delivery Date TNDR_LTDD DATS 8 0
TNDR_LTDT Latest Delivery Time TNDR_LTDT TIMS 6 0
TNDR_LDLG Length of Loading Platform TNDR_LDLG QUAN 13 3
TNDR_LDLU Unit of Measure for Load Length TNDR_LDLU UNIT 3 0
KZHULFR Indicator: HUs Relevant for Delivery Item Generation KZHULFR CHAR 1 0
NULL 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 ALLOWED_TWGT QUAN 8 0
VLSTK Distribution Status (Decentralized Warehouse Processing) VLSTK CHAR 1 0
NULL 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 TRA_VERURSYS CHAR 10 0
CM_IDENT Identification Number for Continuous Moves CMIDENTIFIER CHAR 12 0
CM_SEQUENCE Sequence of Transports in Connecting Traffice CMSEQUENCE NUMC 4 0
EXT_FREIGHT_ORD External Freight Order ID EXT_FREIGHT_ORDER CHAR 20 0
EXT_TM_SYS Key Name of Business System SLD_BSKEY CHAR 60 0
/BEV1/RPFAR1 Driver 1 /DSD/RP_DRIVER1 KNA1 CHAR 10 0
/BEV1/RPFAR2 Driver 2 /DSD/RP_DRIVER2 KNA1 CHAR 10 0
/BEV1/RPMOWA Vehicle /DSD/RP_TRUCK CHAR 18 0
/BEV1/RPANHAE Trailer /DSD/RP_TRAIL CHAR 18 0
/BEV1/RPFLGNR Loading Sequence Number in the Tour /DSD/RP_SEQUENCENR NUMC 5 0
/VSO/R_STATUS Status of Vehicle Space Optimization /VSO/M_VSO_STATUS CHAR 1 0
0 Blank
1 OK
2 OK with Warnings
3 OK, Set Manually
4 Incorrect
5 Failed, Set Manually

VTTK foreign key relationships

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