Are SE11 structures visible inside HANA schema?

[digantogos]

Hi

HANA standard schema seems to not include SE11 structures, rather include just the SE11 table definitions in its schema.

Do SE11 structures show up somewhere else in the HANA schema?

Regards

Diganto

[former_member473321]

Hi,

Can you elaborate your question?

[horst_keller]

How do you define a SE11 structure?

[digantogos]

Defined by the tcode SE11. Tables show up in SYS_BIC schema but structure show up nowhere at the DB layer.

Possibily a way to make them exist is by creating table out of such structures.

[horst_keller · Accepted solution]

As documented, the global data types of the ABAP Dictionary including structures, that can be defined in SE11 or ADT, are for usage on the AS ABAP only. They are not available in the database.

Furthermore, ABAP managed database objects e.g. the instances of database tables or views defined in the ABAP Dictionary should not be accessed directly in the database. See SAP note 2511210.

[digantogos · Accepted solution]

The SAP Note 2511210 answered my back dated question I posted over the forum. Nice to know.

Regards

Diganto

[digantogos · Accepted solution]

Also may I ask per the SAP Note 2511210 recent release, Can we exploit SAP HANA CDS Table Function to extract ERP ABAP table data from the database as the NOTE interpretation contradicts this SAP Provided CDS Table functionality.

Regards

Diganto

[horst_keller · Accepted solution]

We recommend to use ABAP CDS Table Functions implemented by AMDP for that.

[digantogos · Accepted solution]

When using AMDP to extract table data, will it not be a direct database call which we are to avoid.

[horst_keller · Accepted solution]

But ABAP managed!

[digantogos · Accepted solution]

Although it seems unadvisable to use native procedures to do CRUD operations in ABAP schema, yet they are more featured than AMDP wrt sequel programming(like most of DB SQL such as create temporary tables, delete from temporary tables are not supported in AMDP methods).

Are there any guidelines other than using client ID that needs consideration when using native procedural code to perform on the ABAP schema?

[horst_keller · Accepted solution]

"ABAP Development" recommends using ABAP. Guidelines for "using native procedural code to perform on the ABAP schema" might be found elsewhere.