SAP Table
T023 Material Groups
SAP table T023 has 2 primary key fields being MANDT,MATKL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T023 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyMATKL | 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 |
/ Relationships
T023 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T023 | ABTNR | TSAB | Contact persons: standard departments | MANDT |
| T023 | ABTNR | TSAB | Contact persons: standard departments | ABTNR |
| T023 | ANLKL | ANKA | Asset classes: general data | ANLKL |
| T023 | BKLAS | T025 | Valuation Classes | MANDT |
| T023 | BKLAS | T025 | Valuation Classes | BKLAS |
| T023 | EKWSL | T405 | Purchasing Value Key | MANDT |
| T023 | EKWSL | T405 | Purchasing Value Key | EKWSL |
| T023 | GEWEI | T006 | Units of Measurement | MANDT |
| T023 | GEWEI | T006 | Units of Measurement | MSEHI |
| T023 | MANDT | T000 | Clients | MANDT |
| T023 | SPART | TSPA | Organizational Unit: Sales Divisions | MANDT |
| T023 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| T023 | WWGDA | MARA | General Material Data | MANDT |
| T023 | WWGDA | MARA | General Material Data | MATNR |
| T023 | WWGPA | MARA | General Material Data | MANDT |
| T023 | WWGPA | MARA | General Material Data | MATNR |