Skip to Content

Create Service Consumption Model for Business Partner and Sales Order Item Cube

Requires Customer/Partner License
Intermediate
45 min.
SAP BTP, ABAP environment, Intermediate, Tutorial, ABAP Development, SAP Business Technology Platform
Create Service Consumption Model for Business Partner and Sales Order Item Cube.
You will learn
  • How to create destination
  • How to create service consumption model for business partner and sales order item cube
mervey45Merve TemelMarch 17, 2022
Created by
mervey45
July 23, 2019
Contributors
mervey45

Prerequisites

  • Step 1

    1. Log in to SAP S/4HANA Cloud system as administrator and select Communication Arrangement in the Communication Management section.

      Copying the inbound service URL

    2. Select the communication arrangement that you have created.

      Copying the inbound service URL

    3. Copy the business partner (A2X) URL for later use.

      Copying the inbound service URL
  • Step 2

    1. Log in to the SAP BTP cockpit and navigate to your subaccount. Select Destinations under Connectivity and create a new destination.

      Create destination with basic authentication

    2. Enter destination configuration:

      • Name: your destination name
      • Type: HTTP
      • Description: your description
      • URL: Service URL from communication arrangement ( Business Partner (A2CX) ODataV2 service URL)
      • (without /sap/opu/odata/sap/API_BUSINESS_PARTNER)
      • Proxy Type: Internet
      • Authentication: BasicAuthentication
      • User:
      • Password:
      Create destination with basic authentication

    3. Check connection.

      Create destination with basic authentication
  • Step 3

    1. Log in to your SAP S/4HANA Cloud system, navigate to Extensibility and open the Custom CDS Views tile.

      Create Custom CDS View in SAP S/4HANA Cloud

    2. Click Create to create your custom CDS view.

      Create Custom CDS View in SAP S/4HANA Cloud

    3. Name your CDS view YY1_SALESORDERITEMCUBEXXX and label. Select External API as scenario and click Create.

      Create Custom CDS View in SAP S/4HANA Cloud

    4. Search for I_SalesOrderItemCube and select it.

      Create Custom CDS View in SAP S/4HANA Cloud

    5. Click Add and select Associated Data Source.

      Create Custom CDS View in SAP S/4HANA Cloud

    6. Search for I_BusinessUser, select it and click OK.

      Create Custom CDS View in SAP S/4HANA Cloud

    7. Select the butterfly symbol to add a join condition.

      Create Custom CDS View in SAP S/4HANA Cloud

    8. Click Add.

      Create Custom CDS View in SAP S/4HANA Cloud

    9. Search for userid and select it.

      Create Custom CDS View in SAP S/4HANA Cloud

    10. Add a value to your join condition, therefore select the field symbol under Value.

      Create Custom CDS View in SAP S/4HANA Cloud

    11. Search for CreatedByUser under I_SalesOrderItemCube and select it.

      Create Custom CDS View in SAP S/4HANA Cloud

    12. Now your join condition is complete. Click Close.

      Create Custom CDS View in SAP S/4HANA Cloud

    13. Navigate to Parameters and add manual parameters for the exchange rate type and display currency.

      Create Custom CDS View in SAP S/4HANA Cloud

    14. Navigate to Elements, select Add > Elements.

      Create Custom CDS View in SAP S/4HANA Cloud

    15. Search for BusinessPartner, select it and click OK.

      Create Custom CDS View in SAP S/4HANA Cloud

    16. Add also the following elements to your CDS view:

      • SalesOrder
      • SalesOrderItem
      • CreationDate
      • NetAmountInDisplayCurrency
      • DisplayCurrency

    17. Check your result and click Publish.

      Create Custom CDS View in SAP S/4HANA Cloud
  • Step 4

    1. Navigate to Extensibility and select Custom Communication Scenarios.

      Create custom communication scenarios

    2. Click New.

      Create custom communication scenarios

    3. Create a communication scenario:

      • Communication Scenario ID: Salesorderitemcubexxx
      • Description: Sales order item cube

      Click New.

      Create custom communication scenarios

    4. Click + to add an inbound service.

      Create custom communication scenarios

    5. Search for YY1_SalesOrderItemCubeXXX, select it and click OK.

      Create custom communication scenarios

    6. Select your inbound service and click Publish.

      Create custom communication scenarios
  • Step 5

    1. Go to the SAP API Business Hub and select the OData service for business partner: (https://api.sap.com/api/API_BUSINESS_PARTNER/overview).

      Copy the production URL.

      Download metadata for business partner

    2. Now open a browser of your choice and past the production URL with your hostname and port.
      Add also $metadata at the end, like following:

      URL https://{host}:{port}/sap/opu/odata/sap/API_BUSINESS_PARTNER/$metadata

      Log in with you communication user and password to see your metadata.

      Download metadata for business partner

    3. You can see the metadata. Save your metadata as an edmx file.

      Create communication system

    4. Use bupa.edmx and select all files as file type.

      Download metadata for business partner
  • Step 6

    1. Switch to Eclipse an create a package:

      • Name: Z_Package_XXX
      • Description: My Package

      Click Next.

      Create service consumption model for business partner

    2. Click Next.

      Create service consumption model for business partner

    3. Click Finish.

      Create service consumption model for business partner

    4. Select File > New > Other…

      Create service consumption model for business partner

    5. Search Service Consumption Model, select it and click Next.

      Create service consumption model for business partner

    6. Create a service consumption model.

      • Name: Z_BUSINESSPARTNER_XXX
      • Description: Service Consumption Model for business partner

      Select your metadata bupa.edmx and click Next.

      Create service consumption model for business partner

    7. Click Next.

      Create service consumption model for business partner

    8. Click Next.

      Create service consumption model for business partner

    9. Click Finish.

      Create service consumption model for business partner

    10. Check your result.

      Create service consumption model for business partner
  • Step 7

    1. Open your SAP S/4HANA Cloud system and navigate to Communication Management and select Communication Arrangements.

      Create service consumption model for sales order item

    2. Search for your communication arrangement yy1_salesorderitemcubexxx and select it.

      Create service consumption model for sales order item

    3. Copy the service URL of your communication arrangement.

      Create service consumption model for sales order item

    4. Paste the copied service URL in your browser, add /$metadata at the end of your URL and log in with you communication user and password to see your metadata.

      Create service consumption model for sales order item

    5. You can see the metadata. Save your metadata as an edmx file.
      Use salesorder.edmx and select all files as file type.

      Create service consumption model for sales order item
      Create service consumption model for sales order item

    6. Go to Eclipse and select File > New > Other…

      Create service consumption model for sales order item

    7. Search Service Consumption Model, select it and click Next.

      Create service consumption model for sales order item

    8. Create a service consumption model.

      • Name: Z_SALESORDERITEMCUBE_XXX
      • Description: Service Consumption Model for SalesOrderItemCube

      Select your metadata salesorder.edmx and click Next.

      Create service consumption model for sales order item

    9. Click Next.

      Create service consumption model for sales order item

    10. Click Next.

      Create service consumption model for sales order item

    11. Click Finish.

      Create service consumption model for sales order item

    12. Check your result.

      Create service consumption model for sales order item
  • Step 8

    With which user do you logon to see your metadata

Back to Top
Back to top