Object Details

[Former Member]

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

[former_member222860]

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

[GauthamV]

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.

[Former Member]

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

[JoffyJohn]

check this report program

RSWBO040

[Former Member]

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.