Skip to Content
Jun 28, 2019 at 01:03 PM

Bex query to display maximum date


Hi All,

I have PO,PO items,delivery date and quantity on the PO cube. I have created a infoset between the sales cube and PO Cube based on material & plant combination. So I need to display sales order information along with PO information, but here i need to display the order qty & open qty.

The real issue is i need to display only the oldest delivery date on this combination, despite of having multiple PO & items. Someone kindly help me on this ?