Skip to Content
author's profile photo Former Member
Former Member

CDS view with input parameters -error

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 16, 2016 at 10:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.