Symptom
Issue in CDS view I_PURCHASEREQUISITIONITEMAPI01 that only latest purchase order is reflected instead of all purchase orders linked to a purchase requisition item.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Create a purchase requisition item.
- Create more than one purchase order with reference to the same purchase requisition item.
- Retrieve data using the CDS view I_PURCHASEREQUISITIONITEMAPI01.
- Observe that only the most recently created purchase order is returned for that requisition item.
Cause
Standard system behavior.
Resolution
- Note the limitation: I_PurchaseRequisitionItemAPI01 is Purchase Requisition–centric and returns only the latest purchase order created against a requisition item.
- Use the PO‑centric view I_PurchaseOrderItemAPI01 to retrieve the complete list of purchase orders associated with purchase requisitions.
- Adapt reporting or integrations to query I_PurchaseOrderItemAPI01 and select/filter by the purchase requisition reference to obtain all related purchase orders instead of relying on I_PurchaseRequisitionItemAPI01 for this purpose.
Keywords
I_PURCHASEREQUISITIONITEMAPI01, I_PurchaseRequisitionItemAPI01, I_PurchaseOrderItemAPI01, cds view, purchase requisition, purchase order, multiple POs, latest PO only, PR to PO linkage, PR-centric, PO-centric, reporting data completeness, operational procurement , KBA , MM-PUR-REQ-SSP-2CL , Fiori UI for Self Service Procurement (Public Cloud) , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public