Question Re: Fixed value List with CDS annotations in Technology Q&A

Fixed value List with CDS annotations

Former Member — Thu, 13 Jul 2017 07:35:21 GMT

Hi,

I'm creating a Fiori app using fiori elements/templates and CDS annotations.

One of the fields requires a search-help value list, This just needs to be a drop down list with PASS and FAIL in it.

I have created another view that returns a table with these results and then create a foreign key association and linked the field to the value help

@Consumption.valueHelp:'_Result'

@ObjectModel:{foreignKey.association:'_Result',mandatory:true}

ZHEADER.qires,

This is working however the result is a two step search help (i.e. I click on the possible entries which brings up a dialog box where I then have to click go to show the list of entries as per below).

Is it possible to get the entries to appear as an immediate list similar to the one below?

Can this be done via annotations?

Any help much appreciated

Re: Fixed value List with CDS annotations

former_member383742 — Fri, 21 Jul 2017 14:23:23 GMT

Hi Andrew,

This is an feature which I am also interested in it. I think for now there is only the implementation approach available to define such dropdown list. See here:

https://blogs.sap.com/2016/04/27/how-to-build-drop-down-list-based-on-fixed-value-defined-in-a-domain/

I hope that sun there will be a ABAP CDS View Annotation which you can add to element level and define a field as dropdown list.

Kind regards,

Catalin

Re: Fixed value List with CDS annotations

Former Member — Thu, 10 Aug 2017 01:54:37 GMT

Thanks Chiuaru,

I've tried to follow this blog but can't get it to work. The the end I've had to extend the app and add a custom field and bind it to my CDS view field.

Re: Fixed value List with CDS annotations

Former Member — Tue, 27 Mar 2018 15:00:33 GMT

Hi Andrew,

I'm trying to create the Value help as what you did in the above question. but unable to get the desired F4.

I'm fetching data from another CDS View which is working fine but when i use it as association in my Consumption View, it doesn't show up. Instead it shows the standard Search Help Window.

Can you please help me with the annotations required in Consumption View?

Re: Fixed value List with CDS annotations

Former Member — Wed, 28 Mar 2018 01:19:46 GMT

Hi Vinay,

in the end I did manage to get the blog to work. You need to redefine the 'DEFINE' method of your model provider (MPC) class.

Here is a sample of the code (qires is the name of the field that I want to have the look up)

method DEFINE.

* Method-local declarations:

DATA lo_entity_setTYPE REF TO /iwbep/if_mgw_odata_entity_set.

DATA lo_propertyTYPE REF TO /iwbep/if_mgw_odata_property.

DATA lo_annotationTYPE REF TO /iwbep/if_mgw_odata_annotation.

*Call parent:

super->define( ).

lo_entity_set = model->get_entity_set( 'ZMYENTITYSET' ).

lo_annotation = lo_entity_set->create_annotation( 'sap' ).

lo_annotation->add( iv_key = 'semantics' iv_value = 'fixed-values').

DATA(lo_entitytype) = model->get_entity_type( 'ZMYENTITYSETType' ).

lo_entitytype->set_is_value_list( abap_true ).

data(lo_txt_property) = model->get_entity_type( 'ZMYENTITYSETType' )->get_property( 'qires' ).

lo_txt_property->set_value_list( /iwbep/if_mgw_odata_property=>gcs_value_list_type_property-fixed_values ).

data(lo_text_anno) = lo_txt_property->/iwbep/if_mgw_odata_annotatabl~create_annotation( 'sap' ).

lo_text_anno->add( iv_key = 'text' iv_value = 'to_result/qires').

lo_txt_property = model->get_entity_type( 'ZMYCDSLOOKUPVIEWType' )->get_property( 'qires' ).

lo_txt_property->set_value_list( /iwbep/if_mgw_odata_property=>gcs_value_list_type_property-fixed_values ).

lo_text_anno = lo_txt_property->/iwbep/if_mgw_odata_annotatabl~create_annotation( 'sap' ).

lo_text_anno->add( iv_key = 'text' iv_value = 'qires').

endmethod.

Re: Fixed value List with CDS annotations

lavanyar087 — Mon, 12 Nov 2018 06:30:37 GMT

Add the below annotation in your value help view

@ObjectModel.resultSet.sizeCategory:#XS

Re: Fixed value List with CDS annotations

janmattfeld — Fri, 11 Jan 2019 12:57:10 GMT

Annotate your value help CDS view with

@ObjectModel.resultSet.sizeCategory: #XS

This will automatically create the fixed-values metadata annotation and shows a dropdown in Fiori Elements.