SAP Knowledge Base Article - Preview

2754708 - Failed to check the list of values of all the filters of a CDS View from S4HANA Cloud in SAP Analytics Cloud (SAC)


  • The error below shows when trying to show the list of values(LOV) of any filters in the table <tablename> in the CDS View <ViewName>:
    The following error message comes from the external data service:
    status:400 body:{"error":{"code":"BW/BICS_EQ/123","message":
    {"lang":"en","value":"Mandatory filter Ledger is missing"},"innererror":
    {"SAP_Transaction":"","SAP_Note":"See SAP Note 1797736 for error analysis
    [{"code":"BW_BICS_EQ/123","message":"Mandatory filter Ledger is missing","propertyref":"","severity":"error":"target":""}]}}}
  • This issue only happens on this table.



  • SAP Analytics Cloud 2019.2.3


SAP Analytics Cloud 1.0 ; SAP S/4HANA Cloud 1811


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, C_GLACCOUNTFLOW_CDS, C_GLAccountFlow_CDS, missing filter, cds, query, lov, list of value, query builder, , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.