topic Re: Problem with FM READ_TEXT in Application Development and Automation Discussions

Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 11:26:08 GMT

Sorry, but I didn't found any helpful answer.

I call the FM READ_TEXT at SAVE in the audit management.

I would like to get the text from the database, but I get the new text from the memory.

So, is there a FM which reads the text from the db?

Thx in advance

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 11:35:29 GMT

Hi,

pls refer to the link below:

Link:[https://forums.sdn.sap.com/click.jspa?searchID=24020051&messageID=6915079]

thanks

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 11:46:12 GMT

Hi,

ABAP READ_TEXT functions to read the SAP Long Text

All the long text can be retrieve using this method.

You have to used the READ_TEXT functions to read the SAP long text. e.g. Sales Order, Purchase Order Item text etc.

To check your long text header, go into the long text. Click Goto -> Header

Example of READ_TEXT functions reading tables PBIM - Independent requirements for material.

Go through this sample code below:


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.

Hope it helps

Regards

Mansi

Edited by: MANSI ASNANI on Mar 25, 2009 12:46 PM

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 12:00:04 GMT

Thx for your fast answer

BUT!

Have you read my problem?

I don't think so, because what you wrote is how to use the FM READ_TEXT....it runs...but I get the longtext from the MEMORY and not from DATABASE!

So I need a FM which gives me the longtext from the db.

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 12:21:54 GMT

Hi,

You can go through this link below:

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3bde358411d1829f0000e829fbfe/frameset.htm

Hope it helps

Regards

Mansi

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 12:32:16 GMT

Thank you for your answer. But I need a FM which gives me the text from the db

and not from the memory.

(I allready get the text from the memory, -> this is my problem)

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 13:07:21 GMT

Hello,

The function module READ_TEXT reads the desired text from the text file, or the text memory.

For that you must specify the the text using the following parameters:

OBJECT

NAME

LANGUAGE

With these option give unique or selective text rather tahn giving generic text as the internal table can hold only one text.

Example :

Ex:

DATA BEGIN OF i_tlines_r OCCURS 0.

INCLUDE STRUCTURE tline.

DATA END OF i_tlines_r.

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = 'Z040'

LANGUAGE = 'E'

NAME = '0000003243' "For ex, Billing document number ,

OBJECT = 'VBBK'

TABLES

LINES = i_tlines_r

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8

Re: Problem with FM READ_TEXT

former_member156446 — Wed, 25 Mar 2009 13:12:13 GMT

hi...

read_text FM if you can check the source code of the FM , it pulls data from STXH table which is a database table.. to your request to pull from DB is full filled using read_text fm....

if you dont want to do that hit STXH table, if you have all the primary keys of the table... pick data from DB table directly..

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 13:55:13 GMT

The FM READ_TEXT reads the text from the memory, if there is one.

Because, when I'm debugging my program and stop at FM READ_TEXT, I get the new text (which will be saved after the commit) and when I call the same FM via SE37 AT THE SAME TIME, I still get the old text.

So your reply, that the FM just reads from the db is NOT CORRECT.

I hope somebody can suggest another FM....

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 14:21:16 GMT

After you update the text, you also have to call FM COMMIT_TEXT . It's documented.

Rob

Re: Problem with FM READ_TEXT

former_member156446 — Wed, 25 Mar 2009 14:25:07 GMT


> So your reply, that the FM just reads from the db is NOT CORRECT.
>

your correct I just read the FM documentation:

A text is read from the text file or text memory with this function module.

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 14:25:46 GMT

COMMIT_TEXT?

This will book and store my text or?

What has this to do with my problem?

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 14:31:41 GMT


> What has this to do with my problem?

It solves your problem.

Rob

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 14:43:48 GMT

Really? How?

This will book the text which is in the memory or?

And when I call the FM READ_TEXT at next, I have no chance to get the old text (text before save).

My problem once again:

I need to get the text from the DB at saving to compare it with the new text (which will be saved).

But when I call the FM READ_TEXT I get the text from the memory (new text).

So, when I call the FM COMMIT_TEXT, I'll get THE NEW TEXT from the DB.

So I need a FM which I can call at saving BEFORE the commit and which reads the text from the DB.

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 15:00:34 GMT

I guess some of the confusion is over exactly what you are trying to do. Is it:

1) Modify some text and save it

2) Read the text that has just been saved

3) Do some processing

1) Modify some text and save it

2) Read the text that existed before the save

3) Do some processing

Something else?

Rob

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 15:03:08 GMT

I do the second one, (reading existing text)

But the FM READ_TEXT reads the new text from the memory

Re: Problem with FM READ_TEXT

former_member194669 — Wed, 25 Mar 2009 15:32:25 GMT

I think you are using this in a sap standard transaction ( audit management) ? then you need to find a userexit that triggering before any change happens to text by user and get the text here and keep in an internal table , then use that internal table compare text during SAVE.

Please check link

Usually, the system reads a text from the text file. However, for texts with storage in the update task thesystem first looks into the text memory to see whether it contains a currently processed version. If so the system reads this version of the text into the work area, otherwise the text version from the text file

http://help.sap.com/saphelp_nw70/helpdata/EN/d6/0db764494511d182b70000e829fbfe/frameset.htm

a®

Re: Problem with FM READ_TEXT

Private_Member_19084 — Wed, 25 Mar 2009 16:00:27 GMT

I'm allready in the correct BADI.

This is the first BADI which is called at save, so this must be the correct position

Re: Problem with FM READ_TEXT

Former Member — Wed, 25 Mar 2009 18:04:23 GMT

Maybe I'm missing something. Can you not keep a copy of the original text before it is edited?

Rob

Re: Problem with FM READ_TEXT

Private_Member_19084 — Thu, 26 Mar 2009 07:51:27 GMT

I solved my problem now on my own.

But this kind of solution is not very nice

Coding:

IMPORT tline TO rt_lines

FROM DATABASE stxl(tx)

CLIENT rt_client

ID stxl_id

ACCEPTING TRUNCATION

IGNORING CONVERSION

ERRORS.

Thank you for your fast replies