SAP Table TROLZ
Routes: Determination in Deliveries
TROLZ (Routes: Determination in Deliveries) 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 TROLZ to other SAP tables.
TROLZ 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 | ||
TROLZ foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TROLZ | ALAND | TROLZ | MANDT | T005 | Countries | MANDT |
| TROLZ | ALAND | TROLZ | ALAND | T005 | Countries | LAND1 |
| TROLZ | AZONE | TROLZ | MANDT | TZONE | Customers: Regional zones | MANDT |
| TROLZ | AZONE | TROLZ | ALAND | TZONE | Customers: Regional zones | LAND1 |
| TROLZ | AZONE | TROLZ | AZONE | TZONE | Customers: Regional zones | ZONE1 |
| TROLZ | GRULG | TROLZ | MANDT | TVLG | Routes: Weight Groups for Deliveries | MANDT |
| TROLZ | GRULG | TROLZ | GRULG | TVLG | Routes: Weight Groups for Deliveries | GRULG |
| TROLZ | LLAND | TROLZ | MANDT | T005 | Countries | MANDT |
| TROLZ | LLAND | TROLZ | LLAND | T005 | Countries | LAND1 |
| TROLZ | LZONE | TROLZ | MANDT | TZONE | Customers: Regional zones | MANDT |
| TROLZ | LZONE | TROLZ | LLAND | TZONE | Customers: Regional zones | LAND1 |
| TROLZ | LZONE | TROLZ | LZONE | TZONE | Customers: Regional zones | ZONE1 |
| TROLZ | MANDT | TROLZ | MANDT | T000 | Clients | MANDT |
| TROLZ | ROUTE | TROLZ | MANDT | TVRO | Routes | MANDT |
| TROLZ | ROUTE | TROLZ | ROUTE | TVRO | Routes | ROUTE |
| TROLZ | TRAGR | TROLZ | TRAGR | TTGR | Delivery Scheduling: Transportation Groups | TRAGR |
| TROLZ | TRAGR | TROLZ | MANDT | TTGR | Delivery Scheduling: Transportation Groups | MANDT |
| TROLZ | VSBED | TROLZ | MANDT | TVSB | Shipping Conditions | MANDT |
| TROLZ | VSBED | TROLZ | VSBED | TVSB | Shipping Conditions | VSBED |
