SAP Knowledge Base Article - Public

2810992 - S4HC: 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

Currently there is no view which will provide Business Partner E-mail address.

The alternative is to use OData batch to get the required information.

OData URl - [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, 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 , LO-MD-BP , Business Partners , BC-SRV-ADR , Address Management / Business Address Services , Problem

Product

SAP S/4HANA Cloud all versions