Skip to Content

SAP Fiori Analytical List Pages(1.58) Compact Filter value help is not coming


I need some help regarding Analytical List pages project. I have created one Analytical List Pages in WebIDE using Hana CDS view, Data is properly showing based on mandatory filters(Company Code as 1010) set from backend selected.

But Compact filter's F4 help data list for Purch. Organization filter is not coming, only showing as Define Condition.

Which is coming properly in Query Browser.

List of Company Code showing correctly in Query Browser based on CDS, but Value list is not showing in Compact Filter F4 help.

Please let me know if anyone has any concern on this.

query-browser.png (169.9 kB)
scor-kpi-data1.png (103.6 kB)
company-list.png (185.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Oct 23, 2018 at 06:13 AM

    Hi Biplab,

    Value help doesn't come by default. You have to add associations in your consumption CDS view as _companyCode or use standard I_CompanyCode(example don't remember exact name). And pass the association in your @consumption annotation in your property while defining in @UI.Selectionfields for company code.

    Also please don't use version 1.58 as this is not stable yet. You should be using 1.56.8 or 11. 1.58 is by far the beta version as per SAP.



    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2018 at 06:43 AM

    Hello Tejas,

    Thanks for your answer.

    I have used Abap CDS view currently, for value help they provide multiple entity set and one custom entity set. Now I am using one valueHelp entity set(C_MM_CompanyCodeValueHelpType) to show filter F4 help for Company code. Now when I have added valuelist to this entity set then no Select from list is coming in F4 help. And if I have used valuelist in custom entity set(ZC_BU_POITEMKPI_C008Type) then Select from list is coming but no data is coming. Because Company code data list is present in C_MM_CompanyCodeValueHelpType.

    <Annotations Target="Z_SCORE_KPI_SRV.ZC_BU_POITEMKPI_C008Type/CompanyCodeH"> <Annotation Term="Common.ValueList"> <Record Type="Common.ValueListType"> <PropertyValue Property="CollectionPath" String="CompanyCodeH"/> <PropertyValue Property="Label" String="CompanyCode"/> <PropertyValue Property="SearchSupported" Bool="true"/> <PropertyValue Property="Parameters"> <Collection> <Record Type="Common.ValueListParameterInOut"> <PropertyValue Property="LocalDataProperty" PropertyPath="CompanyCodeH"/> <PropertyValue Property="ValueListProperty" String="Company Code"/> </Record> <Record Type="Common.ValueListParameterDisplayOnly"> <PropertyValue Property="ValueListProperty" String="CompanyCode"/> </Record> </Collection> </PropertyValue> </Record> </Annotation> </Annotations>

    <Annotations Target="Z_SCORE_KPI_SRV.C_MM_CompanyCodeValueHelpType/CompanyCode"> <Annotation Term="Common.ValueList"> <Record Type="Common.ValueListType"> <PropertyValue Property="CollectionPath" String="CompanyCodeH"/> <PropertyValue Property="Label" String="Company Code"/> <PropertyValue Property="SearchSupported" Bool="false"/> <PropertyValue Property="Parameters"> <Collection> <Record Type="Common.ValueListParameterInOut"> <PropertyValue Property="LocalDataProperty" PropertyPath="CompanyCode"/> <PropertyValue Property="ValueListProperty" String="CompanyCodeH"/> </Record> <Record Type="Common.ValueListParameterDisplayOnly"> <PropertyValue Property="ValueListProperty" String="CompanyCodeName"/> </Record> </Collection> </PropertyValue> </Record> </Annotation> </Annotations>

    My query is how can I get company code data in resepective filter value help. Please find attach files with screenshots.





    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2018 at 10:09 AM

    HI Biplab,

    You need to show us your CDS View. You should have a foreignkey annotation in the CDS View itself that should be related to the association you are using to the value help. This is NOT a UI annotation and local annotations cannot be used as a substitute for this.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jocelyn,

      I'm having a bit of a problem surrounding this issue.

      Regarding an Analytical List Page in the making, so far I've not successfully added value help for each compact filter, even though I've apparently placed the needed associations and annotations.

      Besides that, I cannot even reference it via SEGW so then I could redefine its metadata annotations and import search helps or such (which wouldn't be ideal, either way), since Analytics are envolved in Analytical List Pages.

      I've also come across with these two tutorials (value help through modelled view and through foreign key relationship), with no further success:


      Apparently, unlike the entities themselves, the issue is that the entity sets doesn't seem to be working (throws an /IWBEP/CX_MGW_BUSI_EXCEPTION).

      Example of an entity:

      Example of an entity set:

      Nevertheless, it works in a List Report I quickly developed for the matter of testing.

      Let me know if you have any solution to this kind of problem.

      Looking forward to any kind of feedback,

      ** Here are the CDS Views: **

      @AbapCatalog.sqlViewName: 'ZCDS_PROD_CUBE'
      @AbapCatalog.compiler.compareFilter: true
      @AccessControl.authorizationCheck: #NOT_REQUIRED
      @Analytics.dataCategory: #CUBE
      @Analytics.dataExtraction.enabled: true
      @VDM.viewType: #COMPOSITE
      define view ZCDS_PROD_CUBE_V
          as select from zip_producao as cube
          association [1..1] to I_CalendarDate as _date on $projection.hsdat = _date.CalendarDate
          association [1..1] to I_Material as _mat on $projection.matnr = _mat.Material
          association [1..1] to I_CompanyCode as _bukrs on $projection.bukrs = _bukrs.CompanyCode
          association [1..1] to I_Plant as _werks on $projection.werks = _werks.Plant    
          association [1..1] to I_StorageLocation as _lgort on $projection.lgort = _lgort.StorageLocation      
          association [1..1] to ZCDS_PROD_DIM_FASE as _fase on $projection.fase = _fase.fase
              @EndUserText.label: 'Material'  
              @Consumption.valueHelp: '_mat'
              @ObjectModel.foreignKey.association: '_mat'
              @Consumption.filter: { selectionType: #SINGLE, multipleSelections: false, mandatory: false }          

      Consumption View:

      @AbapCatalog.sqlViewName: 'ZCDS_PROD_ALP'
      @AbapCatalog.compiler.compareFilter: true
      @AccessControl.authorizationCheck: #NOT_REQUIRED
      @VDM.viewType: #CONSUMPTION 
      @Analytics.query: true
      @OData.publish: true
      @Analytics.dataExtraction.enabled: true
      (.. UI Annotations ..)
      define view ZCDS_PROD_ALP_DDL
          as select from ZCDS_PROD_CUBE_V 
                  @AnalyticsDetails.query.sortDirection: #ASC             
                  @AnalyticsDetails.query.axis: #ROWS              
                  @Consumption.valueHelp: '_mat'
                  @ObjectModel.foreignKey.association: '_mat'            
                  @Consumption.filter: { selectionType: #SINGLE, multipleSelections: false, mandatory: false }
                  @AnalyticsDetails.query.display: #KEY_TEXT                                    
                  @UI.selectionField.position: 60
                  @UI.lineItem.position: 60        
                  key matnr,    
      p.png (37.2 kB)
      xx.png (18.7 kB)
  • Apr 11 at 02:57 PM

    Hi everybody,

    from my point of view the problem with the usage of value helps in the Analytical List Page is a big gap in the SAP documentation. I hope my answer can solve both question by Biplab Chakraborty and Tyler Keenan.

    As it is not possible to use RDS for Analytical Query Views (or associations within the Quaery View) the main question is: How do you bring a second entity (which serves as a value help) to your service:

    We picked the option "Include Gateway Service" in SEGW. There we have a service, which includes two OData.Publish:true services - (1)the main data for the ALP and (2) the service for the value help (and (n) for each additional value help).

    Within the local annotations of the ALP now you are able to follow the SAP documentation:

    Short story considering the documentation: In the following annotation now you can define the company code field as target (which you already do) and within the collection path you can choose the entity (2), which contains the company code value help. In this way you combine your main service with the value help entity, coming from the second service in your include service. From an ALP point of view however it is only one (include) segw service (containing (1) and (2)).

    I hope it helps - best regards,


    Add comment
    10|10000 characters needed characters exceeded