(Glue-2008) Glue Objects Generation

Owned by SNP
Last updated: Aug 18, 2020
6 min read

Glue Objects Generation is a tool that is used to generate multiple extraction objects from multiple sources which can be SAP tables, DSOs, InfoCubes or ADSOs. This functionality is available via transaction code /DVD/GL_OBJ_GEN.

Currently only the generation of Glue tables, Extractor 1.0 objects, and Extractor 2.0 objects is supported.

The main screen is divided into multiple sections. Each section is dedicated to specifying parameters for different objects or functionality settings. You can find Source selection, Glue table generation, Extractor generation, Extractor 2.0 generation and Settings parameters on the main screen.

Source selection

This section specifies the list of source objects for which we want to generate Glue objects. You need to select the object type and select-option specifying the selection of objects.

Parameters

  • Source type - Defines the type of all objects specified by the selection. SAP tables, DSOs, InfoCubes, and ADSOs are available.

Glue table generation

This section specifies the way Glue tables should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in Settings section.

Parameters:

  • Name prefix - Prefix of the Glue table. E.g. if ZGL_ is entered, the Glue table with name ZGL_MAKT will be generated for SAP table MAKT (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Name suffix - Suffix of the Glue table. E.g. if _TAB is entered, the Glue table with name MAKT_TAB will be generated for SAP table MAKT (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Package - Package in which you want to save your generated objects.

  • Storage ID - Target storage ID.

  • Meaningful fields - Flag indicating whether Meaningful fields functionality should be used.

  • Meaningful values - Flag indicating whether Meaningful values functionality should be used.

  • Add Glue request field - When checked, the field GLREQUEST will be added into Glue table structure.

  • Set Glue request as key - When checked, the field GLREQUEST will be a part of the primary key in the Glue table structure.

  • Settings for binary storage - Setting specific for binary storage. These settings will be ignored when transparent storage is used.

Storage ID is a mandatory parameter. You can use F4 help to select valid value for this parameters.

For more information about Glue tables see pages https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2229174926 and https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2229175188 .

Be aware that not all storages allow the name of the Glue table with a non-alphabetical character at the beginning.

Extractor generation

This section specifies the way Glue Extractor objects should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in Settings section.

Parameters:

  • Name prefix - Prefix of the Extractor 1.0 object E.g. if ZGL_ is entered, the Extractor object with name starting with ZGL_ will be generated. (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Name suffix - Suffix of the Extractor 1.0 object. E.g. if _TAB is entered, the Extractor object with name ending with _TAB will be generated. (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Package - Package in which you want to save your generated objects.

  • Target Glue table ID - ID of generated Glue table which will be set as a target. (This is the ID from Glue table generation section)

  • Delta type - Delta type used for data extraction.

  • Skip initial full load - When checked, the initial extraction will transfer no data. Just delta will be initialized.

  • Truncate target table - When checked, the target table will be truncated (data will be deleted) before each extraction.

  • Mark key fields for selection - When checked, the fields from the primary key will be used for selection in Glue Variants.

  • Do not activate - When checked, only objects with status saved will be generated.

  • Variant prefix - Prefix of the Variant (generally the Glue Variant name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Variant suffix - Suffix of the Variant (generally the Glue Variant name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Variant package size - Package size used for Glue Variant. This parameters specifies the number of rows transferred to the target storage within single package.

For more information about Glue Extractor 1.0 objects see the pages https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2229177164 and https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2229178060 with their sub-pages.

Extractor 2.0 generation

This section specifies the way Glue Extractor 2.0 objects should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in Settings section.

Parameters

All parameters are divided into 4 sections:

General

  • Name prefix - Prefix of the Extractor 2.0 object E.g. if ZGL_ is entered, the Extractor 2.0 objects with name starting with ZGL_ will be generated (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Package - Package in which you want to save your generated objects.

  • Target Glue table ID - ID of generated Glue table which will be set as a target. (This is the ID from Glue table generation section).

  • Do not activate - When checked, only objects with status saved will be generated.

Fetcher

  • Name suffix - Suffix of the Extractor 2.0 Fetcher. E.g. if _F is entered, the Fetcher with name ending with _F will be generated. (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Delta type - Delta type used for data extraction.

  • Load type - The mode of the data read for extraction execution.

  • Use deduplication - When checked, it removes duplicate values from a single data load, keeping only the latest value for each record. Relevant only for the ADSO source.

  • Mark key fields for selection - When checked, selected fields from the primary key will be used for selection in Glue Variants.

Glue Table Consumer

  • Name suffix - Suffix of the Extractor 2.0 Glue Table Consumer. E.g. if _C is entered, the Consumer with name ending with _C will be generated. (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

Extraction Process

  • Name suffix - Suffix of the Extractor 2.0 Extraction Process. E.g. if _P is entered, the Extraction Process with name ending with _P will be generated. (generally the Glue table name consist of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

For more information about Glue Extractor 2.0 objects see the pages Extractor 2.0 with its sub-pages.

Executing object generation

When the parameters are filled, based on your requirements, you can proceed to object generation itself.

You can choose from two options. You can either generate objects in dialog process by pressing Generate button from toolbar or generate objects in background job by pressing Generate (background) from the toolbar.

In case you choose Generate (background), the SAP standard dialog for background job scheduling will appear as shown in the following image:

In case you choose Generate in dialog process, you will see the pop-up with logs after object generation is finished. This logs will provide you with general overview about objects that were generated using this functionality. In the following image you can see an example: