CDS Entity View as data source in SAP Data Services Designer

[EarlThePearl]

I am experiencing an issue with using a CDS entity view as a data source in SAP Data Services Designer. When attempting to import it from SAP S/4HANA to BODS, the CDS entity view name is not visible, unlike classic CDS views.

Note: The CDS entity view has OData.publish active, and the service is also active.

Could someone explain why the CDS entity view is not appearing and how I might resolve this issue?

[junwu]

then what is visible?

[EarlThePearl]

So i wrapped the classic view entity by using a classic cds view. This time the SAP Data Service Designer was able to find it but it returned this error: Error: Cannot import the metadata table <name=ZxxxxxxxMNVW>

[holger_bäumken]

I have / had the same "error"

OData service for this is not activated

New CDS entity

@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'test kna1'

@Metadata.ignorePropagatedAnnotations: true

@odata.publish: true

@ObjectModel.usageType:{

serviceQuality: #X,

sizeCategory: #S,

dataClass: #MIXED

}

define view entity Z_TEST as select from kna1

{

key kna1.kunnr

, name1

}

New CDS classic view

@AbapCatalog.sqlViewName: 'Z_TEST_ETL'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Z_TEST_CLASSIC'

@Metadata.ignorePropagatedAnnotations: true

define view Z_TEST_CLASSIC as select from Z_TEST

{

*

}

and import Z_TEST_ETL in BoDs,

works...

[EarlThePearl]

This is what I did. Entity view has Odata Service activated. The used the entity view inside the classic cds. Sql view name can now be seen in the sap data servces designer. Unfortunately, it returns this: Error: Cannot import the metadata table . Coud it be that the ds entity table was using and joining cds entity views?

[holger_bäumken]

Possible reason? Check if in your data source if ODP content is set to ABAP_CDS

[EarlThePearl]

In the Sap Data Service Designer, nothing is visible. Only the the classic CDS views can been seen.  All CDS Entity Views cannot be seen.