on 09-01-2015 11:51 AM
Hello Experts,
We want to transfer ERP ZTable data into existing ZTable of HANA system using SLT.
We have created new configuration in SLT for SAP HANA system. In this configuration we are mapping to existing schema where Ztable is already present. We are able to create configuration by mapping to existing schema rather than creating new schema in HANA system.
But the problem is that when we do data provisioning it creates new table in that schema.
Is there any way where we can update target system existing table data rather than creating new table at first data load or replication?
Thanks,
Shweta.
Hi Shweta, from your explanation your only requirement is that you don't want to drop and recreate the table but instead do the initial load and start replication.
Try using this approach and using the options. The key here is to set the REFRESH_BEHAVIOR column appropriately.
SLT behaviour for target table in case of reload
(space/D = Drop Table, T = Truncate Table, N = Keep Table
insert into "SCHEMA"."RS_ORDER" values('SID','HOST','ZTABLE',0,'R','','N','E')
Happy HANA,
Justin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shweta,
Can you load the custom z-table into Hana system and start replication process from hana?
Regards,
Antony Jerald.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Antony,
Thanks for your reply.
We want to replicate data into existing table which we have created manually in HANA table.
SLT replication is creating new table in HANA schema. As we have already used existing table in many of the views,thus wanted to have data replication in existing table rather than creating new table.
Thanks,
Shweta
Hi Shweta,
Plz check if the following link is useful for you:
http://help.sap.com/saphelp_hanaplatform/helpdata/en/6f/e33dcd1abd45cdaf22fb2f60942190/content.htm
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.