(Glue-2308) Objects Generation for the Extraction of SAP Table

Owned by SNP
Aug 23, 2023
4 min read

SNP Glue™ Objects Generation is a tool that is used to generate multiple extraction objects – you will create a whole flow for extraction in one step. In the simplest scenario of SAP table replication, four components are forming each of the replication processes – Glue Table, SAP Table fetcher, Glue Table consumer, and Extraction Process. These four components represent a configuration – setting up source object, target object and transformation rules. When you use the tool Objects Generation you can create all four necessary objects together. The tool can be used for mass generation of object – so you could create whole flows for more tables at once. The following steps show you the simplest way how to use the tool – creating all required objects for more tables in case of full loads.

Prerequisites: Prepare the development package in SE80 which could be used for all Glue objects. In our case will be used ZLM_TEST.

Step list:

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

  2. Click Generate table replication objects in the toolbar:


    You will be then redirected to transaction /DVD/GL/OBJ_GEN.

  3. On the top of the screen, you have the part Source Selection. Choose the Table/View in the dropdown menu and then enter the names of the tables for which you want to create replication flow.

  4. Now you see the settings for Glue table replication on the right side of the screen.

    1. Change the field Package – insert the name of the development package from the prerequisite (you can use the default $TMP, but it is recommended to use your package). Press Enter.

    2. Fill in the field Storage ID with the name of your target storage. Press Enter.

    3. Fill in the field Glue change time field: GLCHANGETIME. This action will add the field GLCHANGETIME with data type: DEC, length: 21, dec places: 7 to the target glue table. Press Enter.

    4. Leave the rest of the settings as default. Only one setting is checked – Add Glue request – this setting means that the field GLREQUEST with data type: DEC, length: 30, dec places: 0 is added automatically to your target glue table.

    5. Settings for binary storage are useful only in case you use binary storage.

    6. Click on Details in part Glue table generation.

    7. Now you will see the values from right side of screen in the first row in part Glue table generation.

  5. Click on Details in part Extractor 2.0 generation.

  6. The settings on the right side of the screen are changed. Now there are four types of settings – General, settings for Fetcher, settings for Consumer, and settings for Extraction Process.

    1. In the General settings fulfil the name of Package by the name of your package for glue objects. Press Enter.

    2. Fulfil the rest of the General settings according to the screenshots and press enter.

    3. The settings for Fetcher, Consumer and Extraction process leave as default.

    4. Click on button Details in part Extractor 2.0 generation.

    5. Now you will see the values from the right side of the screen in the first row in part Extractor 2.0 generation.

  7. Click on Generate button:


    You get the logs from generation:


    In case of a bigger selection of tables, we recommend clicking on Generate (background). In that case logs from generation can be found in SM37.

  8. You will find the newly created objects in the Object generator. Start transaction /DVD/GLUE and click Object Navigator.