Material Database table for Basic Data text (long text)

[Former Member]

Hello everyone!

Is there a standard material master data table in which we can view the Basic Data Text or the long additional text explicitly?

Thank you.

[muthusamy_sankaran · Accepted solution]

Hi,

You can use below function module to read the basic data text in material master

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = 'GRUN'

LANGUAGE = sy-langu

NAME = name " matnr

OBJECT = 'MATERIAL'

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.

clear lines.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

Regards,

Sankaran

[Former Member · Accepted solution]

Thanks...but where do I execute this function? Is it in SE38?

[muthusamy_sankaran · Accepted solution]

Hi,

SE37 and test it

Regards,

Sankaran

[Former Member · Accepted solution]

But i am not an ABAPer. My rights to SAP is limited. I don't have an access key. That's why I asked for a standard report.

[Former Member]

Hi,

GO to se16 use table STXH

use functional module READ_TEXT

Edited by: Roy Anamika on Jul 31, 2009 6:34 AM

[Former Member]

Sorry...there is no standard report to view the Basic Data Text or the long additional text of Material master