cancel
Showing results for 
Search instead for 
Did you mean: 

How to replicate ERP Ztable data into HANA existing Ztable using SLT?

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

justin_molenaur2
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Shweta,

Can you load the custom z-table into Hana system and start replication process from hana?

Regards,

Antony Jerald.

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

So far how are you loading data into existing custom table?  Through file upload?

I would suggest create a procedure that would fetch data from erp table and push it to existing table.

Regards,

Antony Jerald.

Former Member
0 Kudos

Hi,

Loaded data through Flat file. Procedure to read and insert will consume more time. We want to test HANA capability how fast its performing complex calculation once data is available in HANA Table.

Thanks,

Shweta

Former Member
0 Kudos