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 ?