Freight Cost Analysis by Forwarding Agent 
Query: 0LES_MP03_Q0001
This query enables you to analyze freight costs. For each forwarding agent and month, you see data for the weight and costs of the freight as well as the number of shipments.
You can navigate to either the transportation planning point, route, or mode of transport.
The query takes this data from the MultiProvider Freight Cost Analysis (0LES_MP03).
Structure
Object Type | Name | Technical Name |
|---|---|---|
| Transportation Planning Point |
0TRAPPOINT |
| Route |
0ROUTE |
| Mode of Transport |
0TRALEVEL |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar Year/Month |
0CALMONTH |
|
| Forwarding Agent |
0FORWAGENT |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Net Value - Freight |
0FCNETVALUE |
|
| Number of Shipments |
0NUMSHPMENT |
|
| Sum of Gross Weights |
0SUM_GRS_WT |
|
| Total Net Weight |
0SUM_NET_WT |