How to convert Customized HANA view to CDS View?

[Former Member]

Hi,

I have created a customized HANA View as per the requirement and fetched in Fiori. Now SAP says all the Calculation views to be converted to CDS Views.

• I got to know the procedure, First we need to convert Customized HANA View to External View and consume external view in CDS. I am very new to CDS  so please someone elaborate how to convert HANA View to external view and how to consume in CDS?

Thanks in Advance

Nagarjuna

[amol_samte]

Hi,

Creation of External View.

E.g Ext View - ZTEST

CDS View

@AbapCatalog.sqlViewName: 'ZCDS'

@ClientDependent: true

@AbapCatalog.compiler.CompareFilter: true

@EndUserText.label: 'CDS Details'

define view Zcds_Fl

as

select from ZTEST as A   <----- External View Name

{

  key FL.MANDT as flight_id,

   matnr

}

-Amol S

[Former Member]

Hi Amol,

Thanks for your input,

Link shared was so helpful to create a External View on top of HANA View. While i am creating external view after providing the details of hana view in the next step it is forcing me to enter Access key. What is access Key and what should i enter here?

Thanks,

Nagarjuna

[amol_samte]

Hi,

You required development access key..

ask to basis people...

-Amol S

[Former Member]

Hi Amol,

I have created External View by following all the steps but while data previewing from se11 it throws column store error saying Input Parameters are not set because the calculation view which i have used contains Input Parameters and variables.

While creating External View how can involve Input parameters and Variables?

Thanks,

Nagarjuna

[amol_samte]

Hi,

You can not create external view of  based on HANA view which has parameter.

Regards

-Amol S

If you wanted to convert existing HANA Cal view into CDS, then best practice is.

1. Convert complete logic of HANA Cal View into CDS (CDS has input parameter).

If it is not possible then you can can remove input parameter of HANA View and create External view-> CDS.

[Former Member]

Hi,

I am not much aware of this conversion from HANA to CDS.

can you please elaborate the procedure how to convert logic of HANA cal view into CDS without External view?

Thanks,

Nagarjuna