Skip to Content
1
Former Member
Feb 27, 2009 at 04:53 PM

Data in CDHDR

205 Views

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