HANA Custom Accelerator

[former_member196555]

Hi Colleagues,

We are configuring the custom accelerator on one of the custom programs.

I notice that the SELECT queries on the individual tables (EKPO, RESB) are re-directed to HANA. However the SELECT queries on the views in ECC like MDBS (EKPO+EKET) and MDUB are not redirected to HANA.

I can confirm that the corresponding views and tables are replicated properly in HANA and are configured in the XML file. With XML file I tried with using only table names as well as with using the View names.

Let me know your feedback on this.

Thank you.

Warm Regards,

Harshad Mishrikotkar.

[Former Member]

Hello Harshad,

we are doing a similar scenario for one of the zreports and we replicated all the tables in to HANA and established 2DB connection as well there is one simple issue when we try to
accelerate the existing ABAP reports via HANA with Secondary database
connection it is not reading from HANA Database Instead it is taking from
Primary database.

DBCO Parameters are ok and even we checked in DBA COCKPIT as well. Connections are
ok w.r.t SWT2B add-on. AL Development system is at Kernel 720 . Relevant tables
are replicated in to HANA as well.

   After implementing SWT2DB add-on the Report RDA_MAINTAIN is available in the system
and this report will ask for Upload and activate scenario which we have
completed . When we try to run the ABAP Reports it is throwing Dump as well.

   Even we did the following in the RDA_MAINTAIN:

• Uploaded existing scenarios to the editor via XML
• Activated Scenario
• Maintained DB connection as well

All control tables are properly updated such as RDA_CONFIG,
RDA_CONTEXT etc with the uploaded scenario and DB Connection details as well

Processdone :

  Whenwe try to run the ABAP Report with Necessary adjustment of code by Including
CONNECTION (‘HANA_DB’) in the select statement it is not reading from HANA
database, Instead it is taking data from Oracle database.

Onestrange change noticed in the RDA_MAINTAIN report it is showing “Kernel does
not Support RDA”. We assume it was only a warning since all the parameters
related to the scenario is uploaded in the RDA_Maintain and it is reflected in
the control tables as well.

Any Quick thoughts would help

[former_member196555]

Hi Balaram,

Kindly run the report ADBC_TEST_CONNECTION and check if the connection to SAP HANA DB is fine from ECC. If this connection is fine ensure all the tables are replicated in HANA including the one's which are in JOIN.

e.g. MKPF is joined with MSEG and you replicate only MKPF, the query would use primary database instead of HANA.

Do Check and let me know.

Warm Regards,

Harshad Mishrikotkar.