Table which stores data of Notes tab - Description of Note Text in Insurance claim:iclcdc02

[suresh_266]

ICLNOTE table stores the line items of Notes and SOOD stores the Title of the Notes, But I need the description of the notes.

[raghava99]

Hi suresh_266,

All Note texts are stores in both ICLNOTE and SOOD tables. Note text which is created at the Notes tab in SAP Insurance, especially in the Claim management module. But it stores in the form of a RAW not string or char format.

There are 2 ways to get Note text.

1st way: using ICL_GOS_GET_NOTE_LONGTEXT fm.

inputs: IV_OBJYR = ICLNOTE-OBJYR

IV_OBJNO = ICLNOTE-OBJNO

2nd way: using SO_OBJECT_READ fm.

inputs :

FOLDER_ID-OBJTP = FLP "constant value

FOLDER_ID-OBJYR = SOPR-AFRYR

FOLDER_ID-OBJNO = SOPR-AFRNO

OBJECT_ID-OBJTP = RAW "constant value

OBJECT_ID-OBJYR = SOOD-OBJNO OR ICLNOTE-OBJYR

OBJECT_ID-OBJNO = SOOD-OBJNO OR ICLNOTE-OBJNO.

Thank you and Regards.

Raghavendra Kolanu.

[Maciej_Domagała]

I think it's just a question of finding out the value of text ID (STXH-TDID) with which the long texts available in "Notes" tab are stored in the system.

If you have already found some other texts belonging to the same document, now you know the value of STXH-TDOBJECT used by that application. So you can check in the database table STXH what are all the values of TDID used by that application:

select distinct TDID from STXH where TDOBJECT = <value-you-have-already-found-out>

I suppose texts from the "Notes" tab should be stored under one of these TDID's.

[Maciej_Domagała]

If you mean the long text (sorrounded with red square in your screen shot) - in general all the long texts in the SAP system are stored in database tables STXH (header data) and STXL (actual text lines). You can access them with fm READ_TEXT (see documentation).

I'm not familiar with this specific application you show but generally all you need to know to read any long text belonging to any application is:

- the application name (STXH-TDOBJECT);

- text ID (STXH-TDID) - which is an application-specific "type" of the text;

- and the text name (STXH-TDNAME) - which is some application-specific key (typically made of document number and/or line item number).

regards

[suresh_266]

Hi,
I cross-varified your inputs, the tables (STXH & STXL) and FM( READ_TEXT ) are giving the long text data of the Incident screen but not in Notes Screen long text data.

I am adding the screenshot of data given by READ_TEXT FM. But I need the long text provided in Notes Tab.