Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table VTRKH

Tracking Data - Header

VTRKH (Tracking Data - 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 VTRKH to other SAP tables.

VTRKH table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

CLNT

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

VBELN

Sales and Distribution Document Number

VBELN

CHAR

XSITD

Express Delivery Company

XSITD

VXSITD

CHAR

UEVBTYP

Document Category of Higher-level Document

UEVBTYP

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

UEVBELN

Higher-level Document

UEVBELN

CHAR

TRACKN

Tracking number

TRACKN

CHAR

SHIPACCT

Sender's Account Number with Express Delivery Company

SHIPACCT

CHAR

ROUTECODE

Routing information for XSI carrier

ROUTECODE

CHAR

XSITOUR

Express Delivery Company's Route Number

XSITOUR

CHAR

XSIHUBE

Forwarder's Load Transfer Point for Arriving Goods

XSIHUBE

CHAR

XSIHUBZ

Express Delivery Company's Central Hub

XSIHUBZ

CHAR

XSIHUBA

Forwarder's Outbound Delivery Load Transfer Point

XSIHUBA

CHAR

ROUTELDAT

Last update of routing info data

ROUTELDAT

DATS

XSISRVC

Express Delivery Company's Service Code

XSISRVC

VXSITS

CHAR

PRDCD

Express Delivery Company Product Code

PRDCD

VXSIP

CHAR

VLBLFLAG

VLBL Data Exists (Performance Flag)

VLBLFLAG

CHAR

Value	Description
X	Yes
NULL	No

XSIDATERR

Error in Express Delivery Company Data Field

XSIDATERR

CHAR

Value	Description
X	Yes
NULL	No

TRKSTATO

Previous tracking status

TRKSTATO

CHAR

Value	Description
NULL	No tracking data
A	Picked up
B	Partially picked up
C	Delivered
D	Exception

TRKSTAT

Tracking Status

TRKSTAT

CHAR

Value	Description
NULL	No tracking data
A	Picked up
B	Partially picked up
C	Delivered
D	Exception

TRKEVENT

Tracking event still has to be processed

TRKEVENT

CHAR

Value	Description
X	Yes
NULL	No

TRKSTATD

Tracking status details

TRKSTATD

VXTRKS

CHAR

TRACKTSTMP

Tracking time in UTC format

TRACKTSTMP

DEC

TRKDLVTO

Name of the person that accepted parcel

TRKDLVTO

CHAR

TRKDLVLOC

Location at which parcel/delivery is accepted

TRKDLVLOC

CHAR

SIGNATURL

URL with signature screen

SIGNATURL

CHAR

255

REQTSTMP

Time of last request for tracking data

REQTSTMP

DEC

TRACKTZNZONE

Time Zone

TZNZONE

CHAR

TRACKNCOUN

Tracking number

TRACKN

CHAR

VTRKH foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
VTRKH	PRDCD	VTRKH	MANDT	VXSIP Express Delivery Company: Product Codes	MANDT
VTRKH	PRDCD	VTRKH	XSITD	VXSIP Express Delivery Company: Product Codes	XSITD
VTRKH	PRDCD	VTRKH	PRDCD	VXSIP Express Delivery Company: Product Codes	PRDCD
VTRKH	TRKSTATD	VTRKH	MANDT	VXTRKS Tracking Status Details	MANDT
VTRKH	TRKSTATD	VTRKH	XSITD	VXTRKS Tracking Status Details	XSITD
VTRKH	TRKSTATD	VTRKH	TRKSTATD	VXTRKS Tracking Status Details	TRKSTATD
VTRKH	XSISRVC	VTRKH	XSITD	VXSITS Express Delivery Company: Service Codes	XSITD
VTRKH	XSISRVC	VTRKH	XSISRVC	VXSITS Express Delivery Company: Service Codes	XSISRVC
VTRKH	XSISRVC	VTRKH	MANDT	VXSITS Express Delivery Company: Service Codes	MANDT
VTRKH	XSITD	VTRKH	MANDT	VXSITD Express Delivery Company	MANDT
VTRKH	XSITD	VTRKH	XSITD	VXSITD Express Delivery Company	XSITD