Finding link to text in material master

pts.
Tags:
ERP
Greetings - I am trying to find the link to various pieces of text in the material master. Specifcially, I need to find the link to inspection and basic data text (in the material master, under the additional data button). I cannot seem to find this information anywhere in SAP. I have searched countless tables and even performed a trace to see if I can find the tables and pointers to this text, but so far this has not proved to be fruitful. I am hoping that someone out there can provide some insight to how this information is stored and some ideas that I can apply. Thanks in advance! Tony

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,
hopefully this reply is not too late but the texts you are looking for are in tables STXH, STXL, STXB. The ID’s for the text types are in table TTXIT and these are as follows:
MATERIAL BEST Purchase order text
MATERIAL GRUN Basic data text
MATERIAL IVER Internal note
MATERIAL PRUE Inspection text
MVKE 0001 Sales text

You will have to use function modules to read the texts since these are cluster tables, i.e. text is stored in compressed format.
Hope it helps, AM

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • sandrapoh
    Dear Amerkoulov,
    Do you have any idea how to convert the compressed format to text in excel?

    Regards
    Sandra
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following