To Find out no of Z_Programs, Z_Database tables, Z_BDC, Z_ABAP Query

[Former Member]

Hi,

Is there any way to see the no of Z_programs,Z_Database tables, Z_BDC, Z_ABAP Query in my ECC system.

Is there any transaction code to find out the same.

If it is not there can anyone tell me the step by step procedure to know the same.

its urgent, thanks in advance,

Regards,

Mithun

[Clemenss]

hi Mithun,

check table TADIR for OBJ_NAME Z* and Y*. The OBJECT field will tell you which kind of object.

Good luck! (we have mor than 15.000 Z objects in our system).

Regards,

Clemens

[Former Member]

is there any way to know it seperately i mean for programs, queries, BDC's, database tables.

[dhorions]

The field OBJECT defines the type.

CLASS for Class, METH for method, REPO for report etc, use f4 key in se16 to get all possible values.

[Former Member]

thanks dries, i was checking it for the programs as you told, filled in object as REPS(Report source code), it showed the no. of entries as zero can you explain why?

[dhorions]

You should probably use PROG then.

[Clemenss]

Yes,

PGMID R3TR

OBJECT PROG

Regards,

Clemens

[Former Member]

one last thing the same problem is coming for tablesand ABAP Query

can you suggest any soln for this too.

[dhorions]

yes I have a suggestion : "try" .

For example : type in the name of a query you know exists, then press F8, see what the value of OBJECT is.

[Former Member]

what about for BDC, i am not able to find it out in the OBJECT

[dhorions]

I think they're in table V_OP , but not unique.