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 is hypercare and go live support?

4883


What is the difference between authorization object and authorization object class?

761


Attributes in SE01?

2214


Differentiate between usobx_c and usobt_c

726


Is there a table for authorizations where I can quickly see the values entered in a group of fields?

868






What is use of derived roles?

843


what is analysis authorization in sap bi and how to create analysis authorization in sap bi?

1140


What are su25 t-codes used for?

795


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

6556


HI FRIENDS... I WANT TO KNOW FEW TICKETS ON SECURITY WITH SOLUTION.

1634


What authorization are required to create and maintain user master records?

767


Explain secure store and forward?

714


what is use of copy data in derived role and when we use this one ???

1422


How to run the daily background job s for virsa violations ? thabks in advance

3299


how a t code works

2062