SAP Table T023
Material Groups
T023 (Material Groups) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T023 to other SAP tables.
T023 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| MATKL | Material Group | MATKL | CHAR | 9 | 0 | |||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| LREF3 | Material group-related supply relat. between plants /DEACT. | LREF3 | CHAR | 3 | 0 | |||
| WWGDA | Material group reference material | WWGDA | MARA | CHAR | 18 | 0 | ||
| WWGPA | Material group material | WWGPA | MARA | CHAR | 18 | 0 | ||
| ABTNR | Department number | ABTNR | TSAB | CHAR | 4 | 0 | ||
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | 0 | |||
| GEWEI | Default unit of weight in the material master | GEWEI_V | T006 | UNIT | 3 | 0 | ||
| J_1BNBM | Brazilian NCM Code | J_1BNBMCO1 | T604F | CHAR | 16 | 0 | ||
| BKLAS | Valuation Class | BKLAS | T025 | CHAR | 4 | 0 | ||
| EKWSL | Purchasing Value Key | EKWSL | T405 | CHAR | 4 | 0 | ||
| ANLKL | Default: Asset Class for Creation of Asset | MEVAK | ANKA | CHAR | 8 | 0 | ||
| DEF_SCHDSC | Event Scenario | EXP_SCHDSC | CHAR | 6 | 0 | |||
| PRICE_GROUP | Price Level Group | PRICE_GROUP | CHAR | 6 | 0 | |||
T023 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T023 | ABTNR | T023 | MANDT | TSAB | Contact persons: standard departments | MANDT |
| T023 | ABTNR | T023 | ABTNR | TSAB | Contact persons: standard departments | ABTNR |
| T023 | ANLKL | T023 | MANDT | ANKA | Asset classes: general data | MANDT |
| T023 | ANLKL | T023 | ANLKL | ANKA | Asset classes: general data | ANLKL |
| T023 | BKLAS | T023 | MANDT | T025 | Valuation Classes | MANDT |
| T023 | BKLAS | T023 | BKLAS | T025 | Valuation Classes | BKLAS |
| T023 | EKWSL | T023 | MANDT | T405 | Purchasing Value Key | MANDT |
| T023 | EKWSL | T023 | EKWSL | T405 | Purchasing Value Key | EKWSL |
| T023 | GEWEI | T023 | MANDT | T006 | Units of Measurement | MANDT |
| T023 | GEWEI | T023 | GEWEI | T006 | Units of Measurement | MSEHI |
| T023 | J_1BNBM | T023 | MANDT | T604F | Import Processing: Control Code | MANDT |
| T023 | J_1BNBM | 'BR' | T604F | Import Processing: Control Code | LAND1 | |
| T023 | J_1BNBM | T023 | J_1BNBM | T604F | Import Processing: Control Code | STEUC |
| T023 | MANDT | T023 | MANDT | T000 | Clients | MANDT |
| T023 | SPART | T023 | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| T023 | SPART | T023 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| T023 | WWGDA | T023 | MANDT | MARA | General Material Data | MANDT |
| T023 | WWGDA | T023 | WWGDA | MARA | General Material Data | MATNR |
| T023 | WWGPA | T023 | MANDT | MARA | General Material Data | MANDT |
| T023 | WWGPA | T023 | WWGPA | MARA | General Material Data | MATNR |
