topic Re: Tables needed in Application Development and Automation Discussions

Tables needed

Former Member — Wed, 12 Sep 2007 11:16:17 GMT

Hi all,

I need a small information , in which table all repository objects are stored?

i know it is TADIR but i need more information about when the object was created and when it was released. These information is not available in TADIR .Is there any other table where we can find all these information.

One more thing how to find out in which table a particular structure is used.

thanks in advance

kumaran.c

Re: Tables needed

Former Member — Wed, 12 Sep 2007 11:19:05 GMT

Hi!

Check out table TRDIR also.

What info is needed exactly for you?

Tables, data elements, etc... can be found in the DD* tables.

Regards

Tamás

Message was edited by:

Tamás Nyisztor

Re: Tables needed

Former Member — Wed, 12 Sep 2007 11:20:44 GMT

Hi Kumar.

Ur correct.If u want all information, go to se11 and give REP*.

Then it gives all relaed tables in which full information is stored.

if u want list if all tables or structures, use DD* in se11.

rewards if helpfull.

Re: Tables needed

Former Member — Wed, 12 Sep 2007 11:26:19 GMT

Hi Tamas,

TRDIR gives you information only for reports. my question is where can i find all repository objects information , in particular creation date and release date.

is there any single table?

Re: Tables needed

Former Member — Wed, 12 Sep 2007 12:00:31 GMT

Hi kiran,

REP* in se11 didnt help me. is there any other way where i could get the creation date and release for all repository objects in single table or mulitple tables

Re: Tables needed

Former Member — Wed, 12 Sep 2007 12:06:31 GMT

Hi,

Check this table <b>CDHDR</b>

reward me if it usefull answer

praveen

Re: Tables needed

Former Member — Wed, 12 Sep 2007 12:12:25 GMT

TADIR stores info about all repository objects.

now depending on the object types - separate master table exists for the Objects.

Say ur searching for MARA - TADIR holds an entry saying its R3TR TABL MARA.

But DD02L holds the details for this table. Likewise u have TRDIR for reports, DD04L for data elements, TFDIR for Function modules etc.

it depends on what is the objevt type u r searching for. U wont find a SINGLE TABLE storing all the information of all the objects ( like TADIR).

Re: Tables needed

Former Member — Wed, 12 Sep 2007 12:12:58 GMT

Hi Praveen,

Sorry i cant reward you for this ,

CDHDR is a table which stores changes of a document...But my question is different ,please understand the question before answering.

i think you got to reward me for this info ....

Re: Tables needed

Clemenss — Wed, 12 Sep 2007 12:25:52 GMT

Hi kumaran,

OK for ABAPs you have some more information about creation and change date. Those dates are stored in different tables for different kind of objects.

A good way to come closer is to look for the TADIR object key in transport objects stored in E071. From transport numbers in E071 check the transport details in E070.

If you need detailed transport information, this can be find in transport logs.

But in most cases, E071/E070 details will help.

Regards,

Clemens