Freight Booking Execution
Application component: Analytics
App type: Analytical
Line of business: Supply Chain
Freight Booking Execution
Key features:  This overview page is based on two CDS views (data sources), each generating different cards.  The following features are available with data source 1 (C_FRTBKGEXECUTIONSTSQ_CDS CDS view):  Life Cycle Status AnalysisYou can view the number of execution-relevant freight bookings, grouped by freight booking life cycle status. Execution-relevant freight bookings have the execution status In Execution (03) and have a departure event but no arrival event at the final destination.You can see the number of freight bookings for each life cycle status (Draft (00), New (01), or In Process (02)), sorted in descending order. Execution Block AnalysisYou can review all freight bookings with an execution block, grouped by execution block reason. This helps you to determine the most common causes of execution blocking and take the appropriate action. The list is sorted in descending order.You specify execution block reasons in the TM Freight Booking transaction; if you haven’t done this, the system automatically creates them, based on the blocking category. Planning Block AnalysisYou can review all freight bookings with a planning block, grouped by planning block reason. This helps you to determine the most common causes of planning blocking and take the appropriate action. The list is sorted in descending order.You specify execution block reasons in the TM Freight Booking transaction; if you haven’t done this, the system automatically creates them, based on the blocking category. Delayed Freight Bookings in TransitYou can view freight bookings that are delayed in transit, that is, if their latest, time-relevant event is delayed (both the expected and actual date and time fields are available and the event status is Reported). The delay is the time difference between the actual date and the expected date.You can see the total number of freight bookings and then drill down to view details such asFreight Booking ID, Means of Transport, Gross Weight, and Delay. You specify the units as parameters in the relevant CDS query view.You can also navigate directly to the related freight booking transaction by selecting the first line or header line of the details view.  The following features are available with data source 2 (C_FRTBKGEXECUTIONQUERY_CDS CDS view):  Blocking DiscrepanciesYou can review the discrepant freight booking events that led to a block, sorted by event code and discrepancy type (such as delivery of item, late, or delay). The discrepancy type with the most blocking events is at the top. Non-Blocking DiscrepanciesYou can see the discrepant freight booking events that didn’t result in a block, sorted by event code and discrepancy type (such as arrival at destination, departure, or loading end). The discrepancy type with the most non-blocking events is at the top. Carrier On Time PerformanceYou can view the percentage of freight bookings that each carrier delivered on time. You can also see this expressed in numbers, for example, 6 / 14 were on time. A freight booking is on time if all its events are classed as on time, otherwise it is classed as delayed. This helps you identify the most efficient carriers.The calculation for all the on time performance cards takes into account all time-relevant events where both expected and actual date and time fields are available, and where the event status is Reported.  Location On Time PerformanceThis shows the percentage of on time freight booking events for each location, sorted by the transportation order events on time ratio. The lowest percentage is at the top. You can also see this expressed in numbers, for example, 6 / 8 events were on time. This helps you understand how individual locations are performing. Activity On Time PerformanceYou can review the percentage of on time freight booking events for each event code (such as loading or unloading), with the lowest number at the top. You can also see this expressed in numbers, for example, 12 / 27 events took place on time. You can use this information to identify potential bottlenecks. Unexpected EventsYou can monitor unexpected events that took place within the freight booking, grouped by event code (such as accident or delay), with the highest number at the top. This information may prove vital in taking preventative measures to avoid such events in the future.  
Business roles: Transportation Manager| Transportation Planner| Settlement Clerk - Freight Management
Settlement Clerk - Freight Management : 
Manages the settlement of carrier and supplier invoices and takes care of dispute management. Generates freight settlement documents for freight orders and triggers invoice verification prior to settlement. 

Transportation Planner : 
Manages transportation planning activities.