Aero - Sales and Distribution Reporting (google.com)
The Ship pad (AERO) was originally developed exclusively for Composite Material GBUs in the aero specific businesses (business line). It serves as an operational report at the plant level, allowing a daily check of items to be shipped from the plant. The report provides insights into priorities, order statuses, and a sequential overview of orders, enabling a thorough assessment for potential risks. This report is specifically designed based on the order book, offering a perspective on orders to-be-issued.
Describe the key User profiles that exist for the application.
General role/Viewer role:
Approver role:
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 12.12.2023 | Azadeh Nasiri | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
The report support the process of shipping the products from the plants.
3.0 Application Feature Overview
Ship pad (aero) report in the global sales folder of BW is providing the visibility on pending orders and all their corresponding information from different domains (Order Management, Production Planning, Quality Management, Logistics Execution).
The scope of the report: Open Sales Orders and Purchase Orders (Stock transfer) information.
Excluded from the report: Rejected order lines, order lines with remaining quantity to be delivered below tolerance, and all schedule lines without "Actual GI date" from Delivery (shipped).
| Report | Technical name |
|---|---|
| Open Orders report - External | BW_WBK_CPSDAE03_0002 |
| Open Orders report - Internal | BW_WBK_CPSDAE03_0003 |
| Order Book: To be Invoiced + Aero Program & Market | BW_WBK_CPSDA041_SD011 |
| Ship Pad report | BW_WBK_CPSDAE03_0001 |
4.0 Functional Specification
4.1 General Data/Calculations
The report is on top of SAP data with calculations on top. Data in BW will be refreshed daily containing information from D-1 (CET time)
Key figures:
Key figure | Comments |
USD_Amount | Line item value |
Qty Ordered | Order quantity |
Qty Allocated | Delivery quantity based on batch allocation |
Qty Remaining | Qty Ordered - Qty Confirmed |
Pct Allocated | (Qty Ordered - Qty Allocated) / Qty Ordered |
Note: In addition to displaying original document Currency and Unit of Measure, you can select a target Currency and Unit of Measure in before execution (conversion)
4.2 Process Detail
4.2.1. Report/Process Definition
Open order reports
It includes three reports: Open Orders report - External, Open Orders report - Internal, and Ship Pad report. The last one contains exact similar information by combing the first two but different layout.
Scope of the report: Open Sales Orders information (PO excluded);
Excluded from the report: Rejected order lines, order lines with remaining quantity to be delivered below tolerance, and all schedule lines without "Actual GI date" from Delivery (shipped).
Order Book: To be Invoiced + Aero Program & Market
This report is an enhanced version of the standard “Order Book - To be Invoiced” query. Where the concepts of Aero Program (ex: Boeing 777, 767, etc) and Aero Market (ex: Military, Civilian) are added. This “assignment” is quite dynamic and it is also split by %. Meaning that a sale of a specific material can be 60% for one Aero Program and 40% for another. The report does those calculations in the order book according to these assignments