2334344 - Fiori Apps/ OData Service activation based on CDS view queries fails

Symptom

Activating OData Services fails in

in transaction /n/iwfnd/maint_service
Metadata not loaded - See /IWBEP/ERROR_LOG in backend '<system> ' - Query 2C<query> is invalid or contains errors....<)>
Message no. /IWFND/MED024

Query/Transient provider generation fails with error messages such as:

in transactions RSRT or RSRTS_ODP_DIS
X_MESSAGE in METHOD _CREATE_CHAR_FROM_CHABAS (class CL_RSROA_VQ_SERVICES)
System error in program CL_RS_BASE and form CREATE_DTAPRO_FROM_DDFIELD-0UNIT or CREATE_DTAPRO_FROM_DDFIELD-0CURRENCY

Query/Transient provider execution fails with error messages such as:

Value 'EUR' is not valid for variable Display Currency
Value ‘Today’ is not valid for variable open on key date

Environment

SAP S/4HANA
SAP NetWeaver 7.5
SAP Enhancement package 1 for SAP NetWeaver 7.5
SAP Fiori for SAP ERP

Product

SAP Fiori for SAP ERP all versions ; SAP NetWeaver 7.5 ; SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA, on-premise edition 1511

Keywords

Fiori apps, S/4HANA, S4H, RSTCO_ADMIN, 0UNIT, 0LANGU, 0DATE, 0CURRENCY, activation, X_MESSAGE, _CREATE_CHAR_FROM_CHABAS, CL_RSROA_VQ_SERVICES, CL_RS_BASE, CREATE_DTAPRO_FROM_DDFIELD, OData, /IWFND/MED024, /IWBEP/ERROR_LOG, /n/iwfnd/maint_service, Cannot Load Tile, Initialization of query XXX failed, X MESSAGE BRAIN 299: CL_RS_BASE CREATE_DTAPRO_FROM_DDFIELD-0CURRENCY, CL_RS_BASE CREATE_DTAPRO_FROM_DDFIELD-0UNIT , KBA , BW , SAP Business Warehouse , BW-BEX-OT , OLAP Technology , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , BW-BCT-TCT , BW Only - Technical Content and BW Administration Cockpit , How To

About this page

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

Search for additional results

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