topic Re: Table for Customizing and BASIS objects in Application Development and Automation Discussions

Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 05:54:40 GMT

Hi all,

Is there any table/view which stores a list of all customizing and BASIS objects created in the SAP system (something like table TADIR for programs)?

I should be able to query against that table and find if a particular customizing objects exists or not.

Regards,

Saurabh

Re: Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 06:09:49 GMT

Hi,

You will get all the custom programs (starting with Y* or Z) from the Table TADIR itself.Pass the Program id = R3TR object ID = PROG and object name = Y to Z*

you will get all custom programs. Similarly change the OBJECT ID to different to different type(TABL for tables VIEW for views etc).

also check the table TFDIR like that for Y* and Z* objects.

reward points if useful

regards,

Anji

Re: Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 06:12:25 GMT

Hi saurabh....

There is the table...

SMODILOG - Log of Customer Modifications to Dev. Env. Objects

This is what you are looking for i guess.

Reward points if helpful,

Regards,

Tejas

Re: Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 06:17:25 GMT

Hi saurabh,

1. Customizing object is finally nothing but

a tansparent table of type 'C' (deliery class = C customizing)

2. That we can anyway check in DD02L

table, which contains all tables list,

along with their delivery class.

regards,

amit m.

Re: Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 06:21:06 GMT

Hi,

Use table TADIR.In this u get all repositary objects.If u want user profiles details use tables USR10,USR12.

dont forget to give a reward if it helpful

Regards

Vana

Re: Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 06:23:55 GMT

Hi Anji and Tejas,

Thanks for your replies.

What I am looking for here is a table containing Customizing (eg Object type CUS0) and BASIS (eg Object type ACGR) objects and not customized (Z) objects. The tables TADIR and SMODILOG give me some of them but not all. Is there any table which can give me an exhaustive list of the same?

Regards,

Saurabh

Re: Table for Customizing and BASIS objects

Former Member — Tue, 10 Apr 2007 06:29:06 GMT

Hi Saurabh,

here in table SMODILOG...if u fatch data with condition...

where ( OBJ_TYPE = 'CUSO' or

OBJ_TYPE = 'ACGR' ) and

OBJ_NAME <> Y*string or

OBJ_NAME <> z*string.

This will get you the objects that you want.

Reward helpful answers with points,

Regards,

Tejas