URI To Filter association property

[former_member594288]

Hi,

I have developed a cds view like below and converted into an odata service (odata version v4) but when i try to filter a field from association it's not working. Please find the below uri's.

/sap/opu/odata/SAP/zodata_filters_cds/zodata_filters?$expand=to_ma&filter=to_ma/matkl eq 'L001'

/sap/opu/odata/SAP/zodata_filters_cds/zodata_filters?$expand=to_ma($filter=matkl eq 'L001')

define view zodata_filters
as select from vbak as vb inner join vbap as vp on vb.vbeln = vp.vbeln
association [1] to zmaterialtt as _ma on vp.matnr = _ma.matnr
{
key vb.vbeln,
    vp.posnr,
    vp.matnr,
    _ma
}

Can anyone please suggest me the correct uri.

[pataselano]

Please check following blog: How to Develop Query Options for an OData Service Using Code-Based Implementation.

Please also see following SAP Note: 1922246 - Conversion of OData $filter into Open SQL WHERE clause