(Glue-2105) Glue Objects Generation

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 are 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 Execution type, Source selection, Glue table generation, Extractor generation, Extractor 2.0 generation, and Settings parameters on the main screen. You can save created settings via Glue Object Generation Variant.

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 an 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 the Settings section.

Parameters:

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

  • Name suffix - Suffix of the Glue table. E.g. if _TAB is entered, the Glue table with the name MAKT_TAB will be generated for SAP table MAKT (generally, the Glue table name consists 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.

  • Add deletion flag - Flag will add a field for the deletion flag.

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

  • Add Glue request field - When checked, the field GLREQUEST will be added to the 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. More information can be found in the chapter File storage options.

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

For more information about Glue tables, see the following pages Glue Objects Explained and 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 the Settings section.

Parameters:

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

  • Name suffix - Suffix of the Extractor 1.0 object. E.g. if _TAB is entered, the Extractor object with a name ending with _TAB will be generated (generally, the Glue table name consists 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 the Glue table generation section)

  • Delta type - Delta type used for data extraction.

    • Read deleted entries - When checked with Trigger delta, extraction will also transfer deleted records.

  • 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 consists of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

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

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

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 the 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 a 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.

  • Source object type - type of the source object

    • DDIC - DDIC object

    • GL_TAB - Glue table

    • QUEUE - Glue Queue object

  • Source object ID - for DDIC source object type the value should be “0”. This is automatically added after entering the DDIC source type and pressing enter.

  • Target object type - type of the target object

    • GL_TAB - Glue Table

    • QUEUE - Glue Queue object

  • Target object ID - ID of a generated object which will be set as a target (this is the ID from the 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 a name ending with _F will be generated (generally, the Glue table name consists of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Delta type - Delta type used for data extraction.

    • Read deleted entries - When checked with Trigger delta, extraction will also transfer deleted records.

  • 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 a name ending with _C will be generated (generally, the Glue table name consists of <PREFIX>+<TABLE_NAME>+<SUFFIX>).

  • Enable merge - This flag enables merge functionality in the Consumer

Extraction Process

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

  • Apply field routines - This flag automatically applies to all field routines.

Queue processing

The queue processing button will prefill automatically 2 groups of Extraction 2.0 object necessary for Queue execution:

  1. The first group is handling insertion into Glue Queue (from SAP table to Glue Queue)

  2. The second group is handling pulling data from Queue (from Glue Queue to Glue table (any target))

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 the dialog process by pressing the Generate button from the toolbar or generating objects in the background job by pressing Generate (background).

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 to Generate in the dialog process, you will see the pop-up with logs after object generation is finished. These logs will provide you with a general overview of objects that were generated using this functionality. In the following image you can see an example: