SAP table VTRKH (Tracking Data - Header)

SAP table VTRKH has 4 primary key fields being MANDT,VBTYP,VBELN,XSITD.

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

VTRKH foreign key relationships

Table Field Check Table Check Field
0 VTRKH PRDCD VXSIP Express Delivery Company: Product Codes PRDCD
1 VTRKH TRKSTATD VXTRKS Tracking Status Details MANDT
1 VTRKH TRKSTATD VXTRKS Tracking Status Details XSITD
0 VTRKH XSISRVC VXSITS Express Delivery Company: Service Codes XSISRVC
1 VTRKH XSITD VXSITD Express Delivery Company XSITD