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