Table TADIR

[Former Member]

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?

[former_member209120]

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...

[Former Member]

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

[former_member209120]

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

[Former Member]

Hi Ramesh,

  Can give  any other table contain

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

[Former Member]

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

[Former Member]

Hi klaus,

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

[former_member209120]

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.

[Former Member]

Hi Ramesh ,

 

[former_member209120]

Hoo.....

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

[RaymondGiuseppi]

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

[Former Member]

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.

[SujeetMishra]

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

[Former Member]

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 )

[Former Member]

Hi ,

Can you give  any other table contain

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