SalesFulfillment_perOrder
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesFulfillment_perOrder
Overview
This reporting view provides a consolidated view of sales order items with detailed information on billed quantities, invoice prices, delivered quantities, and pending deliveries. It combines data from the SalesStatus_Items and SalesOrders tables to provide a comprehensive view of sales order status.
Data Sources
| Source Table/View | Description |
|---|---|
| SalesStatus_Items | Contains detailed information on sales order items, including billed quantities, invoice prices, delivered quantities, and material-related attributes. |
| SalesOrders | Provides additional information on sales orders, such as sales quantities, net prices, and organizational data. |
Key Use Cases
- Analyzing sales performance by tracking billed quantities, invoice prices, and delivered quantities.
- Identifying pending deliveries and understanding the gap between delivered and billed quantities.
- Gaining insights into product sales by analyzing material numbers, material texts, and product hierarchies.
- Correlating sales order data with organizational information, such as sales organizations, plants, and storage locations.
Query Logic
The view is constructed using a combination of aggregation and joining techniques. It first aggregates data from the SalesStatus_Items table to calculate billed quantities, invoice prices, delivered quantities, and pending deliveries for each sales order item. Then, it joins this aggregated data with the SalesOrders table to enrich it with additional information, such as sales quantities, net prices, and organizational data.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VA03 | Display Sales Order |
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 |