3633015 - Retrieving Delivery Address Details for Purchase Order Items Using CDS View I_PurchaseOrderItemAPI01

• The CDS view I_PurchaseOrderItemAPI01 does not return delivery address details.
• Business users are entering delivery address details manually per purchase order item. Guidance is requested on how to programmatically retrieve this data.

SAP S/4HANA Cloud Public Edition

This is a custom reporting requirement. The standard CDS view I_PurchaseOrderItemAPI01 does not directly expose full delivery address information. Instead, it provides an address ID that must be used to retrieve complete address details through another CDS view.

To retrieve delivery address details for Purchase Order (PO) items, follow the steps below:

1. Identify Address ID: Use the field ManualDeliveryAddressID (if populated) or DeliveryAddressID from the CDS view I_PurchaseOrderItemAPI01 to retrieve the associated address identifier.

2. Query Address Details:

• • Use the released CDS view I_Address_2 to retrieve full address details such as:
    • Street
    • City
    • Postal Code
    • Country
  • Apply a filter using the Address ID obtained in step 1.

Note : Supplier Address (Optional)- If the delivery address is the supplier’s default address refer to I_BUSPARTADDRESS or I_supplier.

Best Practice Reminder:

• When building custom reports, follow naming conventions and semantic tagging standards.
• Consider performance and data privacy when joining address-related CDS views.

• For similar information can also refer to KBA 3536295 - Retrieving Multiple Addresses of Business Partners via CDS View in SAP S/4HANA Cloud Public Edition .
• For Information related to CDS Views can refer to - SAP Business Accelerator Hub. 

cds view, I_PurchaseOrderItemAPI01, delivery address, ManualDeliveryAddressID, I_Address_2, addressID, purchase order, supplier ID, business partner, Fiori PO, public cloud, custom reporting, SAP API Hub , KBA , MM-FIO-PUR-PO-2CL , Fiori UI for Purchase Orders (Public Cloud) , How To