View for company code, BP address data so these details can be used on output form?

[former_member133235]

Seems CDS view related to address are 'not released'. Are there any view or other way get the company code, BP address data? This needs to be printed on the form.

Does anyone has similar requirement? Any suggestions?

[Stephen_Ward · Accepted solution]

Hello There,

That you for your question and apologies that it has been unanswered for some time.

For fetching Customer and Supplier Company Code data you can utilize the CDS View's I_CUSTOMERCOMPANY and I_SUPPLIERCOMPANY respectively.

For fetching address data you can use the I_CUSTOMER, I_SUPPLIER and I_BUSINESSPARTNER CDS views to get some of the most commonly required address fields.

However, a substantial amount of the Business Partner address data comes form the I_ADDRESS CDS view. Our development teams have looked into the possibility of releasing this CDS view and it will never be released to customers due to some security concerns around the CDS view.

To access these fields you can create your CDS view with the fields you require. Here is a great blog on how to create custom CDS views https://blogs.sap.com/2018/01/23/create-cds-views-in-sap-s4hana-cloud-and-consume-them-as-apis/

Alternatively, you can make use of OData service API_BUSINESS_PARTNER by making use of the A_BusinessPartnerAddress entity set.

This KBA 2810992 - S4HC: CDS View is not available for Business Partner E-mail Address provides an example of how to use this method to fetch the E-Mail address of a Business Partner.

https://launchpad.support.sap.com/#/notes/2810992

Kind Regards,

Stephen

[former_member728618 · Accepted solution]

Hello Stephen,

Firstly sorry for re-opening an old thread.

I need above fields(Ex: Email Id) in my Analytical Query, since I_Address is not released so we cant create Custom CDS View on top of it, so how do we use API (API_BUSINESS_PARTNER) to fetch data for my reporting in S4HC ?

Regards,

Ankit

[Varun_Agarwal]

Hi Ankit,

Please refer to SAP Knowledge Base Article 2810992 - S/4HC: CDS View is not available for Business Partner E-mail Address which will explain you how to use API_BUSINESS_PARTNER to fetch E-Mail ID.


Regards,
Varun

[Stephen_Ward]

Good Morning Virendra,

Your new query would represent a feature request to release these CDS views. We have the SAP Customer Influence channel for feature requests where SAP offers an opportunity for SAP S/4HANA Cloud customers to submit improvement requests.

1.Get started by opening SAP Customer Influence for Master Data topics in SAP S/4HANA Cloud https://influence.sap.com/sap/ino/#/campaign/1713

2. Register and accept the Terms of Use

3. Choose a session of your interest

4. Create and submit your improvement request

5. Take a look at existing improvement requests and start voting and commenting

Please take a look at the User Guide Documentation for a detailed description of SAP Customer Influence. https://help.sap.com/doc/378cd4d4fb064eddada42046bbda9c45/1/en-US/S4HC_CustInfl_Docu.pdf

Kind Regards,

Stephen

[virendra80]

I_BusinessPartner,

I_SuplrBankDetailsByIntId

I_SupplierCompany

I_Supplier

You can request below views also to release:

- I_BusinessPartnerAddress

- A_BusinessPartnerAddress

- I_BusinessPartnerAddressTP

- C_BusinessPartnerAddress

- I_BusinessPartnerDefaultAddr

- FAC_DART_Z3_S_BP_ADDRESS

- A_BuPaIndustry

- I_BusinessPartnerIndustry

- I_BuPaIdentificationTP

- C_BuPaIdentification

- A_BuPaIdentification

- I_BuPaIdentificationType

- I_BPIdentificationTypeText