Expose a custom table(ZTABLE) available in S4 HANA using CDS views to SAP Analytics Cloud

[karthik_s94]

Hello Community,

I am trying to expose a custom CDS view that needs to be consumed in the SAC.

I have a custom table and SAP allows only CDS view to be called in the Custom CDS (data source name) that we are exposing using few annotations to CDS.

Annotations used to expose CDS : 

//@Analytics.dataCategory: #CUBE -> Unable to use this annotation.

@analytics.dataExtraction.enabled: true

@VDM.viewType: #CONSUMPTION / #BASIC -> What to use ?

@analytics.query: true

@OData.publish: true

Example: 

Table Name : ZTABLE

Fields : VBELN, POSNR, VBTYP, MATNR, WERKS, LGORT.

Is there any other solution to expose the custom table directly to SAP Analytics Cloud ? Please let me know how i can achieve a solution to this case.

Thanks in Advance.

[cesar_gr]

Hi
you can expose your custom table as you said, using CDS.

if you use the CDS as a BW CUBE, then you need to use @VDM.viewType: to define your query (you can expose a basic view and composition and finally consumption view)

related information https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361385699.html 

also you need to declare your CDS as an analytical view with this annotation 

@analytics.query: true

and remember to define the Contract release as "C1" in ADT to consume the analytical view in SAC

regards!

.

[junwu]

you need to stack your cds view. don't put everything in one cds view.

interface view--->cube--->query

odata enablement is not needed.

you have to set the api state

https://community.sap.com/t5/technology-blogs-by-members/consume-cds-views-in-sap-analytics-cloud-st...