Searching for transparent table & fields

[former_member190312]

Hi guys,

i am searching for some database Table & fields in the transaction ST04.those fields r relating to fields of structure ORASESSION. i m trying to find transparent table for all those fields below.

ORASESSION-SID

ORASESSION-SPID

ORASESSION-PROCESS

Regards

pabitra

[former_member190312]

can anyone plz answer this question???

[Former Member]

HI Pabitra,

To find tables which use the following fields, you can use the Where-used list.

Double click on the data element next to the field, ex: dbl clk on data element 'ORASID' for the field 'SID'. Right click the data element name and select Where-Used List (CTRLSHFTF3). Select the check box 'Table Fields' and click on Execute (Enter).

It will show the tables in which this field is used. Similarly you can do this for other fields.

You can use Where-Used list to find any tables, programs, classes etc. which use a particular object.

Reward points if useful.

Regards

Vidhya

[Former Member]

Hi,

here is the solution for your Q.

if you want to find the transparent table for the fields SID, SPID etc, go to the ABAP dictionary i.e SE11, and enter the table name DD03L in the "Database table" then press on display, then go to the "contents" i.e "CtrlShiftF10" then in the fieldname column enter the field that u want to find then press execute, you can find all the related transparent tables.

reward if helpful.

Regards

venkat