SQL Error ABAP View on top of a Calculation View with an input parameter

[lumirion]

Hello,

we created a ABAP View on top of Calculation View containing an input parameter (keydate). Though the ABAP View gets activated the execution leads to an SQL Error:

SQL-Code 2.048 column store error: search table error: [34051] Error while parsing injection query: invalid column name.

Can we consume Calculation Views with input parameters in ABAP Views? I assume that the input parameter (keydate) in HANA is not populated by the ABAP View and this leads to an error.

Regards
Ertugrul

[horst_keller]

"ABAP views" (?) can access dictionary objects only. Use AMDP to access calculation views.

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abenabap_hana.htm?file=abenabap_hana.htm

[lumirion]

Hello Horst,

as you can see in the attached screenshot we can easily consume a HANA view by creating a dictionary view (= "ABAP view") in the ABAP Modeling Tools. But as I already asked before without using any HANA input parameter?

Kind Regards

Ertugrul

[horst_keller]

So you speak about external views. As documented, external views cannot pass parameters to calculation views.

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenexternal_views.htm

Anyway, instead of external views, we recommend AMDP. Especially, since XSC will be replaced by XSA.

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abensap_hana_access.htm

(We don't use the Termin "ABAP view" and also it is "ABAP Development Tools" not "ABAP Modeling Tools").