SalesFulfillment_perOrder
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesFulfillment_perOrder
Overview
This reporting view provides a consolidated view of sales order items with key information such as billed quantity, invoice price, delivered quantity, and pending delivery details. It combines data from the SalesStatus_Items and SalesOrders tables to offer a comprehensive perspective on sales performance.
Data Sources
| Source Table/View | Description |
|---|---|
| SalesStatus_Items | Contains detailed information about sales order items, including billing and delivery quantities, unit of measures, and material descriptions. |
| SalesOrders | Provides additional attributes related to sales orders, such as sales organization, plant, storage location, and cumulative order quantities. |
Key Use Cases
- Analyzing sales performance by comparing billed and delivered quantities.
- Identifying pending deliveries and potential delays in order fulfillment.
- Monitoring inventory levels and optimizing stock management based on delivered and pending quantities.
- Providing insights into sales trends and customer demand patterns.
Query Logic
The query first calculates summary metrics for each sales order item in the SalesStatus_Items table, including billed quantity, invoice price, delivered quantity, and pending delivery. It then joins this summarized data with the SalesOrders table using common attributes like client, material number, and invoice currency to enrich the dataset with additional details such as sales unit, sales organization, plant, and storage location.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VL01N | Create Delivery |
| VF01 | Create Invoice |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| SalesOrder_VBELV | Sales Order Number | |
| SalesItem_POSNV | Sales Item Number | |
| MaterialNumber_MATNR | Material Number | |
| MaterialText_MAKTX | Material Text | |
| SalesUnit_VRKME | Sales Unit | |
| Currency_WAERK | Currency | |
| DeliveredQty | Delivered Quantity | |
| DeliveredUoM_MEINS | Delivered Unit of Measure | |
| DeliveredPendingBilling | Delivered Quantity Pending Billing | |
| SalesOrganization_VKORG | Sales Organization | |
| Plant_WERKS | Plant | |
| StorageLocation_LGORT | Storage Location | |
| Language_SPRAS | Language | |
| SalesQty | Sales Quantity | |
| NetPrice | Net Price | |
| PendingDelivery | Pending Delivery Quantity |