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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 | TVRO | MANDT |
T618
Foreign Trade: Modes of Transport
|
MANDT |
| TVRO | EXPVZ | * |
T618
Foreign Trade: Modes of Transport
|
LAND1 | |
| TVRO | EXPVZ | TVRO | EXPVZ |
T618
Foreign Trade: Modes of Transport
|
EXPVZ |
| 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 | 'TS' |
TTSTRSD
Working Times in SD/WS
|
TSTRTYPE | |
| TVRO | SPZST | TVRO | SPZST |
TTSTRSD
Working Times in SD/WS
|
TSTREAMID |
| TVRO | SPZST | TVRO | SPFBK |
TTSTRSD
Working Times in SD/WS
|
CALENDARID |
| TVRO | SPZST | TVRO | MANDT |
TTSTRSD
Working Times in SD/WS
|
MANDT |
| TVRO | TDLNR | TVRO | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| TVRO | TDLNR | TVRO | TDLNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| TVRO | VSANL | TVRO | VSANL |
T173
Routes: Mode of Transport for Each Shipping Type
|
VSART |
| TVRO | VSANL | TVRO | MANDT |
T173
Routes: Mode of Transport for Each Shipping Type
|
MANDT |
| 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 |