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 | Possible values |
|---|---|---|---|---|---|---|
|
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 |