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
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.