Hi Experts !!
In SAP QUERY I am getting the PO with all delivey dates & deliveried Qty but I have to select only single PO with latest delivery date & qty. If there r more than one record for latest delivery date than deliveried QTY must be sum of all QTY (for the latest delivery date). for example :
this is coming
Po delivery date qty
10001 30.06.2009 4
10001 30.06.2009 5
10001 01.05.2009 4
we want
Po delivery date qty
10001 30.06.2009 9
Thanks in advance.
Thanks & Regards
Navneet Singhal