SAP Knowledge Base Article - Public

2810992 - S/4HC: CDS View is not available for Business Partner E-mail Address

Symptom

  1. There is no CDS view available to fetch the E-Mail address of a Business Partner.
  2. For Business Partner with role supplier or customer, Fax and Email information can be maintained in the App Manage Supplier Master Data or App Manage Customer Master Data, but in the CDS view I_Supplier or I_Customer, there is only the Fax Number field and no E-mail field.

Environment

 SAP S/4HANA Cloud

Cause

I_BusinessPartner, I_Supplier or I_Customer view does not have E-mail address attribute as it is part of another segment (Address). Hence it is not possible to extend the view with E-mail attribute.

Resolution

In the current release of SAP S/4HANA Cloud, there is no CDS View available which allows to fetch Business Partner E-mail Address.

Workaround: Batch request with OData service API_BUSINESS_PARTNER can be used to get the required information.

OData URI - [Host address]/sap/opu/odata/SAP/API_BUSINESS_PARTNER/$batch

Service need to be called 2 times- First Call is to get address number for the business partner and second call is to get address details(including E-mail) by passing Business Partner & Address Number.

1st Call

Content-Type: application/http
Content-Transfer-Encoding: binary

GET A_BusinessPartner(BusinessPartner='')/to_BusinessPartnerAddress.


2nd Call

Content-Type: application/http
Content-Transfer-Encoding: binary

GET A_BusinessPartnerAddress(BusinessPartner='',AddressID='Number got from 1st call')/to_EmailAddress

Keywords

S4_PC, S/4HANA Cloud, cloud, e-mail, supplier, vendor, customer, bp, core data services, business, partner, BP, mail, email, I_BusinessPartner, I_Supplier, I_Customer, A_BusinessPartnerAddress, A_BusinessPartner , KBA , api_business_partner , addressid , emailaddress , businesspartneraddress , businesspartner , business partner , LO-MD-BP , Business Partners , BC-SRV-ADR , Address Management / Business Address Services , Problem

Product

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