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

[shanthi_bhaskar]

If is for fiori you need to add the service and settings needs to be done.

[Roman_Broich]

Ok, thanks! Will check...

[JavierB]

Hi Roman,

You can also try the following notes:

2674373 (S/4HANA Cloud)

2670861

2698189

Regards,

JB

[JavierB]

Hi Roman,

In note 2669594 you will find a list of views which were changed in 1809. If you are using 1709 or lower this list will help you find CDS views which are enabled for data extraction.

[Roman_Broich]

Hi Jorge,

many thanks for your reply! The note looks great so far, however it covers only a limited set of application components (Area Produce). Are there other simlar notes for other application components like finance or logistic?

Thanks!

Roman