topic Re: What tables contain transaction code usage? in Application Development and Automation Discussions

What tables contain transaction code usage?

Former Member — Wed, 09 Apr 2014 01:33:36 GMT

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,

Re: What tables contain transaction code usage?

Colleen — Wed, 09 Apr 2014 01:43:58 GMT

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

Re: What tables contain transaction code usage?

Former Member — Wed, 09 Apr 2014 09:27:11 GMT

Hi Alfred,

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

Kind regards,

Re: What tables contain transaction code usage?

mvoros — Wed, 09 Apr 2014 10:55:11 GMT

FM SWNC_GET_STATRECS_FRAME should do this.

Cheers