Stock_Unrestricted_vs_Sales
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - 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. It includes key metrics such as unrestricted stock, sales quantity, delivered quantity, and pending delivery.
Data Sources
| Source Table/View | Description |
|---|---|
| Stock_NonValuated | Contains stock information such as material number, material text, plant, base unit of measure, and storage location. |
| SalesFulfillment_perOrder | Contains sales information such as sales quantity, delivered quantity, pending delivery, and sales unit. |
Key Use Cases
- Monitor stock levels and sales performance for specific materials and plants.
- Analyze sales trends and identify areas for improvement.
- Plan and optimize inventory management strategies.
Query Logic
The view uses a LEFT OUTER JOIN to combine data from the stock and sales tables based on common fields such as client, material number, plant, storage location, and language. It then filters the results based on the specified language parameter.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MMBE | Display Material Stock/Requirements List |
| VL06O | Display Sales Order Stock Overview |
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 |