Stock_Unrestricted_vs_Sales
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - Stock_Unrestricted_vs_Sales
Overview
This reporting view combines data from the Stock_NonValuated and SalesFulfillment_perOrder tables to provide a comprehensive view of stock and sales information for SAP systems.
Data Sources
| Source Table/View | Description |
|---|---|
| Stock_NonValuated | Contains stock data, including unrestricted stock levels. |
| SalesFulfillment_perOrder | Contains sales data, including sales quantities, delivered quantities, and pending deliveries. |
Key Use Cases
- Analyzing stock levels and sales performance for specific materials and plants.
- Identifying materials with high or low stock levels.
- Monitoring sales trends and forecasting future demand.
Query Logic
The view uses a LEFT OUTER JOIN to combine data from the stock and sales tables. The join condition ensures that only rows with matching client, material number, plant, storage location, and language are included in the result set. The WHERE clause filters the results to include only rows with the specified language.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MMBE | Display Material Stock/Requirements List |
| VKM3 | Sales Order: Display |
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 | |
| Plant_WERKS | Plant | |
| Plant_Name | Plant Name | |
| BaseUnitOfMeasure_MEINS | Base Unit of Measure | |
| ProductHierarchy_PRDHA | Product Hierarchy | |
| Plant_Region | Plant Region | |
| Plant_Country | Plant Country | |
| StorageLocation_LGORT | Storage Location | |
| Language_SPRAS | Language | |
| UnrestrictedStock | Unrestricted Stock | |
| SalesQty | Sales Quantity | |
| DeliveredQty | Delivered Quantity | |
| DeliveredUoM_MEINS | Delivered Unit of Measure | |
| PendingDelivery | Pending Delivery |