SalesFulfillment
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesFulfillment
Overview
This reporting view provides a consolidated view of sales-related data for SAP systems. It combines information from the SalesStatus_Items and SalesOrders tables to provide insights into billed quantities, invoice prices, delivered quantities, and pending deliveries for specific materials.
Data Sources
| Source Table/View | Description |
|---|---|
| SalesStatus_Items | Contains detailed information about sales orders, including invoice quantities, invoice values, delivered quantities, and material-related attributes. |
| SalesOrders | Provides data on sales orders, including cumulative order quantities, net prices, sales units, and sales organizations. |
Key Use Cases
- Analyzing sales performance for specific materials.
- Identifying discrepancies between billed and delivered quantities.
- Monitoring pending deliveries and ensuring timely fulfillment.
- Providing insights for inventory management and production planning.
Query Logic
The query first creates a common table expression (CTE) called SO, which aggregates data from the SalesStatus_Items table based on various criteria, including client, invoice currency, material number, and language. It calculates billed quantities, invoice prices, delivered quantities, and pending deliveries. The main query then joins the SO CTE with the SalesOrders table using common fields to enrich the data with additional attributes such as sales unit, currency, sales organization, and cumulative order quantities. The results are grouped to provide consolidated data for each material and sales combination.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VL01N | Create Delivery |
| VL02N | Change Delivery |
| VF01 | Create Invoice |
| VF02 | Change Invoice |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| 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 | |
| SalesQty | Sales Quantity | |
| NetPrice | Net Price | |
| PendingDelivery | Pending Delivery Quantity |