how to download material sales text and purchase order text information

[Former Member]

Here is situation:

goto MM03 transaction,

Take any material -- and select below views

1. sales text

2. purchase order text

i have to write the download program with the sales text and purchasing text information of all the materials.

could you pls tell me in which table I will get all the above sales text and purchase order text infrmation.

I think it will store in standard text. I checked STXH table also for getting information text object, text id, text name, language, etc.

If anybody knows .. please share.

Thanks in advance.

Regards

Raghu

[former_member181962]

Hi Raghunath,

YOu have to use READ_TEXT Function module to read the material sales text and purchase order text information.

YOu have to pass the corresponding TEXT IDs and Objects for the function modules to get the texts.

Regards,

Ravi

[Former Member]

Thanks a lot. problem solved.

[former_member297642]

Hi,

Goto MM03 ->view purchase order text.

In purchase order text screen, below you find one icon 'Editor'

click on this icon. It will open another screen.

In this screen -> click Goto Menu->Header.

It will open the details about Purchase order text.

TextName (Generally it is material name)

Language

Text ID : BEST

Text Object: MATERIAL.

Pass the above to READ_TEXT to get the text.

Regards,

Ranjith.

[Former Member]

Declare internal tables as follows: - An example

TYPES: BEGIN OF TY_PO_LINES,

INCLUDE STRUCTURE TLINE.

END OF TY_PO_LINES,

TY_PO_LINES_T TYPE STANDARD TABLE OF TY_PO_LINES.

TYPES: BEGIN OF TY_PO_TEXT,

TDOBJECT TYPE TDOBJECT

TDNAME TYPE TDOBNAME,

TDID TYPE TDID,

SPRAS TYPE SPRAS,

TDLINES TYPE TY_PO_LINES OCCURS 0,

END OF TY_PO_TEXT,

PO_TEXT_T TYPE STANDARD TABLE OF TY_PO_TEXT.

DATA: PO_TEXT TYPE TY_PO_TEXT_T

PO text:

-

---

Looping at your internal table which consists of PO number,

SELECT TDID TDSPRAS FROM STXH INTO A INTERNAL TABLE say PO_TEXT

TDOBJECT = EKKO "PO Header Text

TDNAME = PO NUMBER

SELECT TDID TDSPRAS FROM STXH INTO A INTERNAL TABLE say PO_TEXT

TDOBJECT = EKPO "PO line item text

TDNAME = PO NUMBER

ENDLOOP

Looping at PO_TEXT

CALL FUNCTION 'READ_TEXT'

EXPORTING

ID = PO_TEXT-TDID

LANGUAGE = PO_TEXT-TDSPRAS

NAME = PO_TEXT-TDNAME

OBJECT = PO_TEXT-TDOBJECT

TABLES

LINES = PO_TEXT-TDLINES

ENDLOOP

Follow the same above logic for material with suitable TDID you need to extract

Hope this helps,

SKJ