deleting data based on date-range

[Former Member]

hi,

i want to erase all entries older than 2 months from database.

please do the needful.

[Former Member]

From all SAP tables? This is going to be fun... hope you already start looking for another job.

[Former Member]

i have to delete data from user created database table .

[ThomasZloch]

Better hand it over to somebody who knows what he is doing.

Thomas

[Former Member]

Hi

I assume you are trying to data from Z table

is yes

Data : temp_date type sy-datum.

temp_date = sy-datum - 60.

delete ztable where your date field < temp_date.

Regards

Madhan

[Former Member]

thanks for ur help !

[madan_ullasa]

Hi,

Hey you would not do that in production... Data are usually archived... not deleted.....

As for your sandbox ask your basis to do a system refresh...

regards,

Madan...