Cannot extract CDS views in SAP BW/4HANA

[regysm21]

Hi Experts,

im trying to extract some CDS views in SAP BW/4hana and although everything is done correct: CDS View shows data in S/4HANA and is without errors-> then replicated the Datasource in SAP BW/4HANA and created OpenODSView, but it does not show any data in OpenODSView. I really cannot understand why this is not working? Could you please help with an idea?

Thanks,

Regys

@AbapCatalog.sqlViewName: 'ZRMBEL'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Belege'

@VDM.viewType: #BASIC@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true}

@ObjectModel.representativeKey: 'ebeln'

define view Z_RM_BEL as select from ekbe {  

   key ebeln,  

shkzg, 

 wrbtr, 

 menge, 

 waers   }

[maggie_yi]

Hi Customer,

Please firstly test the CDS view using report rodps_repl_test in S/4HANA system if it can return data.

If no -- it's hard to guess the reason without looking into your system.

If yes - please check if the required authorizations is enough, see SAP Note 150315.

Best regards,
Maggie