Skip to Content
0
Former Member
Jun 16, 2016 at 08:47 AM

CDS view with input parameters -error

2124 Views

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