topic CDS view with input parameters -error in Application Development and Automation Discussions

CDS view with input parameters -error

Former Member — Thu, 16 Jun 2016 08:47:15 GMT

Hi ,

I did try to create a CDS view with combining two CDS view with parameters as below. No syntax error but once i am trying to execute getting exception says that "Sysstem failure :"Table is unknown or does not exist ". . but in ABAP dictionary level(SE11) VIEW' S are available and tables are exist with valid data.

@AbapCatalog.sqlViewName: 'ZXV_CDS_05'

@AbapCatalog.compiler.CompareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'CDS view - Testing'

define view ZXV_PERS

with parameters p_string : abap.char( 14 ),

p_validity :abap.dats

as select from ZCDS_PERS

( p_string : :p_string,

p_validity : :p_validity ) as PERSON

inner join Zcds_Person_Navn

( p_string : :p_string,

p_validity : :p_validity ) as NAVN

on PERSON.root_key = NAVN.root_key

{

key NAVN.db_key,

key PERSON.db_key as person_key,

NAVN.adresseringsnavn,

PERSON.cpr_nr,

NAVN.fornavn,

PERSON.root_key

}

Could you please help me in that ?

thank you

Regards

Vinuta hegde

Re: CDS view with input parameters -error

thomasgauweiler — Thu, 16 Jun 2016 10:41:14 GMT

Hi Vinuta,

I do not see any problem in this view.

Are both underlying views ( ZCDS_PERS, Zcds_Person_Navn) working?

Do you have a DCL on your CDS view? (you have: @AccessControl.authorizationCheck: #CHECK)

Are there any errors in the activation log ?

Regards, Thomas

Re: CDS view with input parameters -error

Former Member — Thu, 16 Jun 2016 11:04:45 GMT

Both underlying views (ZCDS_PERS, Zcds_Person_Navn ) are working fine when i executed separately.

yes i have @AccessControl.authorizationCheck: #CHECK).

No error in the activation log .

Re: CDS view with input parameters -error

Former Member — Tue, 26 Jul 2016 08:57:49 GMT

Hi vinuta,

I think Thomas did not ask, if you use the Annotation (@AccessControl.authorizationCheck: #CHECK).

The question is, if there is a DCL Role defined, which is assigned to the CDS View - because if yes, this Role is triggered as you use the annotation. To verify this have a look at the "Problems" tab in Eclipse and into the Access Control folder under Core Data Services.

In case you don't need any roles you can set the annotation to #NOT_REQUIRED instead of #CHECK, then the Access Control is skipped.

However as the error message is about missing tables, I would assume that only the warning in the Problems tab disappears, if there is any at the moment - your core problem probably remains.

Regards,

Sebastian