HI,
We have a logic where data is selected from table CDHDR and this selected data is sorted in descending order on the basis of field CHANGENR and then we select the first record.
The aim here is to select the latest change record with the assumption that the latest change will be assigned the highest CHANGENR.
But we are encountering situations where the latest / highest change number is not being assigned to the latest change.
For example a user with userid ABC makes a change in a purchase order at 10:51 and is assigned a change no. 123. and then another user with userid XYZ makes a change in the same purchase order at 10:53 but has been assigned the change no. 122.
Please advice how a lowere change number is being assigned to the latest change.
Although I would like to mention this situation happens rarely but when it occurs, it does cause a lot of issues.
I hope I am clear.
Please advice.
Thanks and regards
Abhishek