SAP Table TVRO
Routes
TVRO (Routes) 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 TVRO to other SAP tables.
TVRO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| ROUTE | Route | ROUTE | CHAR | 6 | 0 | |||||||
| TRAZT | Outdated: Transit Time from GI to Ship-to Party (in Days) | TRAZT | DEC | 5 | 2 | |||||||
| TRAZTD | Transit duration in calendar days | TRAZTD | DEC | 11 | 0 | |||||||
| TDVZT | Outdated: Transportation-Planning Lead Time (in Days) | TDVZT | DEC | 5 | 2 | |||||||
| TDVZTD | Transportation lead time in calendar days | TDVZTD | DEC | 11 | 0 | |||||||
| TDVZND | Transportation lead time in hours/minutes work time | TDVZND | DEC | 11 | 0 | |||||||
| SPFBK | Factory calendar key | FABKL | TFACD | CHAR | 2 | 0 | ||||||
| EXPVZ | Mode of Transport for Foreign Trade | EXPVZ | T618 | CHAR | 1 | 0 | ||||||
| TDIIX | Relevance for transportation ID | TDIIX | CHAR | 1 | 0 |
Possible values
|
||||||
| SPZST | Working time from sales view | TSTRIDSD | TTSTRSD | CHAR | 10 | 0 | ||||||
| FAHZTD | Travel duration as actual time (hours/minutes) | FAHZTD | DEC | 11 | 0 | |||||||
| DISTZ | Distance | DISTZ | QUAN | 13 | 3 | |||||||
| MEDST | Unit of measure for distance | MEDST | UNIT | 3 | 0 | |||||||
| VSART | Shipping type | VERSART | T173 | CHAR | 2 | 0 | ||||||
| VSAVL | Shipping type of preliminary leg | VERSARTVL | T173 | CHAR | 2 | 0 | ||||||
| VSANL | Shipping type of subsequent leg | VERSARTNL | T173 | CHAR | 2 | 0 | ||||||
| TDLNR | Number of forwarding agent | TDLNR | LFA1 | CHAR | 10 | 0 | ||||||
| ROUTID | Route identification | ROUTID | CHAR | 100 | 0 | |||||||
| TCTAB | Take Table for Transit Countries into Account | ADGE_TCTAB | CHAR | 1 | 0 |
Possible values
|
||||||
| ALLOWED_TWGT | Allowed total weight of shipment | ALLOWED_TWGT | QUAN | 8 | 0 | |||||||
| ALLOWED_UOM | Unit of Measurement for Allowed Total Weight of Shipment | ALLOWED_UOM | UNIT | 3 | 0 | |||||||
| OIG_GESZTD | Total time for stage | OIG_GESZTD | QUAN | 13 | 2 | |||||||
| OIG_FAHZTD | Total travel time for stage | OIG_FAHZTD | QUAN | 13 | 2 | |||||||
| OIG_MEIZT | Unit of measure for travelling times | MEIZT | T006 | UNIT | 3 | 0 | ||||||
TVRO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TVRO | EXPVZ | * | T618 | Foreign Trade: Modes of Transport | LAND1 | |
| TVRO | EXPVZ | TVRO | EXPVZ | T618 | Foreign Trade: Modes of Transport | EXPVZ |
| TVRO | EXPVZ | TVRO | MANDT | T618 | Foreign Trade: Modes of Transport | MANDT |
| TVRO | MANDT | TVRO | MANDT | T000 | Clients | MANDT |
| TVRO | OIG_MEIZT | SY | MANDT | T006 | Units of Measurement | MANDT |
| TVRO | OIG_MEIZT | TVRO | OIG_MEIZT | T006 | Units of Measurement | MSEHI |
| TVRO | SPFBK | TVRO | SPFBK | TFACD | Factory calendar definition | IDENT |
| TVRO | SPZST | TVRO | SPFBK | TTSTRSD | Working Times in SD/WS | CALENDARID |
| TVRO | SPZST | TVRO | MANDT | TTSTRSD | Working Times in SD/WS | MANDT |
| TVRO | SPZST | 'TS' | TTSTRSD | Working Times in SD/WS | TSTRTYPE | |
| TVRO | SPZST | TVRO | SPZST | TTSTRSD | Working Times in SD/WS | TSTREAMID |
| TVRO | TDLNR | TVRO | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| TVRO | TDLNR | TVRO | TDLNR | LFA1 | Vendor Master (General Section) | LIFNR |
| TVRO | VSANL | TVRO | MANDT | T173 | Routes: Mode of Transport for Each Shipping Type | MANDT |
| TVRO | VSANL | TVRO | VSANL | T173 | Routes: Mode of Transport for Each Shipping Type | VSART |
| TVRO | VSART | TVRO | MANDT | T173 | Routes: Mode of Transport for Each Shipping Type | MANDT |
| TVRO | VSART | TVRO | VSART | T173 | Routes: Mode of Transport for Each Shipping Type | VSART |
| TVRO | VSAVL | TVRO | MANDT | T173 | Routes: Mode of Transport for Each Shipping Type | MANDT |
| TVRO | VSAVL | TVRO | VSAVL | T173 | Routes: Mode of Transport for Each Shipping Type | VSART |
