Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 20, 2017 at 02:54 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded