Long Text tables

[former_member698542]

Hi All,

Where the long text which we create from various transactions like routing etc will be stored.

Suppose When we create a down load program from which table the details be fetched.

Thanks and regards

Murugesan

[Former Member]

check in table - STXH and STXL.

Object - ROUTING

TEXT name = routing number...take ID...get the required field values form FM below

use FM READ_TeXT

pass

ID

NAME

ONBJECT=ROUTING

execute the FM, you will get the required Long text in output

[muthusamy_sankaran]

Hi,

In addition, see how to use READ_TEXT Function Module

• XNAME refers to Text name

CALL FUNCTION 'READ_TEXT'

EXPORTING

ID = 'PLPO'

LANGUAGE = 'EN'

NAME = XNAME

OBJECT = 'ROUTING'

TABLES

LINES = i_XTLINE

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6.

you need to find each operation object input **XNAME

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 CA03, enter Display Routing

2. double click long text indicator for any operation

3. from menuselect Goto>Header-->.... New window will be displayed

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

hope this will help for you

Regards,

Sankaran

[former_member698542]

Hi Sankaran,

Thanks for your prompt response.

How will I know the Text name from the transaction.

Where from the Function Module fetches the data.

Thanks and regards

Murugesan

[muthusamy_sankaran]

Hi,

For eample routing, Just join together bleow fileds

Table: PLPO

Fields: MANDT, PLNTY, PLNNR, PLNKN, ZAEHL

join above mendtion all fields, this is text name,

first you need to test this function module after write to program

TCODE - SE37 and input these all details

ID = 'PLPO'

LANGUAGE = 'EN'

NAME = XNAME - this is your itab field

OBJECT = 'ROUTING'

To find the Text id these are the following steps. Let us take an example of Routing operation long text.

1. goto CA03, enter material.. , (Display Routing)

2. double click long text indicator for any operation

3. from menuselect Goto>Header-->.... New window will be displayed

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

pls reward points

Regards,

Sankaran

[muthusamy_sankaran]

Hi Murugesan,

pls reward points and close thread or pls come back if you need more details/clarification on this

Regards,

Sankaran

[Former Member]

Hi,

I am having the same scenraio, where long text is called from PLPO table using tdname,tdid and tdobject.

In my case i am able to call complete long text but not sure for some reason it is limited to 40char per line.

in this way line break is happening from 40 char ( still ablel to see complete long text).

Is there any way i can show more than 40char per line.

My window size is good 78 width.

Appreciate your help in advance.

Thanks

Mamatha

[muthusamy_sankaran]

Hi,

pls use Function Module READ_TEXT, just call in to this FM for your donwload program

Regards,

Sankaran