Alter table after it is replicated in HANA

[Former Member]

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

[Former Member · Accepted solution]

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