SAP table reference
T023
Material GroupsExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table T023.
SAP table T023 has 2 primary key fields: MANDT,MATKL.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
T023 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key 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 |
/ Relationships
T023 relationships.
| 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 |