SAP Knowledge Base Article - Public

3730637 - I_PURCHASEREQUISITIONITEMAPI01 CDS view shows only latest Purchase order for a PR item in SAP S/4HANA Cloud Public Edition

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

  1. Create a purchase requisition item.
  2. Create more than one purchase order with reference to the same purchase requisition item.
  3. Retrieve data using the CDS view I_PURCHASEREQUISITIONITEMAPI01.
  4. Observe that only the most recently created purchase order is returned for that requisition item.

Cause

Standard system behavior.

Resolution

  1. Note the limitation: I_PurchaseRequisitionItemAPI01 is Purchase Requisition–centric and returns only the latest purchase order created against a requisition item.
  2. Use the PO‑centric view I_PurchaseOrderItemAPI01 to retrieve the complete list of purchase orders associated with purchase requisitions.
  3. 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