Skip to Content

Using "Find Tables" in Remote Sources

Hi all,

I have successfully configured SDA/SDI, using all kinds of Oracle and MSSQL adapters.

Following this excellent video, I have noticed two things:

  1. I do not have the Find table option

2. In the video, when expending the tables list, tables are well organized in groups.

In my system, tables are only ordered in alphabetical order.

Any idea about how to make menu option available and how to organize tables into (ECC) groups?

Regards,

Ami.

Context menu.png (13.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 25, 2016 at 09:49 AM

    May I ask which adapter you are using? I suspect you are using the SDI OracleLogReaderAdapter, not the OracleECCAdapter.

    The OracleECCAdapter is using the ABAP dictionary and application hierarchy for browsing. Technically they are similar, the ECC version just have this ABAP dictionary and handling of pool/cluster tables in addition.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 14, 2016 at 07:38 PM

    Hello Ami,

    what HANA SPS level you have installed?

    Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ami Benodiz

      Hello Ami,

      I am on SPS11 and don't have that either,

      if you Need to create a virtual table you could create it in SQL Console by calling

      CREATE VIRTUAL TABLE SCHEMA01.VT_USR02 at "P01CLNT099".""."SAPABAP1"."USR02";

      Regards

      Kairat

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.