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
559

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.

Accepted Solutions (1)

Accepted Solutions (1)

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

Answers (1)

Answers (1)

Former Member
0 Kudos

You may try simple straightforward filters this using transaction: iuuc_repl_content. Check the following note: section 5.3.3.1 Includes, and Lines of Code  of the attached PDF in the note

1733714 - Guide for Advanced Replication Settings

biswamber_swain
Explorer
0 Kudos

Thanks Nehal for your reply.

My SLT system is on SLT 2.0 - SP7 - DMIS_2011_1_731.

I think the guide in the note is for earlier version of SLT.

So if you can tell me how to create a line of code filter that would be really helpful.