Table for Long Texts of MICs in Tasklist

[Former Member]

Dear All

Can any body tell me from which SAP table i can get the LONG TEXT maintained for MICs in any tasklist.

Table PLMK only shows wether long text maintained or not, but i want the value in LONG TEXT.

thanks

Zeeshan

[Former Member]

This may be helpful.

SAP stores comments (text fields) in a separate table. STXH is the text

"header" table (STXD SAPscript text file header). STXH-TDOBJECT =

'KNA1' will bring back all the customer comment headers. STXH-

TDNAME='0000010744' is the header record for the comment for customer

10744.

It is not always so simple to figure out what the TDOBJECT (object needed by function below - sometimes it is a table name, other times...), TDNAME (name needed by function below - sometimes it is a document number & line item or customer number, other times... ) & TDID (id needed by function below - it is always the long text id). There are several methods that can be used. You can create the long text that you are researching and using, SE16 for table STXH search TDLUSER = to your kerberos principal and TDLDATE = to today's date. This is modify date & user. Alternatively, you can find an existing item with the long text and figure out the date and user who last modified it and use this information in your search. Once you have STXH row for text of interest, use ZCAFTXT to test your research. Project Titles and WBS Titles are a bit more complex.

Changes to sales contract long text between 3.0F and 4.5B.

The following code is a function that will return a customer comment.

form get_comment using cur_kunnr.

call function 'READ_TEXT'

exporting

id = '0002'

language = sy-langu

object = 'KNA1'

name = cur_kunnr

importing

header = thead

tables

lines = tlinetab

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.

loop at tlinetab.

write / tlinetab-tdline.

add 1 to line_cnt.

endloop.

endif.

endform.

The above subroutine is called with the following code:

if p_cmnt = 'X'.

tdname = cur_cust-kunnr.

perform get_comment using tdname.

endif.

These data elements are defined as:

data: begin of tlinetab occurs 100. "table to process comments

include structure tline.

data: end of tlinetab.

data: tdname like thead-tdname.

Vishal Jonnalwar

[Former Member]

Have you checked in the table STXH?

Vishal Jonnalwar

[Former Member]

Hi

can READ_TEXT is a Fm used for Long TEXT not be used??

Sujit