Skip to Content

Create Triggers for Hybris Marketing (missing Authorization?)

Dear all,

I'm working on an Hybris Marketing on-prem scenario (B). My data from the ERP source system is replicated correctly to the HANA DB by the SLT. I can find the replicated tables in the SAP_CUAN_ERP schema.

The problem is, that Hybris Marketing (e.g. the contacts app) is not using these tables from the SAP_CUAN_ERP schema but the table CUAND_CE_IC_ROOT. I think that's the reason why the changed ERP data is not shown in the frontend of yMkt.

So my understanding is that there have to be triggers in the SAP_CUAN_ERP schema that bring the replicated data from the tables in the SAP_CUAN_ERP schema into the table CUAND_CE_IC_ROOT in the other schema. I think this is done by the ABAP Report CUAN_IC_MASTERDATA_EXTR_DELT.

Is my understanding of that logic correct? If it is, I'm missing the triggers. This would explain why the "Triggers" folder in HANA Studio is empty.

There is a description in the SAP OSS 2144527 of how to create these triggers using the methode CREATE_TRIGGER in the SE24. Trying that I get the message:

So it seems like there are some authorizations missing in the HANA DB?

That's why I activated the SQL Trace in HANA Studio and executed the CREATE_TRIGGER method again. I stopped the trace and had a look into the trace file. But in the file there is nothing about "create trigger" or "sap_cuan_erp" or something like this.

Does anybody know how to deal with that? Is there a special role or authorization that I need? Is there a misunderstanding of the logic?

I know that there is a possibility to manually create triggers in HANA Studio. But therefore I need to know the exact structure of the missing triggers, but I don't know if/where to find..

I hope someone can help me.

Thanks in advance!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers