SAP ABAP Table VTRKH (Tracking Data - Header)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LE-TRA-IN (Application Component) Interfaces
     ⤷ VVTR (Package) Express Delivery Company Interface & Tracking

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTRKH	Table Relationship Diagram
Short Description	Tracking Data - Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	VBTYP	☑	VBTYP	VBTYP	CHAR	1	0	SD document category
3	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	XSITD	☑	XSITD	XSITD	CHAR	10	0	Express Delivery Company	VXSITD
5	UEVBTYP	☐	UEVBTYP	VBTYP	CHAR	1	0	Document Category of Higher-level Document
6	UEVBELN	☐	UEVBELN	VBELN	CHAR	10	0	Higher-level Document	*
7	TRACKN	☐	TRACKN	TRACKN	CHAR	35	0	Tracking number
8	SHIPACCT	☐	SHIPACCT	SHIPACCT	CHAR	20	0	Sender's Account Number with Express Delivery Company
9	.INCLUDE	☐				0	0	Routing Information
10	ROUTECODE	☐	ROUTECODE	ROUTECODE	CHAR	12	0	Routing information for XSI carrier
11	XSITOUR	☐	XSITOUR	XSITOUR	CHAR	10	0	Express Delivery Company's Route Number
12	XSIHUBE	☐	XSIHUBE	XSIHUB	CHAR	6	0	Forwarder's Load Transfer Point for Arriving Goods
13	XSIHUBZ	☐	XSIHUBZ	XSIHUB	CHAR	6	0	Express Delivery Company's Central Hub
14	XSIHUBA	☐	XSIHUBA	XSIHUB	CHAR	6	0	Forwarder's Outbound Delivery Load Transfer Point
15	ROUTELDAT	☐	ROUTELDAT	DATUM	DATS	8	0	Last update of routing info data
16	XSISRVC	☐	XSISRVC	XSISRVC	CHAR	10	0	Express Delivery Company's Service Code	VXSITS
17	PRDCD	☐	PRDCD	PRDCD	CHAR	10	0	Express Delivery Company Product Code	VXSIP
18	VLBLFLAG	☐	VLBLFLAG	XFELD	CHAR	1	0	VLBL Data Exists (Performance Flag)
19	XSIDATERR	☐	XSIDATERR	XFELD	CHAR	1	0	Error in Express Delivery Company Data Field
20	TRKSTATO	☐	TRKSTATO	TRKSTAT	CHAR	1	0	Previous tracking status
21	TRKSTAT	☐	TRKSTAT	TRKSTAT	CHAR	1	0	Tracking Status
22	TRKEVENT	☐	TRKEVENT	XFELD	CHAR	1	0	Tracking event still has to be processed
23	TRKSTATD	☐	TRKSTATD	TRKSTATD	CHAR	4	0	Tracking status details	VXTRKS
24	TRACKTSTMP	☐	TRACKTSTMP	TZNTSTMPS	DEC	15	0	Tracking time in UTC format
25	TRKDLVTO	☐	TRKDLVTO	TEXT40	CHAR	40	0	Name of the person that accepted parcel
26	TRKDLVLOC	☐	TRKDLVLOC	TEXT50	CHAR	50	0	Location at which parcel/delivery is accepted
27	SIGNATURL	☐	SIGNATURL	XSIURL	CHAR	255	0	URL with signature screen
28	REQTSTMP	☐	REQTSTMP	TZNTSTMPS	DEC	15	0	Time of last request for tracking data
29	TRACKTZNZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
30	TRACKNCOUN	☐	TRACKN	TRACKN	CHAR	35	0	Tracking number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTRKH	PRDCD	VXSIP	PRDCD
2	VTRKH	TRKSTATD	VXTRKS	TRKSTATD
3	VTRKH	XSISRVC	VXSITS	XSISRVC
4	VTRKH	XSITD	VXSITD	XSITD

History

Last changed by/on	SAP	20130529
SAP Release Created in