topic Structure RIHEA in Application Development and Automation Discussions

Structure RIHEA

Former Member — Wed, 14 Dec 2005 11:58:34 GMT

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

Re: Structure RIHEA

Former Member — Wed, 14 Dec 2005 13:18:01 GMT

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

Re: Structure RIHEA

Former Member — Wed, 14 Dec 2005 14:21:35 GMT

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