Goods Transportation Reports in BW/BI

Report Name Description Comments
Lane Deficiency Report Report points out actual transit times per lane and compares it against transit tables in source system such as R3 where transportation details are stored
Deployment Scorecard Measures lane cost, mode cost, line haul costs, load factor, mode mix, short lead %, – Weekly, monthly &  yearly view. Data from the Freight Cost Detail & Accrual Tables in the source
Freight Scorecard monthly/yearly network resupply orders.  Measures linehaul, fuel, accessories and volume against AOP and then illustrates the cost variance & impact Data from the Freight Cost Detail & Accrual Tables in the source
Delivery Scorecard monthly/yearly network sales orders.  Measures linehaul, fuel, accessories and volume against AOP and then illustrates the cost variance & impact Data from the Freight Cost Detail & Accrual Tables in the source
On Time Delivery Summary Report / Carrier Scorecard Measures on time delivery at a weekly, monthly and yearly level.
Carrier Revenue Report Fiscal Month/Fiscal Year view of spend by carrier.  Measures spend on line haul, fuel, accessories.
TRACK Cost Per Mile Report Report Measures TRACK Cost Per Mile

Courtesy: Project related generic documents

What are OEE reports in BW/BI?

OEE stands for ‘Overall Equipment Efficiency‘. These reports are required in manufacturing companies to track the machine efficiency and performance in terms of quality and availability.

The efficiency is measured per line (machine) or per material.

OEE calculation has three different metrics: availability, performance and quality.

Generally, OEE is reviewed on a weekly basis as KPI.

Most important, OEE is used to analyze the reason of Continue reading →

HR reports in BW/BI

Below are some of the HR reports used in BW/BI. These will help you to understand what kind of reports companies want out of their HR data-

Report Name – 

Headcount / FTE Report

Report Description-

This report is used to count Continue reading →

What is Material Master Data report in BW/BI?

The companies mainly in the manufacturing business require to see the material master data of their inventory stock after the sales and delivery is done for a period.

These reports mainly show the details of a material produced by the company like Continue reading →

What is Planning efficiency report in BW/BI?

The plan efficiency reports are needed plant wise, material wise to measure the efficiency of the planning. These are global reports whilst the information need to be collected at factory level. These reports will help a company to Continue reading →

What is PGI in SAP SD

PGI stands for Post goods issue in SAP SD. Whenever goods are issued to the customer, system does the following:

1. Updates stock in warehouse (MM data)

2. decreases the volume of stock (MM data)

3. Increases the goods sold (Sales data)

4. Updates the G/L account (FI data)

PGI process is basically carried out after picking and packing of the material for delivery.

i.e. PGI process is triggered after the delivery document is generated.

What is ATP qty in SAP SD

When you create an order for a customer, in the sales order overview screen, you can see Confirmed qty and ATP qty.

ATP is “Available to Promise” qty which is derived from the Availability check done by the system in MM stocks.

This is updated when you save the order.

After this check, the confirmed qty is also updated in the order.

The availability check ensures that the ATP qty is never zero.

Steps to reproduce:

Go to order history of the customer, double click on an order and see the confirmed qty and ATP values.

or go to VA03 and display a sales order. Check the values in both type of quantities.

Notes:

Whenever ATP approaches 0, the system displays a pop up as soon as we enter material and qty while creating a sales order. These settings are customization in SPRO.

The stock qty need to be updated in MM02 so that the order can be saved and processed.