How to identify CDS-Views which are enabled for data extraction?

[Roman_Broich]

Dear all,

currently I am struggling to find a way to identify CDS-Views which are enabled for data extraction in S/4HANA. (dataExtraction.enabled:true)

Is there a list of extraction enabled CDS views or a way to search or filter accordingly?

In addition the question if there is a way to find the corresponding OData services for the extraction enabled CDS-views?

Thanks!
Roman

[shanthi_bhaskar · Accepted solution]

Roman,

You can use below SQL and refer the AnnotationValue Field, If it TRUE then you can extract the data through RFC.

SELECT * from CDSVIEWANNOPOS WHERE 
ANNOTATIONNAME = 'ANALYTICS.DATAEXTRACTION.ENABLED'

Cheers,

Shanthi.

[Roman_Broich · Accepted solution]

Hi Shanthi,

this SQL-based hint is really helpful! Thanks!

Are you aware if the corresponding OData services for extraction are created automatically?

Cheers,

Roman