Using SLT Server how can we replicate only metadata from ECC to HANA Database

[Former Member]

Hi All,

For HANA LIVE installation we need to replicate only the metadata from the ECC Server to SAP HANA Database using the SLT Server in Real Time Replication. After the metadata is replicated only the data for the tables which is required will be replicated.

What are the steps to replicate only the metadata to HANA Database.

Other than the option:

1. You can create the structure manually into SAP HANA same as MARA.

2. You can load the table into HANA thorugh SLT then after that you can delete the data and only structure is left behind.

Please help..

[Former Member]

Hi,

DMIS 2011 SP06 will do this for you as there is an option to replicate just the table definition (LTRC - Data Provisioning). Else follow the advice from Srinivas.

Cheers

Kris

[SK-EA]

Kavita,

Following OSS note 1799313, all the required tables for SAP HANA Live implementation can be setup in SAP HANA database using the SQL commands. The parameter T in the below command will only setup the table definition without loading any data into the SAP HANA database schema configured for the data replication.

INSERT INTO "ECCSCHEMA"."RS_ORDER" VALUES ('<SID>','<ECC_CI_Instance>','TABxyz',0,'T','','','');

Other possible action parameters

The above SQL commands can be easily generated using the excel file attached to the above OSS notes. Later data can be populated into the required tables using the Data Provisioning UI in SAP HANA Studio.

Hope it helps.

Regards,

Srinivas K.