CDS view with input parameters -error

[Former Member]

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

[thomasgauweiler]

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

[Former Member]

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 .

[Former Member]

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