Structure RIHEA

[Former Member]

Hello,

In transaction IW69, there is a field "Status Included" that I would like to retrieve data for. The underlying structure for this field is RIHEA and the field is I_QSTATIN. (Program name - RSSYSTDB Is there any way that I could find out which database table(s) store this data? If I can't find the table, is there any other way I could retrieve values for this field as well as other fields in this transaction?

Thanks in advance,

Charles

[Former Member]

Hi,

Statuses are not directly stored in any of the tables.

You can get the Status from the table JEST. You will have to provide the object number to it for the selection.

Also you can run the SQL Trace (Trxn ST05) and find out which all tables are affected in the transaction.

Hope it helps...

Lokesh

Pls. reward appropriate points

[Former Member]

hi chales

The r two way i know

go to the structure in se11 select check bok and press ctrlshiftf3.

in the popup click tables.

or gotose16 DD03L table name. click the table content icon or f7.

give the field name in the selection screen and execute.it ll give list of tables