CDS View - Consumption View multiple default value... - SAP Community

Hi Marcelo,

i Currently have the same problem. Did you find a solution?

Best regards,

Hendrik

Hi all,

I have used the following code in my consumption view and it worked fine.

In the place of Companycode1,companycode2,companycode3.. use the key values of CompanyCode you want to display.

In the background I have made an association for I_companycode in the cube view and used below annotation for same field.

@objectmodel.foreignkey.association:'_CompanyCode'

Best Regards,

Vaishnavi Devi, N

try to use to build your filter with case/when expression and use the annotations:

a.MovementType,

@UI.hidden: true

@Consumption.filter.defaultValue: 'Filter_X'

case(a.MovementType)

when '601' then 'Filter_X'

when '901' then 'Filter_X'

else 'NoFilter'

end as MyMovementFilter

Best regards

Is there a way to avoid some Values in a property?

For Example,

If I want to avoid John specifically.

$filter=EmployeeName ne 'John'

Is there a way to do this in CDS view or Fiori Elements?

Hi all,

did anyone find a solution to this problem in the meantime? I found this question in several other questions (unanswered) as well.

There should be a possibility for a default filter on multiple values...

Best,

Florian

Hi Marcelo,

Do you want to have multiple single value for the select-option?

I could not see to define a set of values for

defaultValue

select 
from vbak {

@Consumption.filter : { 
    selectionType : #SINGLE, 
    multipleSelections : true,
    defaultValue : '1653000003'
}    
    vbeln,    //several single values are allowed    

Perhaps you have already checked, if not have a look at

https://help.sap.com/doc/cc0c305d2fab47bd808adcad3ca7ee9d/7.5.6/en-US/d60c0bf6798a481fb7412bc89934cb...

But there is not an explicitly shown sample for your case