SAP Knowledge Base Article - Public

3536295 - Retrieving Multiple Addresses of Business Partners via CDS View in SAP S/4HANA Cloud Public Edition

Symptom

  • The issue arises when attempting to retrieve multiple addresses of a Business Partner via the CDS view in SAP S/4HANA Cloud Public Edition.
  • The CDS view I_supplier only provides one address at a time based on current validity.
  • No standard CDS view is available to fetch multiple addresses of a Business Partner.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Maintain multiple addresses and email in the "Maintain Business Partner" app.
  2. Attempt to retrieve multiple addresses using the CDS view I_supplier.

Cause

Resolution

  1. There is no standard CDS view to fetch all addresses associated with a Business Partner.
  2. Create a custom CDS view using the Custom CDS Views app (App ID F1866).
  3. Use the released CDS view I_BUSPARTADDRESS to retrieve the addressID for each of the Business Partner's addresses.
  4. Use the released CDS view I_Address_2 to get detailed information for each address using the addressID obtained in the previous step.

See Also

Keywords

CDS view, I_supplier, multiple addresses, Business Partner, SAP S/4HANA Cloud Public Edition, I_BUSPARTADDRESS, I_Address_2, Custom CDS Views app, addressID. , KBA , LO-MD-BP-2CL , Business Partners for Public Cloud , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions