topic Re: deleting data based on date-range in Application Development and Automation Discussions

deleting data based on date-range

Former Member — Fri, 10 Oct 2008 07:57:02 GMT

hi,

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

please do the needful.

Former Member — Fri, 10 Oct 2008 07:58:56 GMT

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

Former Member — Fri, 10 Oct 2008 08:01:00 GMT

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

madan_ullasa — Fri, 10 Oct 2008 08:01:51 GMT

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

Former Member — Fri, 10 Oct 2008 08:02:28 GMT

i have to delete data from user created database table .

ThomasZloch — Fri, 10 Oct 2008 08:07:45 GMT

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

Thomas

Former Member — Fri, 10 Oct 2008 08:41:50 GMT

thanks for ur help !