Stock_NonValuated
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - Stock_NonValuated
Overview
This reporting view provides a comprehensive overview of material stock data from SAP ECC systems. It combines data from the MARD and MARA tables to provide key information about materials, plants, storage locations, and stock levels.
Data Sources
| Source Table/View | Description |
|---|---|
| MARD | Material Stock Table |
| MARA | Material Master Table |
| T001W | Plant Master Table |
Key Use Cases
- Material planning and forecasting
- Inventory management and optimization
- Stock analysis and reporting
- Plant and storage location performance monitoring
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 Ledger |
| MMSC | Material Stock Consistency Check |
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 |