The request URI contains an invalid key predicate

[debdatta_panda]

Hello Experts,

I have created one CDS view with parameters.It is running successfully in HANA studio.When I am going to run ODATA service from /IWFND/MAINT_SERVICE then I'm getting below error :

"The request URI contains an invalid key predicate"

Below is my code regarding CDS view

@AbapCatalog.sqlViewName: 'ZPUR_SPEND'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'FIORI app for purchase spend'
@OData.publish: true
define view ZMM_PURCHASE_SPEND
with parameters p_date : string1,
p_bukrs : string1
as select from ekpo inner join t001w
on ekpo.werks = t001w.werks
inner join t134t
on ekpo.mtart = t134t.mtart
inner join t023t
on ekpo.matkl = t023t.matkl
inner join mara
on ekpo.matnr = mara.matnr{
key ekpo.werks,
/*cast($parameters.p_bukrs as abap.sstring(04)) as cc,*/
/*cast($parameters.p_date as abap.sstring(08)) as cdate,*/
key t001w.name1,
key ekpo.bednr,
key t134t.mtbez,
key ekpo.matkl,
key t023t.wgbez,
key ekpo.netwr,
key mara.meins
}
where ekpo.bukrs = $parameters.p_bukrs
and ekpo.creationdate = $parameters.p_date
and ekpo.bednr <> ' '

My URI is :

/sap/opu/odata/sap/ZMM_PURCHASE_SPEND_CDS/ZMM_PURCHASE_SPENDSet(p_DATE='20190401',p_BUKRS='1000',WERKS='1001')

Please suggest me

[frank_dj_miller]

Hi Debdatta, I have encountrered exactly the same error in our S4 system: "

"The request URI contains an invalid key predicate".

Please could you kindly share if you managed to find a solution? I see there are a number of SAP notes on this topic e.g. 24100124, 2584730 etc.

Regards,

Frank.

[Shireesha]

Hi Debdatta & Frank,
Even I have encountered exactly the same error in our S4 system while running the Odata query which is "The request URI contains an invalid key predicate". Could either of you please share the solution if you have succeeded in finding it?
Thanks,
Shireesha.