SAP table TROLZ (Routes: Determination in Deliveries)

SAP table TROLZ has 8 primary key fields being MANDT,ALAND,AZONE,VSBED,TRAGR,LLAND,LZONE,GRULG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
AZONE Departure Zone CHAR 10 0 TZONE AZONE
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
TRAGR Transportation Group CHAR 4 0 TTGR TRAGR
LLAND Destination Country/Region CHAR 3 0 T005 LLAND
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
GRULG Weight Group for Delivery CHAR 4 0 TVLG GRULG
ROUTE Actual Delivery Route CHAR 6 0 TVRO ROUTE_VL

TROLZ foreign key relationships

Table Field Check Table Check Field
0 TROLZ ALAND T005 Countries MANDT
0 TROLZ ALAND T005 Countries LAND1
1 TROLZ AZONE TZONE Customers: Regional zones MANDT
1 TROLZ AZONE TZONE Customers: Regional zones LAND1
1 TROLZ AZONE TZONE Customers: Regional zones ZONE1
0 TROLZ GRULG TVLG Routes: Weight Groups for Deliveries GRULG
1 TROLZ LLAND T005 Countries MANDT
1 TROLZ LLAND T005 Countries LAND1
0 TROLZ LZONE TZONE Customers: Regional zones MANDT
0 TROLZ LZONE TZONE Customers: Regional zones LAND1
0 TROLZ LZONE TZONE Customers: Regional zones ZONE1
1 TROLZ ROUTE TVRO Routes MANDT
1 TROLZ ROUTE TVRO Routes ROUTE
0 TROLZ TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
1 TROLZ VSBED TVSB Shipping Conditions MANDT
1 TROLZ VSBED TVSB Shipping Conditions VSBED