04-10-2007 6:54 AM
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
04-10-2007 7:09 AM
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
04-10-2007 7:12 AM
Hi saurabh....
There is the table...
<b>SMODILOG</b> - Log of Customer Modifications to Dev. Env. Objects
This is what you are looking for i guess.
<b>Reward points if helpful,</b>
Regards,
Tejas
04-10-2007 7:23 AM
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
04-10-2007 7:29 AM
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.
<b>Reward helpful answers with points,</b>
Regards,
Tejas
04-10-2007 7:17 AM
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.
04-10-2007 7:21 AM
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