cancel
Showing results for 
Search instead for 
Did you mean: 

The request URI contains an invalid key predicate

debdatta_panda
Participant
0 Kudos

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
Discoverer
0 Kudos

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
Newcomer
0 Kudos

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.


Accepted Solutions (0)

Answers (0)