Some User has made changes to Tables in SAP. How to identify that user?

Answer Posted / sapsecvj

A little BG: If I create a role using PFCG, there are at least 2-3 tables been updated, eg: AGR_TEXTS, AGR_125 even though I do not have S_TABU_DIS & S_TABU_NAM.

Majority of the business transactions will be updating the tables in the back-end. We need to know on which date, which Tcode is used and which table is been updated by the user.

Method 1:
Go to ST03N and trace out who used the Tcode on the particular date.

Method 2:
Use FM CHANGE_DOCUMENTS_READ (dont have access to SAP, pls check name). Pass appropriate Values to the FM. it will return results from CDHDR, CDPOS tables. this is also the fastest way to access them.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are st01 t-codes used for?

729


Which tables will you use for making customizing setting for security administration?

709


Userdone tasks with ffid n system send log reports to controller in his work inbox but whenever its open its showing blank screen, why?

1544


Explain transport system-level security?

644


What is the main purpose of parameters, groups & personalization tabs?

644






What does the pfcg_time_dependency clean up?

805


Explain internet-level security?

640


how you can delete multiple roles from qa, dev and production system?

809


How can sap security be improved?

685


What are the most used tables in sap?

671


What does user compare do?

688


How to insert missing authorization?

668


What is the difference between c (check) and u (unmaintained)?

1090


how we Restrict the auth groups for table maintain, creating Auth group using SE54 to built new Auth groups to restrict tables via auth object S_TABU_DIS

1850


User is not there in User master record. Then how to trace the user?

983