MaterialPlantsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialPlantsMD
Overview
This view is a reporting view for SAP systems that provides detailed information about materials in the system. It includes data from the MARC table, which contains master data for materials.
Data Sources
| Source Table/View | Description |
|---|---|
| MARC | Material Master table |
Key Use Cases
- This view can be used to get an overview of all materials in the system.
- It can also be used to get detailed information about a specific material.
- This view can be used to create reports on materials.
- This view can be used to analyze material data.
Query Logic
The view is created using a simple SELECT statement that retrieves all columns from the MARC table.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Material Master |
| MM02 | Change Material Master |
| MM03 | Display Material Master |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| MaterialNumber_MATNR | Material Number | |
| Plant_WERKS | Plant | |
| MaintainanceStatus_PSTAT | Maintenance Status | |
| FlagMaterialForDeletionAtPlantLevel_LVORM | Flag Material For Deletion At Plant Level | |
| ValuationCategory_BWTTY | Valuation Category | |
| BatchManagementIndicator_XCHAR | Batch Management Indicator | |
| PlantSpecificMaterialStatus_MMSTA | Plant Specific Material Status | |
| DateFromWhichThePlantsSpecificMaterialStatusIsValid_MMSTD | Date From Which The Plant's Specific Material Status Is Valid | |
| SafetyStock_EISBE | Safety Stock |