SAP Knowledge Base Article - Preview

3324163 - ABAP_CDS: Column MANDT is unknown from report RODPS_REPL_TEST

Symptom

Extraction of CDS view (which has field MANDT in its definition) fails with error :

Exception with the type CX_SY_DYNAMIC_OSQL_SEMANTICS occurred, but was neither handled locally, nor declared in a RAISING clause
The database column 'MANDT' is unknown

If testing the CDS view with report RODPS_REPL_TEST with option []Direct Extraction without ODQ, the runtime below error:

Category               ABAP Programming Error
Runtime Errors         SAPSQL_PARSE_ERROR
Except.                CX_SY_DYNAMIC_OSQL_SEMANTICS
ABAP Program           CL_RSODP_ABAP_CDS_CURSOR======CP
Application Component  BW-WHM-MTD

|    "SAPSQL_PARSE_ERROR" CX_SY_DYNAMIC_OSQL_SEMANTICS                          
|    "CL_RSODP_ABAP_CDS_CURSOR======CP" bzw. CL_RSODP_ABAP_CDS_CURSOR======CM002
|    "OPEN_DEFERRED"                                                            

|    1|  METHOD open_deferred.
|    2|
|>>>>>|    OPEN CURSOR WITH HOLD @p_cursor "#CP-SUPPRESS: FP ViewName is from DDL Source and where
|    4|         FOR SELECT (p_select) FROM (p_from) WHERE (p_where) GROUP BY (p_group) ORDER BY (p

|ME->P_SELECT        
|    MANDT AS MANDT,  <----- There's column MANDT in the return list.


Read more...

Environment

  • A system which's lower than SAP_BW 750.

Product

SAP BW/4HANA all versions ; SAP S/4HANA all versions

Keywords

KBA , BW-WHM-DBA-ODA , Operational Data Provider for ABAP CDS, HANA & BW , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , 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.