1. Home
  2. Resources
  3. SAP Tables
  4. VTRKH - Tracking Data - Header

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
MANDT Client MANDT CLNT 3 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
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
XSITD Express Delivery Company XSITD VXSITD CHAR 10 0
UEVBTYP Document Category of Higher-level Document UEVBTYP 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
UEVBELN Higher-level Document UEVBELN CHAR 10 0
TRACKN Tracking number TRACKN CHAR 35 0
SHIPACCT Sender's Account Number with Express Delivery Company SHIPACCT CHAR 20 0
ROUTECODE Routing information for XSI carrier ROUTECODE CHAR 12 0
XSITOUR Express Delivery Company's Route Number XSITOUR CHAR 10 0
XSIHUBE Forwarder's Load Transfer Point for Arriving Goods XSIHUBE CHAR 6 0
XSIHUBZ Express Delivery Company's Central Hub XSIHUBZ CHAR 6 0
XSIHUBA Forwarder's Outbound Delivery Load Transfer Point XSIHUBA CHAR 6 0
ROUTELDAT Last update of routing info data ROUTELDAT DATS 8 0
XSISRVC Express Delivery Company's Service Code XSISRVC VXSITS CHAR 10 0
PRDCD Express Delivery Company Product Code PRDCD VXSIP CHAR 10 0
VLBLFLAG VLBL Data Exists (Performance Flag) VLBLFLAG CHAR 1 0
X Yes
NULL No
XSIDATERR Error in Express Delivery Company Data Field XSIDATERR CHAR 1 0
X Yes
NULL No
TRKSTATO Previous tracking status TRKSTATO CHAR 1 0
NULL No tracking data
A Picked up
B Partially picked up
C Delivered
D Exception
TRKSTAT Tracking Status TRKSTAT CHAR 1 0
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 1 0
X Yes
NULL No
TRKSTATD Tracking status details TRKSTATD VXTRKS CHAR 4 0
TRACKTSTMP Tracking time in UTC format TRACKTSTMP DEC 15 0
TRKDLVTO Name of the person that accepted parcel TRKDLVTO CHAR 40 0
TRKDLVLOC Location at which parcel/delivery is accepted TRKDLVLOC CHAR 50 0
SIGNATURL URL with signature screen SIGNATURL CHAR 255 0
REQTSTMP Time of last request for tracking data REQTSTMP DEC 15 0
TRACKTZNZONE Time Zone TZNZONE CHAR 6 0
TRACKNCOUN Tracking number TRACKN CHAR 35 0

VTRKH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTRKH PRDCD VTRKH PRDCD VXSIP Express Delivery Company: Product Codes PRDCD
VTRKH PRDCD VTRKH MANDT VXSIP Express Delivery Company: Product Codes MANDT
VTRKH PRDCD VTRKH XSITD VXSIP Express Delivery Company: Product Codes XSITD
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 XSISRVC VXSITS Express Delivery Company: Service Codes XSISRVC
VTRKH XSISRVC VTRKH MANDT VXSITS Express Delivery Company: Service Codes MANDT
VTRKH XSISRVC VTRKH XSITD VXSITS Express Delivery Company: Service Codes XSITD
VTRKH XSITD VTRKH MANDT VXSITD Express Delivery Company MANDT
VTRKH XSITD VTRKH XSITD VXSITD Express Delivery Company XSITD