Skip to Content
Technical Articles
Author's profile photo Eileen Koehler

Build and import SAP HANA Views for Segmentation in Hybris Marketing Cloud

With Hybris Marketing Cloud you are able to import own SAP HANA Segmentation Views by using the SAP Fiori App “Add Custom View”. This blog will tell you which steps you need to carry out to build and import your own views using your own SAP HANA Database.


Prerequisite: SAP HANA Database with Schema ABAP

In order to build SAP HANA views for segmentation you need an SAP HANA Database with schema ABAP. You can create yourself a SAP HANA Database in your SAP HANA Cloud Platform (HCP). If you do not have puchased a licence, you can also use the Trial Account like used in this blog post. See blog post Setup of SAP HANA Database in SAP Hana Cloud Platform Trial Account to build Segmentation Views for Hybris Marketing Cloud on how to setup your SAP HCP account accordingly.


Prerequisite: SAP Fiori App “Add Custom Views”

SAP Hybris Marketing Cloud offers the SAP Fiori App “Add Custom Views”. The app is part of business catalog “Extensibility – Marketing” (SAP_CEC_BC_MKT_EXT_PC) and business role template “Administrator – Marketing” (BR_ADMINISTRATOR_MKT).


Prerequisite: SAP Standard Tables

You have already exported the SAP standard tables from your Hybris Marketing Cloud System and imported them into your SAP HANA Database as explained in blog post Export SAP HANA Views from Hybris Marketing Cloud


Create your own SAP HANA View and export SAP HANA Repository XML

  1. Create your own graphical calculation view in your SAP HANA Database on top of the ABAP tables or SAP delivered HANA views. Keep in mind the constraints for importing the SAP HANA View later on in S/4HANA Marketing Cloud./wp-content/uploads/2016/07/10_997369.jpg
  2. You have to export the repository XML of your SAP HANA view. To export the repository XML press the corresponding button in the right upper corner./wp-content/uploads/2016/07/11_997376.jpg
  3. On the upcoming popup press Save As and save the XML to your local machine:

Import your own SAP HANA View for Segmentation into SAP Hybris Marketing Cloud

  1. Open the app Add Custom Views.
  2. Select tab Import View.
  3. Select your repository XML and press Import View. /wp-content/uploads/2016/07/13_997378.jpg
  4. Your view is imported into an own folder under sap.hana-app.cuan.custm_seg.gen. You can now add the view to your segmentation.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Oliver Schultze
      Oliver Schultze

      Dear Eileen,

      thank you for this blog. We have exported a View that was created when creating a Custom Business Object. The export was done to change the labels of this view as only the ID appeared in Segmentation and no description.

      Now we would like to import this view again to overwrite the existing view. How this can be done?

      In the blog you have connected the yM Cloud to the SAP HANA Studio? Is this generally speaken possible? I was thinking that the views have to be exportet and imported without being able to directly connect the cloud system to SAP HANA Studio?


      Author's profile photo GOVINDA PARATE

      Hi Eileen,

      I'm getting below error while importing the calculation from HANA studio to Marketing Cloud.

      This is the calculation view I have created and trying to import

      Author's profile photo Eileen Koehler
      Eileen Koehler
      Blog Post Author

      Dear Govinda,

      please create a ticket on component CEC-MKT-EXT.

      Best regards,


      Author's profile photo Jef Op de Beeck
      Jef Op de Beeck

      Dear All,


      We are currently struggling to make our custom view available for segmentation.  We have already check our custom view multiple times and cannot find anything that is missing.

      Our use case is merging two datasources (CUAND_CE_IC_TM and our CBO YY1_****) we have identified our join attribute (EmployeeID) and joined both datasources. We use a left-outer and have already tried 1.1 and n.m cardinality.

      Our overall view looks as followed:



      However when we enable it for segmentation the attributes remain empty. Ff we create a CDS view we can see that the values are filled up and should be joined based on the employee ID.

      Any recommendations on what we should check?