SAP VTRKH Tracking Data - Header Table
Overview
VTRKH is a standard SAP S/4HANA table that stores Tracking Data - Header data. There are total 30 fields in the VTRKH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTRKH belongs to Interfaces (LE-TRA-IN) module and is located in the package Express Delivery Company Interface & Tracking (VVTR).
In addition, following links provide an overview of foreign key relationships, if any, that link VTRKH to other SAP tables and standard CDS views available based on VTRKH table in S/4HANA 2020.
Techincal Settings of VTRKH
Below are technical details of the table VTRKH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTRKH Fields
The following table gives you an overview of the fields available in VTRKH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| XSITD | Express Delivery Company | XSITD | VXSITD | CHAR | 10 |
| UEVBTYP | Document Category of Higher-level Document | UEVBTYPL | CHAR | 4 | |
| UEVBELN | Higher-level Document | UEVBELN | * | CHAR | 10 |
| TRACKN | Tracking number | TRACKN | CHAR | 35 | |
| SHIPACCT | Sender's Account Number with Express Delivery Company | SHIPACCT | CHAR | 20 | |
| ROUTECODE | Routing information for XSI carrier | ROUTECODE | CHAR | 12 | |
| XSITOUR | Express Delivery Company's Route Number | XSITOUR | CHAR | 10 | |
| XSIHUBE | Forwarder's Load Transfer Point for Arriving Goods | XSIHUBE | CHAR | 6 | |
| XSIHUBZ | Express Delivery Company's Central Hub | XSIHUBZ | CHAR | 6 | |
| XSIHUBA | Forwarder's Outbound Delivery Load Transfer Point | XSIHUBA | CHAR | 6 | |
| ROUTELDAT | Last update of routing info data | ROUTELDAT | DATS | 8 | |
| XSISRVC | Express Delivery Company's Service Code | XSISRVC | VXSITS | CHAR | 10 |
| PRDCD | Express Delivery Company Product Code | PRDCD | VXSIP | CHAR | 10 |
| VLBLFLAG | VLBL Data Exists (Performance Flag) | VLBLFLAG | CHAR | 1 | |
| XSIDATERR | Error in Express Delivery Company Data Field | XSIDATERR | CHAR | 1 | |
| TRKSTATO | Previous tracking status | TRKSTATO | CHAR | 1 | |
| TRKSTAT | Tracking Status | TRKSTAT | CHAR | 1 | |
| TRKEVENT | Tracking event still has to be processed | TRKEVENT | CHAR | 1 | |
| TRKSTATD | Tracking status details | TRKSTATD | VXTRKS | CHAR | 4 |
| TRACKTSTMP | Tracking time in UTC format | TRACKTSTMP | DEC | 15 | |
| TRKDLVTO | Name of the person that accepted parcel | TRKDLVTO | CHAR | 40 | |
| TRKDLVLOC | Location at which parcel/delivery is accepted | TRKDLVLOC | CHAR | 50 | |
| SIGNATURL | URL with signature screen | SIGNATURL | CHAR | 255 | |
| REQTSTMP | Time of last request for tracking data | REQTSTMP | DEC | 15 | |
| TRACKTZNZONE | Time Zone | TZNZONE | * | CHAR | 6 |
| TRACKNCOUN | Tracking number | TRACKN | CHAR | 35 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTRKH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTRKH | PRDCD | : | VXSIP |
| VTRKH | TRKSTATD | : | VXTRKS |
| VTRKH | XSISRVC | : | VXSITS |
| VTRKH | XSITD | : | VXSITD |