topic Re: track back maintained data for FM read_text in Application Development and Automation Discussions

track back maintained data for FM read_text

Former Member — Tue, 18 Sep 2007 04:18:47 GMT

Hi,

I would like to track back where the data is maintained. Here is the following parameters passed in to this FM.

FM - read_text

id - 0005

name - customer number + company code

object - KNB1

Thanks

Re: track back maintained data for FM read_text

Former Member — Tue, 18 Sep 2007 04:22:35 GMT

hi,

STXH is the table where the text is maintained.

But u wont be able to see directly ur text data thru this table but only thru FM "Read_text'.

Revert back if any issues.

Reward with points if helpful.

Regards,

Naveen

Re: track back maintained data for FM read_text

Former Member — Tue, 18 Sep 2007 04:26:29 GMT

hi,

thanks for reply. i need to know which tcode and at where the data is maintained.

STXH table i know but i do not know from the parameter, which tcode the data is maintained.

thanks

Re: track back maintained data for FM read_text

Former Member — Tue, 18 Sep 2007 04:34:05 GMT

Hi ,

See the text is maintained in the documents such as VL01, Va01 or ME21n.

For ex : when u run VL01n , Menu ~~> Goto~~> Header/item--> Texts.

Here user can maintain the text and all these text will be stored in STXh table with Respective object, ID, lang...

Revrt back if any issues,

Regards,

Naveen

Re: track back maintained data for FM read_text

Former Member — Tue, 18 Sep 2007 04:52:03 GMT

good

go through this code

REPORT ZTEXT .

TABLES: PBIM.

stxh, stxl, stxb - trans tables for text
ttxit - text on text-ids
ttxot - Short texts on text objects
Transaction MD63

SELECT-OPTIONS: S_MATNR FOR PBIM-MATNR,

S_WERKS FOR PBIM-WERKS.

DATA: BEGIN OF HTEXT.

INCLUDE STRUCTURE THEAD.

DATA: END OF HTEXT.

DATA: BEGIN OF LTEXT OCCURS 50.

INCLUDE STRUCTURE TLINE.

DATA: END OF LTEXT.

DATA: BEGIN OF DTEXT OCCURS 50.

DATA: MATNR LIKE PBIM-MATNR.

INCLUDE STRUCTURE TLINE.

DATA: END OF DTEXT.

DATA: TNAME LIKE THEAD-TDNAME.

SELECT * FROM PBIM WHERE WERKS IN S_WERKS.

MOVE PBIM-BDZEI TO TNAME.

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = 'PB'

LANGUAGE = 'E'

NAME = TNAME

OBJECT = 'PBPT'

ARCHIVE_HANDLE = 0

IMPORTING

HEADER = HTEXT

TABLES

LINES = LTEXT

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8.

LOOP AT LTEXT.

IF LTEXT-TDLINE NE ''.

MOVE LTEXT-TDLINE TO DTEXT-TDLINE.

MOVE PBIM-MATNR TO DTEXT-MATNR.

APPEND DTEXT.

ENDIF.

ENDLOOP.

ENDSELECT.

LOOP AT DTEXT.

WRITE:/ DTEXT-MATNR, DTEXT-TDLINE.

ENDLOOP.

What is the purpose of READ_TEXT functuion module and how to get text id value in this scenario(TDID)?

In business process, there are so many transactions that take place in every day, like purchase orders, sales orders, delivery, gooodsmovement etc... SAP provided a feature to maintain some text descriptions.

Read_Text Function module is used to retrieve the text for a particular objects.

To find the Text id these are the following steps. Let us take an example of Billing document Header text.

1. goto VF03, enter Billing doc Number

2. from menu~~select Goto~~>Header-->header Text..... New window will be displayed

3. select the Header Text. here you can see all the text.

4. click on the TEXT (which you want to know the Text id) , then press log ICON (you can find in bottom right of the text window) it looks like a rolled paper.

5. in the Next window you will find Text Name. Text ID, Language. etc...

thanks

mrutyun^