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

Owned by SNP
Last updated: Feb 08, 2022 by Marian Vidra
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 SNP Glue™ table consumer using the SNP 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. (Glue-2202) Create SNP Glue™ table from external table 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 SNP Glue™ table fetcher using the SNP Glue™ table from step 1 and SNP Glue™ table consumer using the SNP Glue™ table created in step 2.

  4. Run the extraction process.