SAP table T023 (Material Groups)
SAP table T023 has 2 primary key fields being MANDT,MATKL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| MATKL | Material Group | CHAR | 9 | 0 | MATKL | ||
| SPART | Division | CHAR | 2 | 0 | TSPA | SPART | |
| LREF3 | Material group-related supply relat. between plants /DEACT. | CHAR | 3 | 0 | LREF3 | ||
| WWGDA | Material group reference material | CHAR | 40 | 0 | MARA | WWGDA | |
| WWGPA | Material group material | CHAR | 40 | 0 | MARA | WWGPA | |
| ABTNR | Department number | CHAR | 4 | 0 | TSAB | ABTNR | |
| BEGRU | Authorization Group | CHAR | 4 | 0 | BEGRU | ||
| GEWEI | Default unit of weight in the material master | UNIT | 3 | 0 | T006 | GEWEI_V | |
| J_1BNBM | Brazilian NCM Code | CHAR | 16 | 0 | J_1BNBMCO1 | ||
| BKLAS | Valuation Class | CHAR | 4 | 0 | T025 | BKLAS | |
| EKWSL | Purchasing Value Key | CHAR | 4 | 0 | T405 | EKWSL | |
| ANLKL | Default: Asset Class for Creation of Asset | CHAR | 8 | 0 | ANKA | MEVAK | |
| DEF_SCHDSC | Event Scenario | CHAR | 6 | 0 | * | EXP_SCHDSC | |
| PRICE_GROUP | Price Level Group | CHAR | 6 | 0 | * | PRICE_GROUP |
T023 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T023 | ABTNR | TSAB | Contact persons: standard departments | MANDT |
| 0 T023 | ABTNR | TSAB | Contact persons: standard departments | ABTNR |
| 1 T023 | ANLKL | ANKA | Asset classes: general data | ANLKL |
| 0 T023 | BKLAS | T025 | Valuation Classes | MANDT |
| 0 T023 | BKLAS | T025 | Valuation Classes | BKLAS |
| 1 T023 | EKWSL | T405 | Purchasing Value Key | MANDT |
| 1 T023 | EKWSL | T405 | Purchasing Value Key | EKWSL |
| 0 T023 | GEWEI | T006 | Units of Measurement | MANDT |
| 0 T023 | GEWEI | T006 | Units of Measurement | MSEHI |
| 1 T023 | MANDT | T000 | Clients | MANDT |
| 0 T023 | SPART | TSPA | Organizational Unit: Sales Divisions | MANDT |
| 0 T023 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| 1 T023 | WWGDA | MARA | General Material Data | MANDT |
| 1 T023 | WWGDA | MARA | General Material Data | MATNR |
| 0 T023 | WWGPA | MARA | General Material Data | MANDT |
| 0 T023 | WWGPA | MARA | General Material Data | MATNR |