Skip to Content
0
Jan 10, 2023 at 10:48 AM

How to auto update BRF decision table column value? Kindly help ASAP.

126 Views Last edit Jan 10, 2023 at 12:05 PM 2 rev

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