End Routine Fetching Wrong value

[abhijit_bhi]

Dear All,

Please fine the scenarios

I have two ADSOs

ADSO1- contains Transitions data ,which is coming from APD based Direct Update DSO, the data consist of Material, Plant, Batch etc.

ADSO2 - contains master data related to Material, Plant, Batch, Char, Value1 and Value2

If you see, it is showing two values for same Material, Plant and Batch combination for Char.

ADSO2 contains huge data like in 102 Million

Expected Result is

We have written the End routine between Direct update DSO and ADSO1 which lookup the data for Material Plant and batch from ADSO2, the logic works fine if the data is less ,but it is showing wrong value for Value 1, if it considers 102 Million records, please let me know how can we handle this

Thanks and Regards,

AB