How to Replicate T009 and T009B Tables before Creating Time Attribute?

Updated May 18, 2018

Hello Experts,

In SAP HANA, all the standard Attr views of tables are maintained in _SYS_BIC schema. If we create Time Attr view, then it maintained in _SYS_BI.

Then my question is, what are those T009 and T009B tables? and what is the need to replicate them before we create Time Attribute ?

Can anyone please let me know the answer.

Comments

12 Jan 2016 6:44 pm Romil Tripathi Helpful Answer

In case of time data, the data is maintained in certain tables for fiscal year periods and fiscal variants as per individual fiscal calendar. i.e.: T009 , table will store fiscal year periods and variant combinations for company. So, to use in HANA, we have to replicate this table to use the same values within HANA.