SAP ABAP Table TVRO (Routes)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
VTRC (Package) SD R/3 customizing transport processing
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | TVRO |
|
| Short Description | Routes |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
| 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
ROUTE | ROUTE | CHAR | 6 | 0 | Route | ||
| 3 | |
TRAZT | DIFZT | DEC | 5 | 2 | Outdated: Transit Time from GI to Ship-to Party (in Days) | ||
| 4 | |
TRAZTD | TSTRDURAG | DEC | 11 | 0 | Transit duration in calendar days | ||
| 5 | |
TDVZT | DIFZT | DEC | 5 | 2 | Outdated: Transportation-Planning Lead Time (in Days) | ||
| 6 | |
TDVZTD | TSTRDURAG | DEC | 11 | 0 | Transportation lead time in calendar days | ||
| 7 | |
TDVZND | TSTRDURAN | DEC | 11 | 0 | Transportation lead time in hours/minutes work time | ||
| 8 | |
FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | TFACD | |
| 9 | |
EXPVZ | EXPVZ | CHAR | 1 | 0 | Mode of Transport for Foreign Trade | T618 | |
| 10 | |
TDIIX | XFELD | CHAR | 1 | 0 | Relevance for transportation ID | ||
| 11 | |
TSTRIDSD | TSTRID | CHAR | 10 | 0 | Working time from sales view | TTSTRSD | |
| 12 | |
FAHZTD | TSTRDURAN | DEC | 11 | 0 | Travel duration as actual time (hours/minutes) | ||
| 13 | |
DISTZ | MENG13 | QUAN | 13 | 3 | Distance | ||
| 14 | |
MEDST | MEINS | UNIT | 3 | 0 | Unit of measure for distance | * | |
| 15 | |
VERSART | VERSART | CHAR | 2 | 0 | Shipping type | T173 | |
| 16 | |
VERSARTVL | VERSART | CHAR | 2 | 0 | Shipping type of preliminary leg | T173 | |
| 17 | |
VERSARTNL | VERSART | CHAR | 2 | 0 | Shipping type of subsequent leg | T173 | |
| 18 | |
TDLNR | LIFNR | CHAR | 10 | 0 | Number of forwarding agent | LFA1 | |
| 19 | |
ROUTID | CHAR100 | CHAR | 100 | 0 | Route identification | ||
| 20 | |
ADGE_TCTAB | X | CHAR | 1 | 0 | Take Table for Transit Countries into Account | ||
| 21 | |
ALLOWED_TWGT | MENG12_0 | QUAN | 8 | 0 | Allowed total weight of shipment | ||
| 22 | |
ALLOWED_UOM | MEINS | UNIT | 3 | 0 | Unit of Measurement for Allowed Total Weight of Shipment | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | TVRO | EXPVZ | |
|
REF | C | CN |
| 2 | TVRO | MANDT | |
|
KEY | 1 | CN |
| 3 | TVRO | SPFBK | |
|
REF | C | CN |
| 4 | TVRO | SPZST | |
|
|||
| 5 | TVRO | TDLNR | |
|
REF | C | CN |
| 6 | TVRO | VSANL | |
|
REF | C | CN |
| 7 | TVRO | VSART | |
|
REF | C | CN |
| 8 | TVRO | VSAVL | |
|
REF | C | CN |
History
| Last changed by/on | SAP | 20020320 |
| SAP Release Created in |