topic Re: searching for table & fields in Application Development and Automation Discussions

searching for table & fields

former_member190312 — Wed, 06 Feb 2008 07:07:48 GMT

Hi guys,

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

ORASESSION-SID

ORASESSION-SPID

ORASESSION-PROCESS

Regards

pabitra

Re: searching for table & fields

Former Member — Wed, 06 Feb 2008 07:11:58 GMT

Thse are the possible tables

DBSTATTMSS Table sizes

MSQSNAP MS SQL Server: Database performance snapsh

MSSCNTDEAD Cumulated deadlock statistics data

MSSDBSTATT Table statistics for MS SQL Server

MSSDEADLCK Database Deadlock Information for MSSQL Se

Reward if useful

Narendra

Re: searching for table & fields

former_member190312 — Sun, 10 Feb 2008 14:18:35 GMT

can anyone plz reply myquestion exactly ???

Re: searching for table & fields

Former Member — Sun, 10 Feb 2008 14:28:10 GMT

Hi,

Go to SE11 --> Input the fieldname --> Click on Where used list --> A pop up window will be displayed --> There select only database table check box rest everything should be deselected --> Press enter. There you can see the database where these fields are used.

Thanks,

Sriram Ponna.

Re: searching for table & fields

Clemenss — Sun, 10 Feb 2008 17:16:26 GMT

Hi pabitra,

use SE16 on table DD02L to get all tables with their respective characteristics (transparanet, cluster, pool, include structure, ...).

Then SE16 on table DD03L to get the fieldnames, data elemets, domains.

Was this your question?

Regards,

Clemens