finding the latest Purchase orders

[fishmanl]

Hi 

I have the following scenario:

i have a fact table which has, the following fields:

ItemCode, SupplierCode, DocDate, PurchDocNum, ObjType (has 2 types: 103 and 101 for each PurchDocNum)

my mission is to Flag each combination of: ItemCode&SupplierCode  in PurchDocNum when ObjType =103 

that have combination on ItemCode&SupplierCode when ObjType =101  in a date greater than the date is when  ObjType =103

i atteached csv copy of the data

thank you!

[Saravanan_Desingh]

Can you explain with an example? Sorry I could not understand.

[fishmanl]

I manged to do it, Thank you