Skip to Content
avatar image
Former Member

Alter table after it is replicated in HANA

Hi,

I wanted it check if we can alter a table (add a column in SLT) that has already been replicated in HANA? Do I need to drop the table and reload it if I want to populate this additional column for existing records?

e.g - BKPF (115 columns)

Need to add Fiscal year period column (concat GJAHR and MONAT) in SLT. Also need to populate this field for all the existing records and not only for new records that flow in after the creation of this column.

Thanks

Sameer

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2015 at 09:44 AM

    Hi Sameer,

    The short answer is RELOAD. Stop replication on the table which will then drop the triggers/log tables, then start replication for BKPF again. This will drop the HANA table and data and then recreate the 'new structure' and populate data. The SLT can cope with structural changes without the need to reload (there are notes and documentation around this), but given that you are adding GJAHR which is a key field on BKPF then a reload is the cleanest.

    Hope this helps,

    Kris

    Add comment
    10|10000 characters needed characters exceeded