topic Get material group description in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864339#M671730 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Fri, 05 Oct 2007 01:28:40 GMT Former Member 2007-10-05T01:28:40Z Get material group description https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864339#M671730 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Fri, 05 Oct 2007 01:28:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864339#M671730 Former Member 2007-10-05T01:28:40Z Re: Get material group description https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864340#M671731 <HTML><HEAD></HEAD><BODY><P>I see table T023 which is master data table for MAterial group, contains Description.</P><P></P><P>Check fields WGBEZ or WGBEZ60.</P></BODY></HTML> Fri, 05 Oct 2007 01:31:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864340#M671731 Former Member 2007-10-05T01:31:13Z Re: Get material group description https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864341#M671732 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Fri, 05 Oct 2007 01:44:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864341#M671732 Former Member 2007-10-05T01:44:35Z Re: Get material group description https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864342#M671733 <HTML><HEAD></HEAD><BODY><P>Table name is T023T.</P><P></P><P>Fields are </P><P></P><P>SPRAS</P><P>MATKL</P><P>WGBEZ</P><P>WGBEZ60</P><P></P><P></P><P>you need to pass language key too.</P></BODY></HTML> Fri, 05 Oct 2007 01:47:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-material-group-description/m-p/2864342#M671733 Former Member 2007-10-05T01:47:18Z