MaterialGroupsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialGroupsMD
Overview
This view provides a consolidated view of material group data from the SAP system. It combines data from the T023 and T023T tables to provide a comprehensive dataset for reporting purposes.
Data Sources
| Source Table/View | Description |
|---|---|
| t023 | Material Group Table |
| t023t | Material Group Text Table |
Key Use Cases
- Material group analysis and reporting
- Division and department performance monitoring
- Purchasing and inventory management
Query Logic
The view joins the T023 and T023T tables on the MANDT and MATKL fields to retrieve both material group data and corresponding text descriptions. The resulting dataset provides a comprehensive view of material group information.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM03 | Create/Change Material Group |
| MM04 | Display Material Group |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| MaterialGroup_MATKL | Material Group | |
| Division_SPART | Division | |
| ReferenceGroupRefMaterial_WWGDA | Reference Group Ref Material | |
| GroupMaterial_WWGPA | Group Material | |
| DepartmentNumber_ABTNR | Department Number | |
| AuthorizationGroup_BEGRU | Authorization Group | |
| DefaultUnitofWeight_GEWEI | Default Unit of Weight | |
| ValuationClass_BKLAS | Valuation Class | |
| PurchasingValueKey_EKWSL | Purchasing Value Key | |
| AssetClass_ANLKL | Asset Class | |
| PriceLevelGroup_PRICE_GROUP | Price Level Group | |
| MaterialGroupName_WGBEZ | Material Group Name | |
| Language_SPRAS | Language |