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.
SAP Knowledge Base Article - Preview