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
⤷ 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 | Table Relationship Diagram |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | ||
3 | TRAZT | TRAZT | DIFZT | DEC | 5 | 2 | Outdated: Transit Time from GI to Ship-to Party (in Days) | ||
4 | TRAZTD | TRAZTD | TSTRDURAG | DEC | 11 | 0 | Transit duration in calendar days | ||
5 | TDVZT | TDVZT | DIFZT | DEC | 5 | 2 | Outdated: Transportation-Planning Lead Time (in Days) | ||
6 | TDVZTD | TDVZTD | TSTRDURAG | DEC | 11 | 0 | Transportation lead time in calendar days | ||
7 | TDVZND | TDVZND | TSTRDURAN | DEC | 11 | 0 | Transportation lead time in hours/minutes work time | ||
8 | SPFBK | FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | TFACD | |
9 | EXPVZ | EXPVZ | EXPVZ | CHAR | 1 | 0 | Mode of Transport for Foreign Trade | T618 | |
10 | TDIIX | TDIIX | XFELD | CHAR | 1 | 0 | Relevance for transportation ID | ||
11 | SPZST | TSTRIDSD | TSTRID | CHAR | 10 | 0 | Working time from sales view | TTSTRSD | |
12 | FAHZTD | FAHZTD | TSTRDURAN | DEC | 11 | 0 | Travel duration as actual time (hours/minutes) | ||
13 | DISTZ | DISTZ | MENG13 | QUAN | 13 | 3 | Distance | ||
14 | MEDST | MEDST | MEINS | UNIT | 3 | 0 | Unit of measure for distance | * | |
15 | VSART | VERSART | VERSART | CHAR | 2 | 0 | Shipping type | T173 | |
16 | VSAVL | VERSARTVL | VERSART | CHAR | 2 | 0 | Shipping type of preliminary leg | T173 | |
17 | VSANL | VERSARTNL | VERSART | CHAR | 2 | 0 | Shipping type of subsequent leg | T173 | |
18 | TDLNR | TDLNR | LIFNR | CHAR | 10 | 0 | Number of forwarding agent | LFA1 | |
19 | ROUTID | ROUTID | CHAR100 | CHAR | 100 | 0 | Route identification | ||
20 | TCTAB | ADGE_TCTAB | X | CHAR | 1 | 0 | Take Table for Transit Countries into Account | ||
21 | ALLOWED_TWGT | ALLOWED_TWGT | MENG12_0 | QUAN | 8 | 0 | Allowed total weight of shipment | ||
22 | ALLOWED_UOM | 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 | T618 | EXPVZ | REF | C | CN |
2 | TVRO | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | TVRO | SPFBK | TFACD | IDENT | REF | C | CN |
4 | TVRO | SPZST | TTSTRSD | TSTREAMID | |||
5 | TVRO | TDLNR | LFA1 | LIFNR | REF | C | CN |
6 | TVRO | VSANL | T173 | VSART | REF | C | CN |
7 | TVRO | VSART | T173 | VSART | REF | C | CN |
8 | TVRO | VSAVL | T173 | VSART | REF | C | CN |
History
Last changed by/on | SAP | 20020320 |
SAP Release Created in |