Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CDS View - consuming HANA artifact (calculation view generated by BW)

Hi,

Can I consume a calculation view in a CDS view like below? If not, how should I then do it?

@AbapCatalog.sqlViewName: 'Z_Cds_Test_12345'

@EndUserText.label: 'CDS View on generated view for NCTT2000'

define view Z_Cds_Test_Nctt2000_Gen_View as select from "_SYS_BIC"."system-local.bw.bw2hana/NCTT2000" {

    CALMONTH,

    AMOUNT   

}

At least when I try I get an error:

Description Resource Path Location Type

Table _SYS_BIC does not exist or is not active Z_CDS_TEST_NCTT2000_GEN_VIEW (ABAP DDL Source) [D32] Z_CDS_TEST_NCTT2000_GEN_VIEW Unknown ABAP Syntax Check Problem

Thanks in advance, kr

Torben

Former Member
replied

Hi Torben,

We had gone through same scenario which has to be later used in ALV IDA, in such case we have created external view based on hana view and used in CDS view.

Another way you can directly access hana view inside AMDP and can be reusable.

-Amol

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question