{"type":"doc","content":[{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"/DVD/GL_OBJ_GEN.","type":"text","marks":[{"type":"strong"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Currently only the generation of Glue tables, Extractor 1.0 objects, and Extractor 2.0 objects is supported.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The main screen is divided into multiple sections. Each section is dedicated to specifying parameters for different objects or functionality settings. You can find ","type":"text"},{"text":"Execution type","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Source selection","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Glue table generation, Extractor generation, Extractor 2.0 generation, and Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"parameters on the main screen. ","type":"text"},{"text":"You can save created settings via ","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"4eec1914-3749-4652-b1d1-47c27aee7b80"}}]},{"text":"Glue Object Generation Variant","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"4eec1914-3749-4652-b1d1-47c27aee7b80"}},{"type":"link","attrs":{"href":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564562724/Glue-2011+Glue+Object+Generation+Variant"}}]},{"text":". ","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"4eec1914-3749-4652-b1d1-47c27aee7b80"}}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1221,"id":"6b7783ac-8987-4a40-acfb-4dcea6c1787c","collection":"contentId-2564562571","type":"file","height":754}}]},{"type":"paragraph","content":[{"text":"Execution type ","type":"text"}]},{"type":"paragraph","content":[{"text":"This section defines possible ways for the Glue extraction process.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Parameters","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Standard execution","type":"text","marks":[{"type":"strong"}]},{"text":" - Generator will create all standard objects for Glue extraction (Glue table, Consumer, Fetcher, Process) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"FIFO asynchronous execution","type":"text","marks":[{"type":"strong"}]},{"text":" - Generator will create Glue object required for FIFO Glue extraction ( Glue table, 2 Consumers, 2 Fetchers, 3 Extraction Processes)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Source selection","type":"text"}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1066,"id":"b59e61b6-fac6-402d-b4db-bafee203e282","collection":"contentId-2564562571","type":"file","height":68}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Parameters","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source type","type":"text","marks":[{"type":"strong"}]},{"text":" - Defines the type of all objects specified by the selection. SAP tables, DSOs, InfoCubes, and ADSOs are available.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Glue table generation","type":"text"}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1213,"id":"fb67be94-578f-453c-a931-a23bf0282bb9","collection":"contentId-2564562571","type":"file","height":563}}]},{"type":"paragraph","content":[{"text":"Parameters:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix - ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the Glue table. E.g. if ZGL_ is entered, the Glue table with the name ","type":"text"},{"text":"ZGL_","type":"text","marks":[{"type":"strong"}]},{"text":"MAKT will be generated for SAP table MAKT (generally the Glue table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix - ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the Glue table. E.g. if _TAB is entered, the Glue table with the name MAKT","type":"text"},{"text":"_TAB ","type":"text","marks":[{"type":"strong"}]},{"text":"will be generated for SAP table MAKT (generally the Glue table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package - ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Storage ID - ","type":"text","marks":[{"type":"strong"}]},{"text":"Target storage ID.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Meaningful fields ","type":"text","marks":[{"type":"strong"}]},{"text":"- Flag indicating whether ","type":"text"},{"text":"Meaningful fields functionality","type":"text","marks":[{"type":"link","attrs":{"href":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564556578/Glue-2011+Additional+Features+of+a+Glue+table"}}]},{"text":" should be used.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Meaningful values - ","type":"text","marks":[{"type":"strong"}]},{"text":"Flag indicating whether","type":"text"},{"text":" Meaningful values functionality","type":"text","marks":[{"type":"link","attrs":{"href":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564556578/Glue-2011+Additional+Features+of+a+Glue+table"}}]},{"text":" should be used.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add deletion flag - ","type":"text","marks":[{"type":"strong"}]},{"text":"Flag will add a field for the deletion flag. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do not activate","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"-","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, only objects with status saved will be generated.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add Glue request field - ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked, the field GLREQUEST will be added to the Glue table structure.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set Glue request as key - ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked, the field GLREQUEST will be a part of the primary key in the Glue table structure.","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Settings for binary storage -","type":"text","marks":[{"type":"strong"}]},{"text":" Setting specific for binary storage. These settings will be ignored when transparent storage is used.","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"Storage ID is a mandatory parameter. You can use F4 help to select a valid value for these parameters.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"For more information about Glue tables see pages ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564556162"}},{"text":" and ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564556424"}},{"text":".","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Be aware that not all storages allow the name of the Glue table with a non-alphabetical character at the beginning. ","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Extractor generation","type":"text"}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1064,"id":"8a54c2c6-1ebb-4e4b-b297-1261f69341e5","collection":"contentId-2564562571","type":"file","height":580}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Parameters:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix - ","type":"text","marks":[{"type":"strong"}]},{"text":"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 ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix - ","type":"text","marks":[{"type":"strong"}]},{"text":"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 ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package - ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Target Glue table ID - ","type":"text","marks":[{"type":"strong"}]},{"text":"ID of generated Glue table which will be set as a target. (This is the ID from the ","type":"text"},{"text":"Glue table generation ","type":"text","marks":[{"type":"strong"}]},{"text":"section)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delta type - ","type":"text","marks":[{"type":"strong"}]},{"text":"Delta type used for data extraction.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Read deleted entries - ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked with Trigger delta, extraction will also transfer deleted records. ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Skip initial full load ","type":"text","marks":[{"type":"strong"}]},{"text":"- When checked, the initial extraction will transfer no data. Just delta will be initialized.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Truncate target table ","type":"text","marks":[{"type":"strong"}]},{"text":"- When checked, the target table will be truncated (data will be deleted) before each extraction.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mark key fields for selection ","type":"text","marks":[{"type":"strong"}]},{"text":"- When checked, the fields from the primary key will be used for selection in Glue Variants.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do not activate","type":"text","marks":[{"type":"strong"}]},{"text":" - When checked, only objects with status saved will be generated.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variant prefix - ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the Variant (generally the Glue Variant name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variant suffix ","type":"text","marks":[{"type":"strong"}]},{"text":"- Suffix of the Variant (generally the Glue Variant name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variant package size - ","type":"text","marks":[{"type":"strong"}]},{"text":"Package size used for Glue Variant. This parameter specifies the number of rows transferred to the target storage within a single package.","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"For more information about Glue Extractor 1.0 objects, see the pages ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564558444"}},{"text":" and ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564559346"}},{"text":" with their sub-pages.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Extractor 2.0 generation","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"2aa6a669-58e3-4fdd-b853-f30f4a5726b1"}}]}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1068,"id":"051b790c-89a3-44be-9d9b-4e90f2065b6b","collection":"contentId-2564562571","type":"file","height":576}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Parameters","type":"text"}]},{"type":"paragraph","content":[{"text":"All parameters are divided into 4 sections:","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"General","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix - ","type":"text","marks":[{"type":"strong"}]},{"text":"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 ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package - ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Target Glue table ID - ","type":"text","marks":[{"type":"strong"}]},{"text":"ID of generated Glue table which will be set as a target. (This is the ID from the ","type":"text"},{"text":"Glue table generation ","type":"text","marks":[{"type":"strong"}]},{"text":"section).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do not activate","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"-","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, only objects with status saved will be generated.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Fetcher","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix - ","type":"text","marks":[{"type":"strong"}]},{"text":"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 ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delta type - ","type":"text","marks":[{"type":"strong"}]},{"text":"Delta type used for data extraction.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Read deleted entries - ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked with Trigger delta, extraction will also transfer deleted records. ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Load type - ","type":"text","marks":[{"type":"strong"}]},{"text":"The mode of the data read for extraction execution.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use deduplication","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"-","type":"text","marks":[{"type":"strong"}]},{"text":" 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. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mark key fields for selection -","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, selected fields from the primary key will be used for selection in Glue Variants.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Glue Table Consumer","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix - ","type":"text","marks":[{"type":"strong"}]},{"text":"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 ++).","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Extraction Process","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix - ","type":"text","marks":[{"type":"strong"}]},{"text":"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 ++).","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"For more information about Glue Extractor 2.0 objects, see the pages ","type":"text"},{"text":"Extractor 2.0","type":"text","marks":[{"type":"link","attrs":{"href":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2564559622/Glue-2011+Extractor+2.0"}}]},{"text":" with its sub-pages.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Executing object generation","type":"text"}]},{"type":"paragraph","content":[{"text":"When the parameters are filled, based on your requirements, you can proceed to object generation itself.","type":"text"}]},{"type":"paragraph","content":[{"text":"You can choose from two options. You can either generate objects in the dialog process by pressing the ","type":"text"},{"text":"Generate","type":"text","marks":[{"type":"strong"}]},{"text":" button from the toolbar or generate objects in the background job by pressing ","type":"text"},{"text":"Generate (background) ","type":"text","marks":[{"type":"strong"}]},{"text":"from the toolbar.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":871,"id":"3c533801-d223-428e-876a-756f59769664","collection":"contentId-2564562571","type":"file","height":82}}]},{"type":"paragraph","content":[{"text":"In case you choose ","type":"text"},{"text":"Generate (background)","type":"text","marks":[{"type":"strong"}]},{"text":",","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"the SAP standard dialog for background job scheduling will appear as shown in the following image:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":730,"id":"80266e7c-58d1-47b1-b49e-a92a88f07a4d","collection":"contentId-2564562571","type":"file","height":604}}]},{"type":"paragraph","content":[{"text":"In case you choose to ","type":"text"},{"text":"Generate","type":"text","marks":[{"type":"strong"}]},{"text":" 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:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":612,"id":"34e6e67d-5644-42de-b608-50a0e76ea537","collection":"contentId-2564562571","type":"file","height":432}}]},{"type":"paragraph"}],"version":1}

Browser not supported