Dear Experts
I have a decision table where there are 2 fields "ValidTill" and "Status". "Status" can have values "Active" or "Inactive". "ValidTill" is a date.
Now we want "status" field to be auto-updated to "Inactive" if the "ValidTill" value is less than current system date.
How can we achieve this? Is there any BRF decision table setting to handle this?
Or do we need to create a separate ABAP background job(program) in SE38/SM37 to run once every day. This will check if any entry in the decision table has "ValidTill" value less than current system date then update "Status" value to "Inactive".
Please advise on the best approach.
Kindly help ASAP.
Thanks
Gopal