SAP Table V_TROLZ01
Generated Table for View
V_TROLZ01 (Generated Table for View) 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 V_TROLZ01 to other SAP tables.
V_TROLZ01 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| ALAND | Departure country (country from which the goods are sent) | ALAND | T005 | CHAR | 3 | 0 | ||
| AZONE | Departure zone | AZONE | TZONE | CHAR | 10 | 0 | ||
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 | 0 | ||
| TRAGR | Transportation Group | TRAGR | TTGR | CHAR | 4 | 0 | ||
| LLAND | Country of Destination | LLAND | T005 | CHAR | 3 | 0 | ||
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||
| GRULG | Weight group for delivery (To group) | GRULG | TVLG | CHAR | 4 | 0 | ||
| ROUTE | Actual delivery route | ROUTE_VL | TVRO | CHAR | 6 | 0 | ||
| TGRTXT | Description | BEZEI20 | CHAR | 20 | 0 | |||
| ROUTXT | Description of Route | ROUTBEZ | CHAR | 40 | 0 | |||
| VSBTXT | Description of the shipping conditions | VSBED_BEZ | CHAR | 20 | 0 | |||
V_TROLZ01 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_TROLZ01 | ALAND | V_TROLZ01 | MANDT | T005 | Countries | MANDT |
| V_TROLZ01 | ALAND | V_TROLZ01 | ALAND | T005 | Countries | LAND1 |
| V_TROLZ01 | AZONE | V_TROLZ01 | ALAND | TZONE | Customers: Regional zones | LAND1 |
| V_TROLZ01 | AZONE | V_TROLZ01 | AZONE | TZONE | Customers: Regional zones | ZONE1 |
| V_TROLZ01 | AZONE | V_TROLZ01 | MANDT | TZONE | Customers: Regional zones | MANDT |
| V_TROLZ01 | GRULG | V_TROLZ01 | GRULG | TVLG | Routes: Weight Groups for Deliveries | GRULG |
| V_TROLZ01 | GRULG | V_TROLZ01 | MANDT | TVLG | Routes: Weight Groups for Deliveries | MANDT |
| V_TROLZ01 | LLAND | V_TROLZ01 | MANDT | T005 | Countries | MANDT |
| V_TROLZ01 | LLAND | V_TROLZ01 | LLAND | T005 | Countries | LAND1 |
| V_TROLZ01 | LZONE | V_TROLZ01 | MANDT | TZONE | Customers: Regional zones | MANDT |
| V_TROLZ01 | LZONE | V_TROLZ01 | LLAND | TZONE | Customers: Regional zones | LAND1 |
| V_TROLZ01 | LZONE | V_TROLZ01 | LZONE | TZONE | Customers: Regional zones | ZONE1 |
| V_TROLZ01 | MANDT | V_TROLZ01 | MANDT | T000 | Clients | MANDT |
| V_TROLZ01 | ROUTE | V_TROLZ01 | MANDT | TVRO | Routes | MANDT |
| V_TROLZ01 | ROUTE | V_TROLZ01 | ROUTE | TVRO | Routes | ROUTE |
| V_TROLZ01 | TRAGR | V_TROLZ01 | MANDT | TTGR | Delivery Scheduling: Transportation Groups | MANDT |
| V_TROLZ01 | TRAGR | V_TROLZ01 | TRAGR | TTGR | Delivery Scheduling: Transportation Groups | TRAGR |
| V_TROLZ01 | VSBED | V_TROLZ01 | MANDT | TVSB | Shipping Conditions | MANDT |
| V_TROLZ01 | VSBED | V_TROLZ01 | VSBED | TVSB | Shipping Conditions | VSBED |
