We have a client requirement in SRM4.0, to write a report which will give PO items which have crossed the delivery date and for which Goods Receipt (Confirmation) has not been done. I was thinking of using the following logic.
Query table BBP_PDIGP where deliv_date for PO item = sytem date - 1. Get the GUID for all items where deliv_date = systemdate - 1. Then check for all these items whether Goods receipt has been done.
My question is that if I have the PO item GUID, how do I check whether Goods Receipt (confirmation) has been done for that item? Are there any function modules that will help?