topic Re: Table TADIR in Application Development and Automation Discussions

Table TADIR

Former Member — Thu, 05 Sep 2013 04:10:04 GMT

Hi,

I need to fetch

Object Type
Object Name in Object Directory

from the table tadir(Directory of Repository Objects) based on the created date(CREATED_ON ->field in tadir) .But the execution time is very high.Is it possible to reduce execution time?

Re: Table TADIR

former_member209120 — Thu, 05 Sep 2013 04:20:05 GMT

Hi Kiran Rajan,

Can you share your code to know how you are fetching..

see this link for example http://wiki.sdn.sap.com/wiki/display/Snippets/ALV+report+to+list+the+user+developed+local+objects+in+the+SAP+system

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 04:28:06 GMT

Hi Ramesh,

SELECT

           pgmid

           object

           obj_name

           author

           devclass

           created_on

      FROM tadir INTO TABLE lt_tadir

      WHERE created_on IN so_date.

so_date is select option.

lt_tadir ->internal table

Re: Table TADIR

former_member209120 — Thu, 05 Sep 2013 04:37:50 GMT

Hi Kiran,

SELECT
           pgmid
           object
           obj_name
           author
           devclass
           created_on
           FROM tadir INTO TABLE lt_tadir
           WHERE created_on IN so_date.

i am not getting created_on in tadir table in my system

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 04:38:07 GMT

Hi Kiran,

we have no CREATED_ON field in our systems in table TADIR.

But if you have one in your system, you can create a custom secondary index for that field. This should improve data access.

Regards,

Klaus

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 04:55:03 GMT

Hi klaus,

I try with secondary index but my data base system is maxdb.Is possible to use secondary index in maxdb

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 04:58:44 GMT

Hi Ramesh,

Can give any other table contain

Object Type
Object Name in Object Directory
Author
Package name
created date

Re: Table TADIR

former_member209120 — Thu, 05 Sep 2013 05:01:25 GMT

Hi Kiran

How you will fetch data with CREATED_ON field from TADIR, with out having that field in TADIR table.

if you fetch data using key fields i would be better.

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 05:09:02 GMT

Hi Ramesh ,

Re: Table TADIR

former_member209120 — Thu, 05 Sep 2013 05:23:08 GMT

Hoo.....

We are using ECC 6.0 we don't have that fields...

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 07:14:41 GMT

hi Kiran Rajan ,

if you add some extra necessary conditions to select statement then the execution time will reduce.

select

pgmid

object

obj_name

from tadir

into table it_dir

where date = s_date and devclass= '$TMP' and (obj_name like 'Z%' or obj_name like 'Y%') etc..

hope it will reduce the time span.

Re: Table TADIR

SujeetMishra — Thu, 05 Sep 2013 09:40:11 GMT

Hi Kiran,

As CREATED_ON is not a primary key at table level, so to have better improved performance and easy access to DB , just create one secondary index for CREATED_ON field, then use your select query.

Regards,

Sujeet

Re: Table TADIR

RaymondGiuseppi — Thu, 05 Sep 2013 10:16:29 GMT

Fields appended in SAP_BASIS 702, and yes no index on this field, so you fetch whole TADIR table (check your ehp level)

Regards,

Raymond

Re: Table TADIR

Former Member — Thu, 05 Sep 2013 12:18:07 GMT

You may have to filter the records providing further selection criteria.

Example:

SELECT

           pgmid

           object

           obj_name

           author

           devclass

           created_on

      FROM tadir INTO TABLE lt_tadir

where SRCSYSTEM NE 'SAP' and created_on IN so_date.

This will remove all the standard objects and will reduce the time considerably.

(That is if you are interested only in the user created objects )

Re: Table TADIR

Former Member — Thu, 12 Sep 2013 08:33:23 GMT

Hi ,

Can you give any other table contain

Object Type
Object Name in Object Directory
Author
Package name
created date