Can the data of a Table be replicated to HANA in SLT starting from a certain time in the past to till date rather than all historical data?

[biswamber_swain]

Can the data of a Table be replicated to HANA in SLT starting from a certain time in the past to till date rather than all historical data? The table data I want to replicate are MSEG & MKPF. I need the data for last 2 years from now.

[ragavendiran_s2 · Accepted solution]

Hi,

You have to do transformation before migrating the data to HANA

1.Go TCode: LTRS

2.choose your configuration

3.Right click on rule assignment and add your table

4.then you have create event based rule(begin of processing) and set filter year on table field

5. for example  MJAHR < 2013 "Template

6.finally you have to release your rule.

[biswamber_swain · Accepted solution]

Thanks !!!

Out of the below steps I am not clear on some steps highlighted below. Could you please describe those steps in details.

1.Go TCode: LTRS

2.choose your configuration

3.Right click on rule assignment and add your table

4.then you have create event based rule(begin of processing) and set filter year on table field -How to set the filter year.

5. for example  MJAHR < 2013 "Template - Could you please mention where I need to put this value.

6.finally you have to release your rule.

And is it possible to put multiple value filter on a single table field?

e.g. BWART = 251 & BWART = 601 & BWART = 101.

Thanks,

Biswamber