Skip to Content
0

how to select specific fields from a ECC table thru SLT replication to HANA ?

Dec 24, 2016 at 10:24 AM

325

avatar image

Can we select only few fields instead of complete table from ECC to HANA replication through SLT. Adding to this we need only data from 2015 june instead of complete history. Will the real time replication work on few field selection and date criteria ? Please advise any document or blog for the same. Is the date field mandatory in the ECC table ? Do we need to handle this through an ABAP program in SLT box or through a stored procedure in HANA studio ? Please advise. Appreciate it.

Thank You

/DR

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Leo Frederiksen Feb 20, 2017 at 02:54 AM
0

Hi

In SLT you can define a structure as a template for your target table in HANA, thereby only transferring the required fields. In SLT you can in LTRS also hide the fields you don't want, I prefer using a structure as the target will not change if new fields are added to the source.

In LTRS you can also define filters (Performance option), and here for you initial load only define to load data newer than 2015.

Share
10 |10000 characters needed characters left characters exceeded