T023 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Material Groups data. There are total 15 fields in the table. The T023 table can be found in the IS-R merchandise categories (WWGR) package and is part of the Material Groups (LO-MD-MG) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full buffering as specified by generic key |
T023 Table Fields
The following is the list of fields that are available in SAP T023 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| MATKL | Material Group | MATKL | MATKL | CHAR | 9 | |
| SPART | Division | SPART | SPART | TSPA | CHAR | 2 |
| LREF3 | Material group-related supply relat. between plants /DEACT. | LREF3 | LREF3 | CHAR | 3 | |
| WWGDA | Material group reference material | WWGDA | MATNR | MARA | CHAR | 40 |
| WWGPA | Material group material | WWGPA | MATNR | MARA | CHAR | 40 |
| ABTNR | Department number | ABTNR | ABTNR | TSAB | CHAR | 4 |
| BEGRU | Authorization Group | BEGRU | BEGRU | CHAR | 4 | |
| GEWEI | Default unit of weight in the material master | GEWEI_V | MEINS | T006 | UNIT | 3 |
| J_1BNBM | Brazilian NCM Code | J_1BNBMCO1 | STEUC | CHAR | 16 | |
| BKLAS | Valuation Class | BKLAS | BKLAS | T025 | CHAR | 4 |
| EKWSL | Purchasing Value Key | EKWSL | EKWSL | T405 | CHAR | 4 |
| ANLKL | Default: Asset Class for Creation of Asset | MEVAK | ANLKL | ANKA | CHAR | 8 |
| DEF_SCHDSC | Event Scenario | EXP_SCHDSC | EXP_SCHDSC | * | CHAR | 6 |
| PRICE_GROUP | Price Level Group | PRICE_GROUP | PRICE_GROUP | * | CHAR | 6 |
Availability
The SAP HANA table T023 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for T023 table
We’re updating the content all the time, so check back regularly.
