Re: deleting data based on date-range

Former Member · ‎2008 Oct 10

hi,

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

please do the needful.

Former Member · ‎2008 Oct 10

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

Former Member · ‎2008 Oct 10

i have to delete data from user created database table .

ThomasZloch · ‎2008 Oct 10

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

Thomas

Former Member · ‎2008 Oct 10

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 · ‎2008 Oct 10

thanks for ur help !

madan_ullasa · ‎2008 Oct 10

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

deleting data based on date-range