MaterialGroupsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialGroupsMD
Overview
This reporting view provides a comprehensive overview of material group data from SAP systems. It combines data from the T023 and T023T tables to provide insights into material group attributes, such as reference group, valuation class, and default unit of weight.
Data Sources
| Source Table/View | Description |
|---|---|
| T023 | Material Group Table |
| T023T | Material Group Text Table |
Key Use Cases
- Analyzing material group structures and hierarchies
- Identifying material groups associated with specific divisions, departments, or authorization groups
- Understanding the default settings and attributes assigned to material groups
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 view provides a consolidated representation of material group information.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM03 | Create Material Group |
| MM02 | Change Material Group |
| MM01 | 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 |