Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

records deletion

Former Member
0 Kudos

Is there any way that we can find how the records are deleted,like by execution of any report or manually.

11 REPLIES 11

paruchuri_nagesh
Active Contributor
0 Kudos

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

0 Kudos

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....

0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

it is T table and the log data changes option is checked.

0 Kudos

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

0 Kudos

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.

0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

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**

Former Member
0 Kudos

thanks