(Glue-2411) Extraction of HANA Calculation View

In the simplest scenario of Calculation view replication, there are four components forming each of the replication processes – Glue Table, HANA View fetcher, Glue Table consumer, and Extraction Process. These four components represent a configuration – setting up the source object, target object, and transformation rules. Following steps navigate you through the preparation of the whole flow – creating all required objects and executing the load.

Mandatory prerequisite for this replication is to have a HANA Native connection created in Storage Management.

  1. Creating Glue table:

    1. Start transaction /DVD/GLUE and click Data Dictionary.

    2. Enter the name of a new table and click Create. You can enter the description of the table.

    3. Under the Attributes tab fill in the Storage ID (for binary storages necessary to fulfill the File storage options, too).

    4. Under the Fields tab field GLREQUEST with data type: DEC, length: 30, dec places: 0 is added automatically.

    5. Under the Fields tab click on Import Fields, choose From External Table/View and fill in the name of the Calculation view. Fill in the name of Storage ID (where the source Calculation view is located) and checked the checkbox Object is view.

    6. The structure from the source SAP table will be imported. You can manually adjust the fields as required.

    7. Click Save. If the table was not saved before, the system will ask you to fill in the Package. If you have a development package created upfront designated for SNP Glue development, you can use that package. Otherwise, for isolated sandbox purposes, $TMP will do.

    8. Click Activate. Only after you activate the SNP Glue table, it is created on storage.


  2. Creating HANA View Fetcher:

    1. Start transaction /DVD/GLUE and click Object Navigator.

    2. In the context menu of the desired package select Create Extractor 2.0 object.

    3. A pop-up appears. Enter the name of the new Fetcher in Object name.

    4. Select HANA View Fetcher in the Component type dropdown and confirm the pop-up.

    5. Fill in Storage ID and Schema (Storage ID and Schema where Calculation View could be found). Fill in the HANA View by the required HANA View name and press ENTER. The checkbox Table is view must be checked in this case. For a basic scenario, we will leave the Delta type to FULL. Further options can be found in the documentation.

    6. The fields from the Calculation view will be added to part Filter definition. Input Parameters from the Calculation view will be shown in part Filter definition. If you want to load data with a selection (filter on some fields), check the checkbox in column Selection for these fields.

    7. Activate fetcher.


  3. Creating Consumer:

    1. Start transaction /DVD/GLUE and click Object Navigator.

    2. In the context menu of the desired package select Create Extractor 2.0 object.

    3. Enter the name of the new Consumer in the Object name and select Consumer under the Component type dropdown and the GLUE table consumer under the Component.

    4. Confirm the pop-up.

    5. After creation, the object is in the saved state. Fill in the Glue table name and press ENTER.

    6. Activate consumer.

  4. Creating Extraction Process:

    1. Start transaction /DVD/GLUE and click Object Navigator.

    2. In the context menu of the desired package select Create Extractor 2.0 object.

    3. Enter the name of the new Extraction Process under the Object name.

    4. Select Extraction Process under the Component type dropdown and under the Component implementation dropdown.

    5. Confirm pop-up.

    6. Insert the Fetcher name and Consumer name created in the steps before. Press ENTER.

    7. Suggest transformation mapping button in the toolbar. The mapping between target and source fields is now created in a 1:1 fashion. Further options for modification of the rules are described in the documentation.

    8. Activate extraction process.

  5. Executing Extraction Process:

    1. Click Execute.

    2. Execute(F8) the replication with default settings. Select Background and Immediate in upcoming pop-ups for scheduling SAP jobs.