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   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