topic Re: STANDARD TEXTS!! in Application Development and Automation Discussions

STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 14:56:56 GMT

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.

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 14:58:21 GMT

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

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:02:11 GMT

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???

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:05:30 GMT

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

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:08:03 GMT

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

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:09:54 GMT

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.

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:21:02 GMT

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 ???

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:22:57 GMT

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 !

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:26:36 GMT

it is reading the text of 1st record only

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:32:13 GMT

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.

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:34:39 GMT

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.

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 15:59:01 GMT

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

name of the table.

Re: STANDARD TEXTS!!

Former Member — Wed, 31 Jan 2007 16:43:08 GMT

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