Skip to Content
0
Former Member
Mar 24, 2009 at 08:44 AM

Need help for record deletion from custom table

200 Views

Hi friends

I have to write a custom program which will be generic to delete any table record with date field.

This program needs to be generic (should be able to delete records from any custom table) in nature with selection screen parameters as:

Table Name and Number of Days prior to which records are deleted, both mandatory.

Program Flow:

1. From number of days calculate date before which records are deleted, ( current date u2013 no. of days = past date).

2. Custom table have date field, delete records prior to that date.

3. Program may be scheduled for background job, put default values for both fields. No. of days should not be less than 60.

4. Classical Report output with number of records deleted.

My query is how will I know the name of the Date field so that I can write a DELETE query.

If I use 'DDIF_FIELDINFO_GET' it gives me all field names but how to filter out?

with regards

samikhya