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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

deleting data based on date-range

Former Member

‎10-10-2008 8:57 AM

0 Kudos

hi,

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

please do the needful.

6 REPLIES 6

Former Member

‎10-10-2008 8:58 AM

0 Kudos

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

Former Member
In response to Former Member

‎10-10-2008 9:02 AM

0 Kudos

i have to delete data from user created database table .

ThomasZloch
Active Contributor
In response to Former Member

‎10-10-2008 9:07 AM

0 Kudos

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

Thomas

Former Member

‎10-10-2008 9:01 AM

0 Kudos

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
In response to Former Member

‎10-10-2008 9:41 AM

0 Kudos

thanks for ur help !

madan_ullasa
Contributor

‎10-10-2008 9:01 AM

0 Kudos

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