on 06-14-2017 9:18 AM
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!
Tobias
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.