STANDARD TEXTS!!

[Former Member]

hi

i am trying to read the standard text for object 'VBBK' amd id 'YE06'.i am selecting the data from STXH table.But i am unable to establish the link between STXH and TLINE.I am unable to retrieve standard text for all the records.3

can some one help me with this please???

regards,

sirisha matta.

[Former Member]

hi

i am trying to read the standard text for object 'VBBK' amd id 'YE06'.i am selecting the data from STXH table.But i am unable to establish the link between STXH and TLINE.I am unable to retrieve standard text for all the records.3

can some one help me with this please???

regards,

sirisha matta.

[Former Member]

HI,

Please use FM READ_TEXT !

*CODE:

  DATA: BEGIN OF TTLINE OCCURS 0.
          INCLUDE STRUCTURE TLINE.
  DATA: END OF TTLINE.

MOVE 'YE06' to L_ID.

CALL FUNCTION 'READ_TEXT'                    
     EXPORTING                               
          CLIENT                  = SY-MANDT 
          ID                      = L_ID    
          LANGUAGE                = L_LANGU 
          NAME                    = L_BL     
          OBJECT                  = 'VBBK'   
     TABLES                                  
          LINES                   = TTLINE   
     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.
    READ TABLE TTLINE INDEX 1.
    MOVE TTLINE-TDLINE TO L_VALEUR.   
   ENDIF.
     

Erwan

[Former Member]

i am using exactly the same function module and getting the text for the particular object and id.i am select data from STXH to map the text to the particular sales order.but i am unable to map the text from READ_TEXT function module......???

can u tell me how to do that???

[Former Member]

Not sure of understanding. Can you elaborate...

If you need READ_TEXT input parameters, just open the text in plain page mode then GoTo -> Header.

If you want to update these text, plz use SAVE_TEXT or EDIT_TEXT...

Erwan

[Former Member]

Hi,

in Erwan's Code ( again written here )

*CODE:

DATA: BEGIN OF TTLINE OCCURS 0.

INCLUDE STRUCTURE TLINE.

DATA: END OF TTLINE.

MOVE 'YE06' to L_ID.

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = L_ID

LANGUAGE = L_LANGU

NAME = <b>L_BL </b>

OBJECT = 'VBBK'

TABLES

LINES = TTLINE

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.

READ TABLE TTLINE INDEX 1.

MOVE TTLINE-TDLINE TO L_VALEUR.

ENDIF.

L_Bl is the Sales Order Number.

Hope this helps

Regards

Nishant

[Former Member]

ERWIN,

i want to read this text and display it in the report layout.i am retrieving some data from vbap,vbak and depending on sales orders i am select text from STXH table and reading it and displaying it.

[Former Member]

nishant,

the problem i am facing is,when i read text i am able to read only the standard text of the first record only???wat could possibly wrong ???

[Former Member]

Do u read only the first line of the text ?

Or do u read only the text for the first sales document ?

If first case. Be sure of the table TTLINE declaration !

And replace the end by :

IF SY-SUBRC = 0.
Loop at ttline.
MOVE TTLINE-TDLINE TO itab. 
append itab.
endloop.
ENDIF.

Erwan

Message was edited by:

Erwan LE BRUN

In my eg. I read only the first line !

[Former Member]

it is reading the text of 1st record only

[Former Member]

You have to do something like this :

...

Loop at t_vbak.

move t_vbak-vbeln to L_NAME.

CALL FM READ_TEXT...

if sy-subrc eq 0.
loop at ttline.
...
endloop.
endif.


endloop.

[Former Member]

loop at itab.

use read_text function module.

loop at tline.

concatenate v_text tline-tlines into v_text.

endloop.

itab1-vbeln = itab-vbeln.

itab1-posnr = itab-posnr.

itab1-vtext = v_text.

append itab1.

clear: itab, itab1, v_text.

endloop.

use itab1 which will have line items along with text.

[Former Member]

can u give me the table name which stores the staandard text init????

name of the table.

[Former Member]

Here is the db table which stores the standard text

Check table

STXH

You need to give as input

1)application object

2)Name

3)Text ID

4)Language Key

U can check STXL also....

~~Guduri