SAP Knowledge Base Article - Preview

3806508 - RSRTS_ODP 147: Field XXX is not available as an InfoObject in InfoProvider

Symptom

A CDS query view contains fields that are annotated with @Semantics.BusinessDate.From: true or @Semantics.BusinessDate.To: true in the underlying cube CDS view.

  • Previewing the query in Fiori shows the error "Service cannot be used". 

  • Running the query in transaction RSRT shows errors below:
    Query 2CXXX could not be opened.
    Position in code >> Row: 39 Inc: CONSTRUCTOR Prog: CL_RSR_OLAP_VAR
    DDL source XXX is not a valid BW query. Check and adjust the DDL source. 

  • Checking the CDS query in transaction SE80 shows error "RSRTS_ODP 147  Field XXX is not available as an InfoObject in InfoProvider 2CXXX".


Read more...

Environment

SAP S/4HANA

Product

SAP S/4HANA all versions

Keywords

BusinessDate.From, BusinessDate.To, cds semantics , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , Problem

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.