How do we convert a HANA calculation View File into ABAP CDS?

[digantogos]

HI Experts

I have a requirement to use a calculation view from Repository & make a ABAP CDS out of it. Please suggest ways to do this conversion.

Regards

Diganto

[horst_keller · Accepted solution]

I would recommend to create a CDS table function implemented by AMDP that accesses the calculation view and returns its result and can be accessed in Open SQL.

We don't recommend external views any more.

[digantogos · Accepted solution]

The .calculationview file is absent at the ABAP layer but is existing inside HANA Repository. Table function will not read the database extract from the ABAP layer.

[horst_keller · Accepted solution]

Why not? You can address other DB schemas in AMDP using fully qualified names.

[former_member473321]

Hi Diganto,

Try to create an External View in the ABAP Perspective on top of HANA View.

Please have a look at the below document with the steps to do so.

https://archive.sap.com/documents/docs/DOC-44264

[horst_keller]

External views are not recommended any more, if you can use AMDP.