(Glue-2002) Glue Objects Generation

Owned by SNP
Last updated: Mar 16, 2020 by Marian Vidra
5 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 or InfoCubes. This functionality is available via transaction code /DVD/GL_OBJ_GEN.

Currently only the generation of Glue tables and Extractor 1.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 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 selection. The SAP tables, DSOs and InfoCubes 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 0MATERIAL is entered, the Glue table with name 0MATERIALMAKT 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 0MATERIAL is entered, the Glue table with name MAKT0MATERIAL 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, field GLREQUEST will be added into Glue table structure.

  • Set Glue request as key - When checked, 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 (Glue-2002) Glue Objects Explained and (Glue-2002) Create a Glue Table .

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 0MATERIAL is entered, the Extractor object with name starting with 0MATERIAL 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 0MATERIAL is entered, the Extractor object with name ending with 0MATERIAL 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 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.

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 log screen after object generation is finished. This screen will provide you with general overview about objects that were generated using this functionality. In the following image you can see an example.