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

Owned by SNP
Aug 20, 2024
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. Create SNP Glue™ Table and import fields from the ABAP dictionary object based on your HANA view.

  2. Create Extractor 2.0 Objects 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 the 1st step.

  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 SNP Glue™ table from external table/view with option view checked and external object set to SQL view name of HANA CDS view.

  2. Create SNP Glue™ Table 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 Extractor 2.0 Objects the standard way with SNP Glue™ table fetcher using the SNP Glue™ table from the 1st step and SNP Glue™ table consumer using the SNP Glue™ table created in the 2nd step.

  4. Run the extraction process.