Material basic data text.

[Former Member]

Hi All,

I would like to retrive material "Basic Data Text" (material master additional data) value form a group of materilas. I tried table STXL but it did not give the text vale as readable.

Please help me for a better solution.

Thanks

John K.

[Shiva_Ram · Accepted solution]

Hi,

Create an ABAP query with table MARA.

Add a new field like ZBASICTEXT. For this field add code to pull the text from material master basic text using function module READ_TEXT.

In our requirements, I developed a query which pulls the basic data text from material master, which is maintained in language Afrikkan.

Following is the code sample, change the language in this code,

TABLES:

STXH.

DATA:

TDNAME LIKE STXH-TDNAME,

MYLINE LIKE TLINE-TDLINE,

ZE13_LINE(200) TYPE C.

DATA:BEGIN OF LINES OCCURS 0.

INCLUDE STRUCTURE TLINE.

DATA:END OF LINES.

DATA:BEGIN OF MYHEADER.

INCLUDE STRUCTURE THEAD.

DATA:END OF MYHEADER.

CLEAR ZBASICTEXT.

CLEAR TDNAME.

MOVE MARA-MATNR

TO TDNAME.

CALL FUNCTION 'READ_TEXT'

EXPORTING

ID = 'GRUN'

LANGUAGE = 'a'

NAME = TDNAME

OBJECT = 'MATERIAL'

IMPORTING

HEADER = MYHEADER

TABLES

LINES = LINES

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8.

IF SY-SUBRC = 0.

LOOP AT LINES.

MOVE LINES-TDLINE(132) TO ZBASICTEXT."myline.

EXIT.

ENDLOOP.

ENDIF.

Hope this helps. Regards