SalesFulfillment
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesFulfillment
Overview
This reporting view provides a consolidated view of sales order and sales status data for SAP systems. It combines data from the SalesOrders (vbap) and SalesStatus_Items (SO) tables to provide insights into product sales, deliveries, and pending orders.
Data Sources
| Source Table/View | Description |
|---|---|
| SalesOrders (vbap) | Contains sales order header data, including sales organization, sales unit, currency, and order quantities. |
| SalesStatus_Items (SO) | Contains sales status data for individual line items, including invoice quantities, invoice values, delivered quantities, and product hierarchy information. |
Key Use Cases
- Analyze product sales performance by material number, product hierarchy, and sales unit.
- Monitor delivery status and identify pending deliveries for specific products.
- Track invoice quantities and values for billing purposes.
- Provide insights into product demand and inventory management.
Query Logic
The view uses a LEFT OUTER JOIN to combine data from the SalesOrders and SalesStatus_Items tables. It groups the results by client, material number, material text, delivered unit of measure, delivered quantity, delivered pending billing, sales organization, sales unit, and currency. The query calculates the total sales quantity, net price, and pending delivery for each group.
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 |
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 |