Skip to Content
avatar image
Former Member

How to use filter option in initial load for huge tables

Hi Gurus,

We are replicating from ECC to HANA with LTRS only initial load.

I encountered some problems, would need your expertise on this.

  • How we can use filter/selection criteria in table. example: KNB1, I want to send only for 5 company codes?
  • How we can change the target table name. like KNB1 should go to ZKNB1?
  • Can we use same DB user for replication to different schemas in same database?
  • How we can handle VBAP, BSEG like huge tables.

Regards

Brillion

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 07, 2016 at 10:59 PM

    How we can use filter/selection criteria in table. example: KNB1, I want to send only for 5 company codes?

    • If you only need for 5 company codes, then you can define the filter values in SLT for Init load.
    • When replicating you can either set filter on the trigger code directly or make the filter in SLT in an ABAP program.

    How we can handle VBAP, BSEG like huge tables.

    • Very large tables will work, you just have to use parallel load.
    • SLT can normally replicate around 4 million records per hour per table (by default, also stated by SAP). If you generate more records per hour you have to run in parallel.
    Add comment
    10|10000 characters needed characters exceeded