Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

What tables contain transaction code usage?

Former Member
0 Kudos

Customer does not have GRC installed, and does not have security auditing turned on.  They want to create a report that allows them to select transaction code usage for a specific tcode or wildcard tcode range, by specific user or wildcard user name search, as the GRC activity report would show.  I believe they have used ST03N to get the info by one user at a time, but they want to create their own report that would give full function instead of trying to populate spreadsheets, do column joins, etc.  What are the names of the tables needed to query against?  Is there some existing ABAP report that already exists for SA38 execution available?  Hopefully the customer will implement GRC in the near future, but they have a need for a relatively quick fix as soon as possible.

Thanks in advance,

1 ACCEPTED SOLUTION

Colleen
Advisor
Advisor
0 Kudos

Hi Alfred

GRC usage reads information from STAD/STAT, CDHDR/CDPOS tables, SM19 and SM49

You would need to somehow read that information and look at the related function modules.

Regards

Colleen

3 REPLIES 3

Colleen
Advisor
Advisor
0 Kudos

Hi Alfred

GRC usage reads information from STAD/STAT, CDHDR/CDPOS tables, SM19 and SM49

You would need to somehow read that information and look at the related function modules.

Regards

Colleen

Former Member
0 Kudos

Hi Alfred,

The STAD/STAT/executed data is not stored in tables. You can access them via function modules.

Kind regards,

Meta

0 Kudos

FM SWNC_GET_STATRECS_FRAME should do this.

Cheers