topic Re: Tables in Application Development and Automation Discussions

Tables

SrinivasuDaroor — Tue, 02 Dec 2008 09:23:25 GMT

Hi,

I want to list all the standard objects (i.e Programs or Database Tables etc ) which are modified with the access key. In which table I can find this information.

Thanks

Edited by: Matt on Dec 2, 2008 2:07 PM - please use meaningful subject in future.

Re: Tables

Former Member — Tue, 02 Dec 2008 09:28:30 GMT

Hi,

you can find this details by using SPAU and SPDD Tcodes.

SPDD will give u all Data Dictionary objects being touched by user and

Amresh.

Re: Tables

JozsefSzikszai — Tue, 02 Dec 2008 09:29:51 GMT

These are stored in table ADIRACCESS, you can have the list of tables/structures by selecting with R3TR TABL ...

Re: Tables

Former Member — Tue, 02 Dec 2008 12:07:21 GMT

The table for this is SMODILOG (Log of Customer Modifications to Dev. Env. Objects)

Steps to get only standard objects is as follows.

Goto SE11~~>SMODILOG~~>DISPLAY~~>CONTENTS(CTRLSHIFTF10)~~.for OBJECT NAME filed you need to exclude following values

sapmz*

sapmy*

saplz*

saply*

lz*

ly*

mz*

my*

AND apart from this if you have any other customer namespaces like /ENTEG/*

Note Exclude all these values for the above field

and execute,then you will get all the different types of standard objects which are modified by the customer.

For output fields select OBJECT TYPE & OBJECT NAME field.

Apart from that SPDD & SPAU t-codes will give the details regarding the objects modified by customer.

Regards

Ansumesh