Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

TKNUM

Shipment Number

TKNUM

CHAR

VBTYP

SD document category

VBTYP

CHAR

Value	Description
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
NULL	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

TPLST

Transportation planning point

TPLST

TTDS

CHAR

ERNAM

Name of Person who Created the Object

ERNAM

CHAR

ERDAT

Date on Which Record Was Created

ERDAT

DATS

ERZET

Entry time

ERZET

TIMS

AENAM

Name of Person Who Changed Object

AENAM

CHAR

AEDAT

Changed On

AEDAT

DATS

AEZET

Time last change was made

AEZET

TIMS

STERM

Leg determination

STERM

CHAR

Value	Description
NULL	Blank: No legs to be determined
NULL	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

Value	Description
1	Loaded outbound shipment
2	Loaded inbound shipment
3	Empty outbound shipment
4	Empty inbound shipment

ABWST

Processing control

ABWST

CHAR

Value	Description
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

Value	Description
1	Load
2	General cargo
3	Groupage
4	Express

VSART

Shipping type

VSARTTR

T173

CHAR

VSAVL

Shipping type of preliminary leg

VSAVL

T173

CHAR

VSANL

Shipping type of subsequent leg

VSANL

T173

CHAR

LAUFK

Leg Indicator

LAUFK

CHAR

Value	Description
1	Preliminary leg
2	Main leg
3	Subsequent leg
4	Direct leg
5	Return leg

VSBED

Shipping Conditions

VSBED

TVSB

CHAR

ROUTE

Shipment route

ROUTR

TVRO

CHAR

SIGNI

Container ID

SIGNI

CHAR

EXTI1

External identification 1

EXTI1

CHAR

EXTI2

External identification 2

EXTI2

CHAR

TPBEZ

Description of Shipment

TPBEZ

CHAR

STDIS

Status of transportation planning

STDIS

CHAR

Value	Description
NULL	Not completed
X	Completed

DTDIS

Date of end of planning

DTDIS

DATS

UZDIS

Scheduling end time

UZDIS

TIMS

STREG

Status of check-in

STREG

CHAR

Value	Description
NULL	Not completed
X	Completed

DPREG

Planned date of check-in

DPREG

DATS

UPREG

Planned check-in time

UPREG

TIMS

DAREG

Actual date of check-in

DAREG

DATS

UAREG

Current time of check-in

UAREG

TIMS

STLBG

Status for start of loading

STLBG

CHAR

Value	Description
NULL	Not completed
X	Completed

DPLBG

Planned date for start of loading

DPLBG

DATS

UPLBG

Planned loading start time

UPLBG

TIMS

DALBG

Current date for start of loading

DALBG

DATS

UALBG

Actual loading start time

UALBG

TIMS

STLAD

Status for end of loading

STLAD

CHAR

Value	Description
NULL	Not completed
X	Completed

DPLEN

Planned date for end of loading

DPLEND

DATS

UPLEN

Planned loading end time

UPLEND

TIMS

DALEN

Actual date for end of loading

DALEND

DATS

UALEN

Actual loading end time

UALEND

TIMS

STABF

Status of shipment completion

STABF

CHAR

Value	Description
NULL	Not completed
X	Completed

DPABF

Planned date for shipment completion

DPABF

DATS

UPABF

Planned time for processing

UPABF

TIMS

DTABF

Current date of shipment completion

DTABF

DATS

UZABF

Time of transportation processing

UZABF

TIMS

STTBG

Status for start of shipment

STTBG

CHAR

Value	Description
NULL	Not completed
X	Completed

DPTBG

Planned date for start of shipment

DPTBG

DATS

UPTBG

Planned transport start time

UPTBG

TIMS

DATBG

Current date for start of shipment

DATBG

DATS

UATBG

Actual transport start time

UATBG

TIMS

STTEN

Status for end of shipment

STTEN

CHAR

Value	Description
NULL	Not completed
X	Completed

DPTEN

Planned date for end of shipment

DPTEN

DATS

UPTEN

Planned transport end time

UPTEN

TIMS

DATEN

Actual Date for End of Shipment

DATEND

DATS

UATEN

Actual shipment end time

UATEND

TIMS

STTRG

Overall transportation status

STTRG

CHAR

Value	Description
NULL	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

TERNR

Order Number

AUFNR

CHAR

PKSTK

Shipment Contains Handling Units

PKSTK_VTTK

CHAR

Value	Description
X	Yes
NULL	No

DTMEG

Unit of Weight for Transportation Planning

DTMEG

UNIT

DTMEV

Volume Unit for Transportation Planning

DTMEV

UNIT

DISTZ

Distance

DISTZ

QUAN

MEDST

Unit of measure for distance

MEDST

UNIT

FAHZT

Travelling time only between two locations

FAHZT

QUAN

GESZT

Total travelling time between two locations incl. breaks

GESZT

QUAN

MEIZT

Unit of measure for travelling times

MEIZT

UNIT

STAFO

Update group for statistics update

STAFO

CHAR

FBSTA

Status of shipment costs calculation

FBSTA

CHAR

Value	Description
NULL	Not Relevant
A	Not Processed
B	Partially Processed
C	Completely Processed

FBGST

Overall status of calculation of shipment costs for shipment

FBGST

CHAR

Value	Description
NULL	Not Relevant
A	Not Processed
B	Partially Processed
C	Completely Processed

ARSTA

Status of shipment costs settlement

ARSTA

CHAR

Value	Description
NULL	Not Relevant
A	Not Processed
B	Partially Processed
C	Completely Processed

ARGST

Total status of shipment costs settlement for shipment

ARGST

CHAR

Value	Description
NULL	Not Relevant
A	Not Processed
B	Partially Processed
C	Completely Processed

STERM_DONE

Leg determination complete

STERM_DONE

CHAR

Value	Description
X	Leg determination executed
NULL	Leg determination not executed

VSE_FRK

Handling Unit Data are Referred in Shipment Cost Document

VSE_FRK

CHAR

Value	Description
X	Yes
NULL	No

KKALSM

Pricing procedure in shipment header

KALSM_KOPF

T683

CHAR

SDABW

Special processing indicator

SDABW

TVSAK

CHAR

FRKRL

Shipment costs relevance

KFRKRL

CHAR

Value	Description
X	Relevant for freight costs
NULL	Not relevant for freight costs

GESZTD

Planned total time of transportation (in days)

KP_GESZTDP

DEC

FAHZTD

Planned duration of transportation (in hours:minutes)

KP_EFFZTDP

DEC

GESZTDA

Actual total time of shipment (in days)

KP_GESZTDA

DEC

FAHZTDA

Actual time needed for transporation (in hours:minutes)

KP_EFFZTDA

DEC

ROCPY_DONE

Route copied from delivery

ROCPY_DONE

CHAR

Value	Description
X	Route copied from delivery
NULL	Route not copied from delivery

HANDLE

Globally unique identifier (linked to time segment, etc)

TSEGGUID

CHAR

TSEGFL

Time segment exists

TSEGEXISTS

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

TSEGTP

Time segment event group shipment header

TSEGTPLVTT

CHAR

ADD01

Suppl. 1

VTTK_ADD01

VTADD01

CHAR

ADD02

Suppl. 2

VTTK_ADD02

VTADD02

CHAR

ADD03

Suppl. 3

VTTK_ADD03

VTADD03

CHAR

ADD04

Suppl. 4

VTTK_ADD04

VTADD04

CHAR

TEXT1

Addit.text 1

VTTK_TEXT1

CHAR

TEXT2

Addit.text 2

VTTK_TEXT2

CHAR

TEXT3

Addit.text 3

VTTK_TEXT3

CHAR

TEXT4

Addit.text 4

VTTK_TEXT4

CHAR

PROLI

Dangerous Goods Management Profile in SD Documents

ADGE_PROLI

TDGC5

CHAR

DGTLOCK

Block Indicator for Dangerous Goods

ADGE_TLOCK

CHAR

Value	Description
X	Yes
NULL	No

DGMDDAT

Selection date dangerous goods master data

ADGE_MDDAT

DATS

CONT_DG

Indicator: Document contains dangerous goods

ADGE_NCDG

CHAR

Value	Description
X	Yes
NULL	No

WARZTD

Planned waiting time of shipment (in hours:minutes)

KP_WARZTDP

DEC

WARZTDA

Current waiting time of shipment (in hours:minutes)

KP_WARZTDA

DEC

AULWE

Route Schedule

AULWE

CHAR

TNDRST

Tender Status

TNDRST

CHAR

Value	Description
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

Value	Description
SE	Shortage of Equipment
DL	Delays
NULL

TNDR_TEXT

Tendering Text

TNDR_TEXT

CHAR

TNDRDAT

Date of tender status

TNDRDAT

DATS

TNDRZET

Time of tender status

TNDRZET

TIMS

TNDR_MAXP

Maximum Price for Shipment

TNDR_MAXP

CURR

TNDR_MAXC

Currency of Maximum Price

TNDR_MAXC

TCURC

CUKY

TNDR_ACTP

Actual Shipment Costs for Shipment

TNDR_ACTP

CURR

TNDR_ACTC

Currency of Actual Shipment Costs

TNDR_ACTC

TCURC

CUKY

TNDR_CARR

Forwarding Agent Who Accepted the Shipment

TNDR_CARR

CHAR

TNDR_CRNM

Name of Carrier Who Accepted the Shipment

TNDR_CRNM

CHAR

TNDR_TRKID

Forwarding Agent Tracking ID

TNDR_TRKID

CHAR

TNDR_EXPD

Date on Which Offer Expires

TNDR_EXPD

DATS

TNDR_EXPT

Time at Which Quotation Expires

TNDR_EXPT

TIMS

TNDR_ERPD

Earliest Pickup Date

TNDR_ERPD

DATS

TNDR_ERPT

Earliest Pickup Time

TNDR_ERPT

TIMS

TNDR_LTPD

Latest Pickup Date

TNDR_LTPD

DATS

TNDR_LTPT

Latest Pickup Time

TNDR_LTPT

TIMS

TNDR_ERDD

Earliest Delivery Date

TNDR_ERDD

DATS

TNDR_ERDT

Earliest Delivery Time

TNDR_ERDT

TIMS

TNDR_LTDD

Latest Delivery Date

TNDR_LTDD

DATS

TNDR_LTDT

Latest Delivery Time

TNDR_LTDT

TIMS

TNDR_LDLG

Length of Loading Platform

TNDR_LDLG

QUAN

TNDR_LDLU

Unit of Measure for Load Length

TNDR_LDLU

UNIT

KZHULFR

Indicator: HUs Relevant for Delivery Item Generation

KZHULFR

CHAR

Value	Description
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

VLSTK

Distribution Status (Decentralized Warehouse Processing)

VLSTK

CHAR

Value	Description
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

CM_IDENT

Identification Number for Continuous Moves

CMIDENTIFIER

CHAR

CM_SEQUENCE

Sequence of Transports in Connecting Traffice

CMSEQUENCE

NUMC

EXT_FREIGHT_ORD

External Freight Order ID

EXT_FREIGHT_ORDER

CHAR

EXT_TM_SYS

Key Name of Business System

SLD_BSKEY

CHAR

/BEV1/RPFAR1

Driver 1

/DSD/RP_DRIVER1

KNA1

CHAR

/BEV1/RPFAR2

Driver 2

/DSD/RP_DRIVER2

KNA1

CHAR

/BEV1/RPMOWA

Vehicle

/DSD/RP_TRUCK

CHAR

/BEV1/RPANHAE

Trailer

/DSD/RP_TRAIL

CHAR

/BEV1/RPFLGNR

Loading Sequence Number in the Tour

/DSD/RP_SEQUENCENR

NUMC

/VSO/R_STATUS

Status of Vehicle Space Optimization

/VSO/M_VSO_STATUS

CHAR

Value	Description
NULL	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	MANDT	VTADD01 Checking Table Supplement 1	MANDT
VTTK	ADD01	VTTK	ADD01	VTADD01 Checking Table Supplement 1	ADD_INFO
VTTK	ADD02	VTTK	MANDT	VTADD02 Checking Table Supplement 2	MANDT
VTTK	ADD02	VTTK	ADD02	VTADD02 Checking Table Supplement 2	ADD_INFO
VTTK	ADD03	VTTK	ADD03	VTADD03 Checking Table Supplement 3	ADD_INFO
VTTK	ADD03	VTTK	MANDT	VTADD03 Checking Table Supplement 3	MANDT
VTTK	ADD04	VTTK	MANDT	VTADD04 Checking Table Supplement 4	MANDT
VTTK	ADD04	VTTK	ADD04	VTADD04 Checking Table Supplement 4	ADD_INFO
VTTK	KKALSM	VTTK	KKALSM	T683 Pricing procedures	KALSM
VTTK	KKALSM	VTTK	MANDT	T683 Pricing procedures	MANDT
VTTK	KKALSM	'A'		T683 Pricing procedures	KVEWE
VTTK	KKALSM	'F '		T683 Pricing procedures	KAPPL
VTTK	MANDT	VTTK	MANDT	T000 Clients	MANDT
VTTK	PROLI	VTTK	PROLI	TDGC5 DG: Dangerous Goods Management Profile for SD Documents	PROLI
VTTK	PROLI	VTTK	MANDT	TDGC5 DG: Dangerous Goods Management Profile for SD Documents	MANDT
VTTK	ROUTE	VTTK	MANDT	TVRO Routes	MANDT
VTTK	ROUTE	VTTK	ROUTE	TVRO Routes	ROUTE
VTTK	SDABW	VTTK	MANDT	TVSAK Special Processing Indicator	MANDT
VTTK	SDABW	VTTK	SDABW	TVSAK Special Processing Indicator	SDABW
VTTK	SHTYP	VTTK	SHTYP	TVTK Shipment Types	SHTYP
VTTK	SHTYP	VTTK	MANDT	TVTK Shipment Types	MANDT
VTTK	TDLNR	VTTK	MANDT	LFA1 Vendor Master (General Section)	MANDT
VTTK	TDLNR	VTTK	TDLNR	LFA1 Vendor Master (General Section)	LIFNR
VTTK	TNDR_ACTC	VTTK	MANDT	TCURC Currency Codes	MANDT
VTTK	TNDR_ACTC	VTTK	TNDR_ACTC	TCURC Currency Codes	WAERS
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	MANDT	T173 Routes: Mode of Transport for Each Shipping Type	MANDT
VTTK	VSAVL	VTTK	VSAVL	T173 Routes: Mode of Transport for Each Shipping Type	VSART
VTTK	VSBED	VTTK	MANDT	TVSB Shipping Conditions	MANDT
VTTK	VSBED	VTTK	VSBED	TVSB Shipping Conditions	VSBED