(Glue-2108) Q: How can we extact data from HANA views (calculation views, CDS views) to another storage?

Owned by SNP
Aug 17, 2021
1 min read

It’s possible to use HANA CDS views, attribute views, analytic views, and calculation views as a base for the data extraction.

The first option

  1. and import fields from the ABAP dictionary object based on your HANA view.

  2. Create the standard way with SAP table fetcher using the ABAP dictionary object based on your view and GLUE table consumer using the GLUE table created in step 1.

  3. Run the extraction process.

The only prerequisite for this is that the HANA view is available through the SAP ABAP Dictionary (transaction code SE11). You can import CDS views or HANA views of all kinds into the ABAP dictionary through the HANA studio by creating an ABAP dictionary object based on your view.

The second option (only for CDS views)

  1. Create a GLUE table from external table/view with option view checked and external object set to SQL view name of HANA CDS view.

  2. and import fields from External table/view with option “Object is view” checked and External table/view set to SQL view name of HANA CDS view and Storage ID set to your HANA Native storage.

  3. Create the standard way with GLUE table fetcher using the GLUE table from step 1 and GLUE table consumer using the GLUE table created in step 2.

  4. Run the extraction process.