topic Object Details in Application Development and Automation Discussions

Object Details

Former Member — Mon, 15 Dec 2008 06:32:04 GMT

Hi all,

In my requirement, I want to get the details of objects based on some selection fields.

For eg. Based on some user name, package, transport requests etc, I want to get the details of the objects.

Some details I can get from tables E070, E071, TADIR. I want the description, Creation date, Last changed date of all objects. For those there are different tables available.

For eg. For programs, table TRDIR is there. For Domains, DD01T is there.

So based on the object type which i got from table TADIR, I want the details from table corresponding to that object.

How to do this? If requirement not understood, please revert back.

Regards

Natasha Garg

Re: Object Details

former_member222860 — Mon, 15 Dec 2008 06:54:31 GMT

Hey,

U can write a dynamic Query like this:

SELECT SINGLE DEVCLASS INTO TADIR-DEVCLASS

FROM TADIR

WHERE PGMID = 'R3TR'

AND OBJECT = 'TABL'

AND OBJ_NAME = DD02L-TABNAME.

hope u get some hint from the above

thanks\

Mahesh

Re: Object Details

GauthamV — Mon, 15 Dec 2008 06:54:32 GMT

hi,

you cannot get all these details based on object type of TADIR in one table.

depending on transactions they may change.

if you require any specific details revert back.

Re: Object Details

JoffyJohn — Mon, 15 Dec 2008 07:07:23 GMT

check this report program

RSWBO040

Re: Object Details

Former Member — Mon, 15 Dec 2008 07:09:07 GMT

Hi,

I know I cant get details of all objects in one table. I know the individual tables. But I want to know if I can achieve this thing dynamically.

Regards

Natasha Garg

Re: Object Details

Former Member — Mon, 15 Dec 2008 07:18:21 GMT

check this FM if its useful to you.

CMS_RE_DB_RE_GET its text says "FM for getting the details of an object"

i have not tested it, sorry if its irrelevant to u.