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 the different b/w su10 and su12

2185


What does the account assessment category specify in a purchasing order in SAP Materials Management?

1010


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

985


what is hypercare and go live support?

4737


How to do Role Design, Testing and Implementation

2042






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

649


Can wildcards be used in authorizations?

706


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

675


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

1859


how we do CUA configuration in Quality system

1987


Differentiate between usobx_c and usobt_c

630


What is the difference between usobx_c and usobt_c?

649


What are pfud t-codes used for?

699


Give an example of SOD with object level control & also decide the Risk implication from the Technical standpoint.

4149


how we can see FFID if firefighter not able to see FFids ?

1490