AR Tables and scripts in ODS

[Nikhil_Makhija]

Hello everyone,

Need some guidance on below points:

1. Are there any standard scripts available to archive the AR_ table data from the ODS(if it has grown too big) ,I know there are 2 scripts available which talks about deleting the WIP and ODS data after defined # of days ? We need AR_tables data for long term and don't want to delete at this point.

2. How do I access JAVA code running behind the ETL scripts to know more about extraction logic i.e. ODSProductionETL,ODSGenealogyETL ?

Thanks for your inputs.

Nikhil

[sergiy_katerinich]

Hi!

1. AR_* and AL_* tables are not touched by "A g i n g" scripts. They delete records from some tables in WIP DB and from ODS_* tables from ODS DB. Please check ODS Setup How-To Guide on help.sap.com/me.

2. Does it mean you already have access to the rest of Java code of SAP ME? 😉

Regards,

Sergiy

[Nikhil_Makhija]

Thanks Sergiy for responding.

1. Does that mean there is no standard script exist to archive AR_tables and a custom solution to be built for archiving the AR_* tables?

2. No 🙂 courtesy SAP , looking for a way to see what is going behind the ETL script as we are seeing some delay in replication to ODS tables and it will help to see what is causing this as extract dates were current per table ODS_EXTRACT_CONTROL_DATE until few day ago.

Thanks!

[sergiy_katerinich]

1. You are talking about super-archiving feature. There is no such out of the box. On the same help page, there is Best Practices Guide where some approach is suggested.

2. Check ODSLog.txt for any error. Enabling SQL trace for ODS might help - SAP Note 1289112.