Custom CDS view Partner OrganizationName1 display

[ISoma]

Hi Expert！

I am creating a Custom CDS view for Service Contract in Scenario: “Analytical Cube”.

I added a Partner Function to the Service Contract.
(Partner Function name Japanese”納入先"　Alias:YY1_ZIS_CUSTOM8_SRI)

I want to display address information such as "Name1" for the added Partner Function on CDSView.
Can someone please tell me how to do this?

Soma

[IreneLiu]

Hi Soma, I have contacted potential experts on this area so that they can come back to you with further information. Best regards, Irene

[Chris1973]

Hello @ISoma 

Following up on your question regarding the inclusion of Ship-To partner address details for example Name1, street and city into your Custom CDS View for Service Contracts, here is the recommended approach for SAP S/4HANA Public Cloud.

1. First is the Base Data Source. Continue using your service contract interface view as the primary source.
2. The next thing is to join to Service Contract Partners

• Add an association to I_ServiceContractPartner.
• Join on ServiceContract = ServiceContract.
• You need to expose BusinessPartner (Ship-To BP), AddressID (if maintained) and PartnerFunction (to filter Ship-To, typically function code = WE).

1. Therafter you should join to Business Partner, add an association to I_BusinessPartner, Join on BusinessPartner = ShipToBP. Then expose, organizationBPName1 (maps to the classic Name1 field). Optionally you can also expose, OrganizationBPName2 and BusinessPartnerFullName.
2. Then join to Business Partner Address

• Add an association to I_BusinessPartnerAddress.
• Join on BusinessPartner = ShipToBP and AddressID = ShipToAddressID.
• Expose:
• StreetName, CityName, PostalCode, Country, and any other needed address attributes.
• If no AddressID is stored, you can fall back to the standard address by joining only on BusinessPartner and filtering IsStandardAddress = 'X'.

1. Here are some analytical considerations to make

• Mark address and name fields as attributes rather than measures.
• Keep associations as LEFT OUTER joins so that contracts without a Ship-To partner still appear in analytics.
• If you need a reporting layer, create a consumption CDS view on top and expose the same attributes.

To summarise, by combining the three released interface views (I_ServiceContractPartner, I_BusinessPartner, and I_BusinessPartnerAddress), you can safely expose Ship-To partner name and address information in your Service Contract analytical cube. This method is fully compatible with Public Cloud extensibility and upgrade safe.

I hope this provides the desired result. Happy to answer any further questions.

Best regards

Chris