Accessing HANA table from ABAP

[former_member185171]

Hi,

we are setting up HANA.

We started replicating some tables with SLT. One of these tables is EKKO.

Within HANA we copied this table as Z_EKKO using SQL [Create column table Z_EKKO as ( select * from POC_I12_001.EKKO )].

The table exists in HANA correctly.

However, when we want to access it using SE16H, and using the correct database connection to HANA, the table is not found.

Do we have to do some supplementary things to be able to access it from our netweaver? Can it whatsoever be accessed in netweaver, without defining it in the ABAP-dictionary?

Thanks for helping.

Greetings.

Kris

[rindia]

Hi Kris,

The basic information from SAP note 1636416 on SE16H is:

1. Note that transaction SE16H is able to check only the physical connection to the database. The table created in SAP HANA must correspond exactly to the definition in the SAP ERP Dictionary. If there are deviations (for example, different field names), transaction SE16H triggers a short dump upon access. Accesses to SAP HANA using transaction SE16H are useful only for tables that are replicated one-to-one. All other tables (for example, created in SAP HANA only) must be evaluated using the SAP HANA studio.
2. If you leave the "Database Connection" field empty, SE16H works with all functions for the normal database of the ERP system. In this case, there may be extremely long runtimes.
3. If a database connection was selected, the input help for the "Table" field displays the tables and views that are available in SAP HANA.
4. The number of rows is determined for the tables available. This is not possible for views. Note that the number of rows is also determined across all clients. The number of rows in your current system/client may therefore be lower than the number displayed.

Regards

Raj

[rindia]

Please refer to this document which shows the demo of SE16H on page 56.

[yeushengteo]

hi Kris,

I believe you need a ABAP dictionary view of the table which you created in HANA, ABAP object <> HANA artifacts

Regards.

YS

[SK-EA]

Kris,

Please clarify the below:

1. How was the SAP HANA server was setup in your landscape?  As a side-car or primary database?

2. If SAP HANA is your primary databse, can you confirm the schema under which the table Z_EKKO was created? It should be the SAP<SID> schema, where <SID> is the System Identifier of your ABAP instance.

Thanks & Regards,

Srinivas K.