Get material group description

[Former Member]

I use V023 to get the material description, in se11, i can check those data dictionary, but i can't join V023 in ABAP, it shown the error message ""V023" is not defined in the ABAP Dictionary as a table, projection view, or database view.". How can i retrieve the material group description. Thanks!

[Former Member]

I see table T023 which is master data table for MAterial group, contains Description.

Check fields WGBEZ or WGBEZ60.

[Former Member]

I have checked the table, i can see the field of wgbez, but once i select the field in the sql, it has error unknown column name

[Former Member]

Table name is T023T.

Fields are

SPRAS

MATKL

WGBEZ

WGBEZ60

you need to pass language key too.