SAP Knowledge Base Article - Preview

3770109 - Only tables and views are permitted for extraction - SAPI datasource

Symptom

  • Extraction fails or a dump occurs when extracting data from a CDS View via an SAPI DataSource.

    Category               ABAP programming error
    Runtime Errors         SAPSQL_PARSE_ERROR
    Except.                CX_SY_DYNAMIC_OSQL_SEMANTICS
    ABAP Program           SAPLRSA3
    Application Component  BC-BW

     Short Text
         An error has occurred while parsing a dynamic entry.

    "SAPSQL_PARSE_ERROR" CX_SY_DYNAMIC_OSQL_SEMANTICS
    "SAPLRSA3" bzw. LRSA3U03
    "RSA3_GEN_GET_DATA"

  • A corresponding message such as "Only tables and views are permitted for extraction" will be prompted by the system when checking the DataSource.


Read more...

Environment

  • SAP S/4HANA 

Product

SAP S/4HANA all versions

Keywords

Only tables and views are permitted for extraction , KBA , BW-WHM-DBA-ODA , Operational Data Provider for ABAP CDS, HANA & BW , BC-BW , BW Service API , 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.