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)
- Partial Deliveries “Qty Ordered” <> “To Be Issued QTY”
- Multiple deliveries
- Qty Allocated: based on the existence of a batch in the delivery (batch also available)
Available Fields:
Column | Comments |
Number Lots | Number of batches per production order |
Batch (delivery) | Allows to see if there is a batch allocation in the delivery |
Delivery Status | Linked to Outbound Delivery: Not started: no delivery created Planned: delivery created without Actual GI date Partially Issued: not fully delivered, but at least one delivery with Act GI date Issued: Fully delivered Not relevant: for items not relevant (ex: credit/debit memo) |
Spec ID/Short Name/Long name | From Sales Order item level (Additional Data B) |
DPAS | From Sales Order item level (Additional Data B) |
WorkCenter | Code and text |
| Process Status/Change Status | Aero specific - Sales Order item level (Additional Data B) |
WO | Process Order number from Production |
Ship Method | Transportation mode (derived from Shipping condition) |
Forwarding Agent | If shipment, Fwd agent from Shipment If not, SP partner from Sales Order item (Partners tab) |
Comments | Order line "Texts" tab, "Item note" (usually within 25 char) |
DelPerfNote | 2 fields: 1) Non-OTIF reason (drop-down from Additional Data B) 2) Non-OTIF comment (free text from Additional Data B) |
Cust Req Date | Last Requested Delivery date from order line (Field "First Date") |
| Dock Date | Delivery date at line item schedule line (only from confirmed schedule line) |
CustPO | Customer PO (Order line attribute) |
CustPartNo | Customer Material number from order line |
SoldToBP | Sold-to party (key) |
ShipToBP | Ship-to party (key) |
Passed Spec? | Comparing passed specs at batch level with required specs at order line leve |
Passed Spec statuses:
Not assigned: order line has no Spec ID
No batch allocated: no batch allocated in delivery
Not all specs passed: one/multiple specs from order line not passed
All specs passed: all required specs were passed
- WO fields: multiple WO -> order qty and amount repeated
- Specs: Short name concatenated by default, also available by Spec ID
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.
Key data for Program/Market selection is Period calendar month / Distribution Channel / Material / Ship-to / Main spec (Aero specification ID)