Material Group description

[Former Member]

I've an ABAP report for FI Billing Listing.

My user has a requirement to add in the Material Group and Material Group Description.

In table VBRP, there is such field for Material Group. VBRP-MATKL. I brought it out and populated in the output.

But for the Material Group Description, do i have to link to table T023T in order to bring out the description?

In SQ01/SQ02, lets say i used table VBAK-KUNNR (Customer), automatically i could show the text for TEXT_VBAK_KUNNR

So does ABAP /SE38 have this feature?

[Former Member]

But for the Material Group Description, do i have to link to table T023T in order to bring out the description?

This will work. A simple query on table T023T in reference from VBRP-MATKL.

Regards,

Jake.

[RaymondGiuseppi]

Yes you can

- access to the text table in your code/query - here t023t

- use the same tool than query to recover descriptions via interface IF_TEXT_IDENTIFIER (class cl_text_identifier)

* Class "Automatic Identification of Texts in Dictionary"
class cl_text_identifier definition load.
data if_text_identifier_obj type ref to if_text_identifier.
* List of description fields to be filled
begin of t_text occurs 0, " textes à chercher
  tabname type tabname,     " table 
  fieldname type fieldname, " <field>
  codefield type fieldname, " <table>_<field>
  textfield type fieldname, " TEXT_<table>_<field>
end of t_text,
* Call method
call method if_text_identifier_obj->read_text
  exporting
    tabname                 = lv_tabname
    fieldnames              = lt_fieldnames
    record                  = <fs>
    record_specified        = 'X'
  importing
    text_identifier_results = lt_text_results.
LOOP AT lt_text_results INTO wa_text. " Map texts
...

Regards,

Raymond

[Former Member]

i've added a few codes, and now it is showing up

SELECT SINGLE wgbez FROM t023t INTO gw_t023t-wgbez
         WHERE spras EQ sy-langu
           AND matkl EQ gw_mat_index-matkl.

         gw_output-mgrp_text = gw_t023t-wgbez.