MaterialPlantsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialPlantsMD
Overview
This view is a reporting view for SAP systems that provides detailed information about materials and their plant-specific settings.
Data Sources
| Source Table/View | Description |
|---|---|
| marc | Material Master table |
Key Use Cases
- Can be used to retrieve material-specific information for a given plant.
- Can be used to identify materials that meet specific criteria, such as those with a particular maintenance status or valuation category.
- Can be used to track changes to material master data over time.
Query Logic
The view is 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 |