08-23-2007 10:04 AM
Is there any way that we can find how the records are deleted,like by execution of any report or manually.
08-23-2007 10:11 AM
if u want to delete records from data base u have to write a simple report program or module pool program
syntax
if sy-subrc=0.
DELETE FROM ztab1 WHERE <fieldname> in s_fldnam .
reward if u find useful
thanks
Nagesh.Paruchuri
08-23-2007 10:13 AM
hi,
i dont want to delete,that i know,how to delete.
if someone has deleted the records,i want to know how he deleted,like by executing any report or manually they deleted....
08-23-2007 10:26 AM
whenever changes made to an object these changes are record into CDHDR and CDPOS tables by using these table u have to write simple program
reward if u find useful
thanks Nagesh.Paruchuri
08-23-2007 11:39 AM
Hi,
Let me know the following details :
1) Is it Ztable or SAP Standard table ?
2) Find out the table Technical settings whether Log data changes option is checked or not.
With regards,
K K V
08-23-2007 11:42 AM
08-23-2007 11:51 AM
Hi
Use Tcode : SCU3 Click button Evalute logs
Provide Table Name and from which data do u want to analyze the data and execute the report.
With regards,
K K V
08-28-2007 11:58 AM
hi,
For any of the tables its not displaying log.
for this i created a table with log error messages check box checked,i added records and deleted some of them.
still its not showing any of the logs.
08-29-2007 5:56 AM
Hi,
Please check the below link:
http://help.sap.com/saphelp_nw04/helpdata/en/7e/c81ebb52c511d182c50000e829fbfe/content.htm
Let me the know the T-Name .
Hope the information will helps you.
With regards,
K K V
08-29-2007 8:30 AM
Hi,
Make the settings as mentioned below.
SCU3 transaction is used to see the IMG change logs for modified objects.
If your table change log is not active, it will gives you a message that :-
...table logging is switched off
This particular setting can be changed in the following path :-
IMG> Basis Components> System Administration> Tables changes recording
With Regards,
K K V
08-29-2007 12:14 AM
Hi Prashanth..
you will get the details in CDHDR and CDPOS tables..
your table name will come in CDPOS-tabname and the record changed will come in CDPOS-objky.. you will get the details like who changed and when changed there.
Thanks and Best Regards,
Vikas Bittera.
**Points for useful answers**
01-10-2008 6:36 AM