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

DOES ANYONE KNOW WHAT TYPES OF SECURITY QUESTIONS ACCENTURE ASKED IN USA....URGENT PLEASE

2005


You want to remove a developer's and developer keys from a system. How would you do that?

814


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

4376


how we Set up Central User Administration (CUA) to manage 4 systems/clients

1994


what are all the questions covered in "profiles related concepts " please let me know ?

1792






A person has different user ids in different systems and you want to manage their authorizations centrally. Is it possible? How would you do it?

896


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

1762


How can I do a mass delete of the roles without deleting the new roles?

1038


Please let me know if there any vacancies for 3 years of Experienced level in SAP Security

1007


What does the item category specify in a purchasing requisition in SAP Materials Management?

1247


What is the use of tmssup* rfc destinations?

2086


Any details about secatt apart from SAPSecurity online.com?

2046


Which transaction code is used to display the user buffer?

844


What are su25 t-codes used for?

865


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

1151