Question:
Hi,
The requirement is to delete the records from the SAP table CE41001_KENC, those records should be one month old. How to extract the records. [BISDAT date field doesn't match for this criteria]. Is it possible to do thorugh database utility.
This action should be able to perform every month.
Thanks in advance.
_________________
Venkat.
Chennai.
Answer:
unless you have a date in the table data itself I dont know of any way thru any other means other than:
Having a periodic run each month - dump the contents into another table. Then have a delete run that matches the records you have currently against your z tabel - delete the ones that match. Then you have everything but last months.