Skip to Content
avatar image
-1
Former Member

Time dependent Master data via History tables.

Hi All,

I was looking for the best way to capture historical data in HANA for master data tables without the VALID_TO and VALID_FROM fields.

From my understanding, we have 2 options here.

1. Create a custom history table and run a stored procedure that populates this history table from the original table. Here we compromise with the real-time reporting capability on top of this table.

2. Enable the History table flag in SLT for this table so that SLT creates this as a history table which solves this problem.

Option 2 looks like a clear winner to me but I would like your thoughts on this as well.

Let me know.

Thanks,

Shyam

Add comment
10|10000 characters needed characters exceeded

  • When you invest the effort and do some search for 'history table' here on SCN you should find some rather elaborate discussion and the answer to why option 2) is not a great idea at all.

  • Get RSS Feed

0 Answers