3412317 - ABAP CDS View is not available in extraction ODP context ABAP_CDS in SAP Datasphere

It is found that ABAP CDS View is not available in extraction ODP context ABAP_CDS in SAP Datasphere UI.

SAP Datasphere

1. Log into SAP Datasphere
2. Try to import remote table or use source in view.
3. Cannot find the expected CDS View under Extractors -> ABAP_CDS

Some times issue can also be reproduced by Function Model RODPS_REPL_ODP_GET_LIST in source on-premise system side with below steps:

1. SE37 to run Function Module RODPS_REPL_ODP_GET_LIST with below input parameter
   I_SUBSCRIBER_TYPE               SAP_BW
   I_CONTEXT                       ABAP_CDS
   I_SEARCH_PATTERN                <search patten>
2. Cannot find the expected ABAP CDS View in the result.

For detail usage of FM RODPS_REPL_ODP_GET_LIST, see "Question5" in KBA 3210655 - For troubleshooting: usage of ODP program and function modules. 

• Cause 1:
  Incorrect / missing definition of the CDS View
  
  
• Cause 2:
  Source system program error

• Solution for Cause 1: Check the CDS View definition the Analytics Annotation below is needed:
  • Analytics.dataExtraction.enabled : true
    • Also see the details in SAP Help document Analytics Annotations
    • Also it should NOT contain the annotation @Analytics.Query: true. With this annotation the CDS view can only be processed by the analytic engine of BW. CDS View Extraction works based on ODP-CDS Extraction infrastructure. So for such kind of CDS View SQL access or data extraction is not supported. See KBA 3346023
• Solution for Cause 2:
  • Apply SAP Note 3013256 in source system if "define view entity" is used in CDS View
  • SAP Note 3013256 - ABAP CDS extraction for view entities
  • Apply SAP Note 3305950 in source system if there is inner join in CDS View
  • SAP Note 3305950 - CDS Views having Inner Join cannot use CDC for delta

If RODPS_REPL_ODP_GET_LIST is able to find the CDS View, please make sure that searching with the correct name.

• KBA 3346023 - ABAP CDS Query View with annotation "@Analytics.Query: true" not available for extraction
• KBA 3210655 - For troubleshooting: usage of ODP program and function modules
• SAP Note 3013256 - ABAP CDS extraction for view entities
• SAP Note 3305950 - CDS Views having Inner Join cannot use CDC for delta

Annotation ANALYTICS.DATAEXTRACTION.ENABLED is not supported in Analytical Query/Projection View
RSRTS_CDS, 404, RSRTS_CDS404, RSRTS_CDS 404 , KBA , BW-WHM-DBA-ODA , Operational Data Provider for ABAP CDS, HANA & BW , DS-DI-RT , Remote Tables , DS-DI-CON , Connections , Problem