Skip to Content
avatar image
Former Member

Integration between SAP CRM and SAP yMKT on premise

Hello!

We have some problems with integration between SAP CRM (EHP4 FOR SAP CRM 7.0) and SAP yMKT on premise (1702).

Our deployment scenario C - Reuse of Original Suite Schema (SAP CRM and yMKT use the same sap hana database), but both SAP CRM and yMKT have based on separlty database instances (different tenant databases).

First when we ran CRM integration configuration (tcode CUAN_TECHNICAL_CONF) we have choosed SAP_CUAN_CRM shema. In this case configuration was have succesful finished but the after executing CUAN_IC_MASTERDATA_EXTR_FULL we recieved logs "No have rows for export" we check list of schema on CRM database - SAP_CUAN_CRM schema is missing. All needed tables belong to SAPABAP1 schema of SAP CRM.

We have tried change "SAP CRM Schema" parameter on first step of CRM integration configuration to SAPABAP1 but the erroros have occured. System can not find needed crm tables and "freezes" on step "Reactivate SAP HANA Content".

So please advice me whats wrong, why in our case the integration doesn`t work?

Thank you in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Nov 24, 2017 at 03:15 PM

    Hello Petr,

    scenario C refers to a single tenant database, that is the schema of the hybris marketing system and the CRM and/or ERP system schema have to be in the same tenant database of the Hana multitenant database installation.

    So if you do in the tenant db:

    select * from schemas 

    you will see as result the schema of the erp/crm and hybris marketing.

    What you refer to would mean cross tenant database access (from hybris tenant to crm tenant). This is feasible for hana tenant databases in general, but hybris marketing hana content does not support it fully. This is also mentioned in the landscape recommentations, currently can be found under (link might move in future) https://eaexplorer.hana.ondemand.com/rest/mimeRepositories/11191/file/LandscapeRecommendations_SAP_hybris_Marketing_2016.pdf

    See explicitely the statements on slide 15:

    • SAP HANA system shared with any other application
    • Co-deployment on SAP HANA via MDC installation
    • Replication of CRM, ERP or S/4HANA data into additional database schema still required, since direct data access across tenant databases so far restricted (only supported for calculation views)
    • Additional SLT system for replication required

    So this explains probably your observations. You have to make sure that the crm schema is avaliable physically in the hybris marketing tenant. This can be achieved via replication or via shared tenant database for crm and hybris (MCOD installation),

    Best regards, Sophie.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2017 at 06:37 PM

    Hi Petr,

    It sounds like a schema mapping problem to me. You can open up a ticket to SAP Support.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2017 at 07:10 PM

    Hi Petr,

    You are using scenario C from the installation guide and in this all you have to do is schema mapping so that hybris can read all the relevant data from CRM system in real time.

    1. schema mapping is just few min task and done using HANA studio

    2. by doing schema mapping in HANA, yMKT gets access to all the relevant data in CRM. SAP_CUAN_CRM could the schema name that you need to map.

    Br,

    Keshav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2017 at 07:24 AM

    Hi! Thanks for your response.

    But i still would like know when saying about using one Hana database by both SAP CRM and yMKT. this is meant that both system have installed on the same database instance or not?

    May be do you know, Keshav?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 01:38 PM

    Hi Petr,

    As per my knowledge,

    The ERP database HED, CRM database HCD and Hybris datbase HYD all are installed as individual Multitenant database on the same Hana System database.

    any way I will check with Basis team & get back to you !

    Br,

    Keshav

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you very much!

      As i can see my problem is in another area perhaps.

      But if load st04 t-code from SAP CRM. In this transaction choose Diagnostics - Table/Views, after that put 'but000' in Table/View and push 'display' button. Which shemas will be shown for this table in your SAP CRM?

      In my SAP CRM this table belongs to SAPABAP1 schema only, but as i see SAP_CUAN_CRM schema has to has this table in such variant implementation.

      In any case i`m waiting for your response after check with basis team.