cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP CDS view Calculation view

pramodu
Active Participant
0 Kudos

Hello,

We have ABAP CDS view created and we need to consume in non SAP application ( say Power BI).

I have two questions

1) As Non-SAP application which has been use supports only calculation view only.

I understand we can create Calculation on HANA CDS view with HANA Modeling .

but do we have any way to create 'Calculation view of ABAP CDS view' ?

2) ABAP CDS view which created in our application ( SAP CAR application )

We have SAPCAR schema in HANA DB but I do not see this under view name rather we see under Function name.

Wondering, every ABAP CDS view gets converted to function in HANA Schema ?

If that is case then View name in HANA is for what type of view's ?

Thanks,

Pramod

Accepted Solutions (1)

Accepted Solutions (1)

Cocquerel
Active Contributor
0 Kudos

Yes, on ABAP side, you can use SQL script via AMDP and the corresponding runtime HANA artifact is a Table function.

If you want to create HANA graphical calculation view, it can not be done on ABAP side. You have to develop them either with classical (HANA Studio) or advanced model (WebIDE for HANA).
The .hdbcds or .cds (coming with CAP) are XS Advanced artifacts that allow to embed calculation view and expose them as oData service and can be combined with Smart Fiori elements with an annotations mechanism.

Answers (3)

Answers (3)

pramodu
Active Participant
0 Kudos

Thank you ! I will take look licensing part laos.

VijayetaSharma
Active Contributor
0 Kudos

Second to Mark's point, my previous client contract didn't allow us to expose HANA data via SQL to non SAP application. We had to work with SAP AE to get the agreement updated before we resumed any project work.

Thanks,

Vijayeta

markmumy
Advisor
Advisor
0 Kudos

I would also caution to get your sales team involved as well. Depending on what is done, how it is done, what is exposed, etc there may be license ramifications that you are not aware of. Best to know what can and cannot be done from a license perspective before getting into a situation that cannot easily be undone.

Mark