- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- View the List of tables accessed by a User
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
View the List of tables accessed by a User
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2014 11:46 AM
Hi Team,
Is it possible to find list of tables accessed by a user in sap( whether it may be CREATE ,CHANGE , DISPLAY or UPDATE)?
Thnaks in advance.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2014 10:21 AM
Thanks both of you for a quick response. We can see the change logs to a table using SCU3. Like using ST03 we can see the list of tcodes used by a particular user on a particular day , in this way can we see the tables accessed by a user ?
If yes,please provide me the information on this.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2014 3:07 PM
Hi,
It is possible to check change operation on table through SCU3 if you have activated table logging settings.
BR,
Mangesh
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2014 9:24 AM
Or, if you want to go to all tables you could try and run a trace (but ouch! the performance!). There are some additional tools on DB level, too ... with the same impact. So - it can be done - but not in a performant, convenient way with a nice Gui on top of it.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2014 10:21 AM
Thanks both of you for a quick response. We can see the change logs to a table using SCU3. Like using ST03 we can see the list of tcodes used by a particular user on a particular day , in this way can we see the tables accessed by a user ?
If yes,please provide me the information on this.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2014 10:35 AM
Aw, no - you can't use ST03N. You'll get statistics on tables but not in relation to users. All ST03N gives you in relation to users is times (CPU/net/DB) and what transaction any particular user has executed in the intervall you are inspecting. It won't give you details on create/display (!!!) tables (update or even delete^^). Since a single transaction can access 0-n tables, that won't answer your question. See for yourself: ST03N -> User and settlement statistics.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2014 3:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2014 12:18 AM
There is a little exception there -> SE16 case is a dynpro report generator which is submitted and collected by ST03N.
So immediately after the SE16 tcode start, you can see the submit of the screen program. That contains the table name (at the end of the generation namespace used by SE16).
Can be usefull, but incomplete as SM30 and SE31 / 34 SE16N RFC_READ_TABLE etc don't generate and submit reports. For that you need to use the SAL, GOS history or SAP RAL logging or the SCU3 if they actually changed something (or an educated mix of them).
Cheers,
Julius
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2014 10:35 AM
Hi Mylene, long time no...read May all is well on your side of the wire. cheers Otto
- SAP Managed Tags:
- Security
