Skip to Content
avatar image
Former Member

Data retention in SLT system

Hi All,

Currently we have a couple of ECC tables replicated to SLT server.

So for Ex: if the ECC table has 10 years of data then the same data would be available in SLT along with the new data.Now due to this we have a memory issue.

Trying to find put if we can delete the data in SLT and retain only 3 years data. But in ECC it should have 10 years data only. Can this be achieved if so can you please let me know the steps.

Alternatively how can we load only 3 years data into SLT.

Thanks in Advance.

Regards,

Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 08, 2017 at 05:44 PM

    Hi Hari,

    In SLT system , please use t-code LTRS and select for config. Once this is done go to Performance Options in Advanced Replication Settings Folder. Right Click add your table. Next you are have to specify the filters on Year field of your table. You have to do this for Intial load as well as for the replication (delta). Save the settings. Hope this will help you.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Pandey,

      Thanks your reply. I tried to replicated the above steps but I am not sure how to specify the filters on year field for the new table. Can you please provide the steps for the same.

      Regards,

      Harish

  • avatar image
    Former Member
    Mar 08, 2017 at 06:38 AM

    Hey ,

    Check below link where Aditya suggested a workaround

    https://archive.sap.com/discussions/thread/3343753

    thanks,

    Saikrishna

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2017 at 09:37 AM

    Hello,

    you can also refer to -

    https://www.youtube.com/watch?v=sqfsGkQ2TzQ

    Add comment
    10|10000 characters needed characters exceeded