cancel
Showing results for 
Search instead for 
Did you mean: 

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
Explorer
0 Kudos
544

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.

View Entire Topic
ragavendiran_s2
Explorer
0 Kudos

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
Explorer
0 Kudos

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