Stock_NonValuated
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - Stock_NonValuated
Overview
This view provides a comprehensive overview of material stock data from SAP systems. It combines data from the MARD and MARA tables to provide key information about materials, including stock levels, plant data, and material attributes.
Data Sources
| Source Table/View | Description |
|---|---|
| MARD | Material Stock Table |
| MARA | Material Master Table |
| T001W | Plant Master Table |
Key Use Cases
- Material stock analysis and reporting
- Inventory management and planning
- Material master data maintenance
Query Logic
The view joins the MARD, MARA, and T001W tables on the Client_MANDT, MaterialNumber_MATNR, and Plant_WERKS fields. It filters the results based on the specified language (Language_SPRAS) and groups the results by the following fields: Client_MANDT, MaterialNumber_MATNR, MaterialText_MAKTX, Plant_WERKS, Plant_Name, StorageLocation_LGORT, BaseUnitOfMeasure_MEINS, Language_SPRAS, MaterialType_MTART, MaterialGroup_MATKL, ProductHierarchy_PRDHA, Plant_Region, Plant_Country.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Material Master |
| MM02 | Change Material Master |
| MM03 | Display Material Master |
| MB51 | Material Stock Overview |
| MB52 | Material Stock List |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| MaterialNumber_MATNR | Material Number | |
| MaterialText_MAKTX | Material Text | |
| Plant_WERKS | Plant | |
| Plant_Name | Plant Name | |
| StorageLocation_LGORT | Storage Location | |
| BaseUnitOfMeasure_MEINS | Base Unit of Measure | |
| Language_SPRAS | Language | |
| MaterialType_MTART | Material Type | |
| MaterialGroup_MATKL | Material Group | |
| ProductHierarchy_PRDHA | Product Hierarchy | |
| Plant_Region | Plant Region | |
| Plant_Country | Plant Country | |
| ValuatedUnrestrictedUseStock | Valuated Unrestricted Use Stock |