(Glue-2405) Reverse Flow

In the scenario of external table replication (typically Reverse flow), four components form each replication process – Glue Table from the external table, Glue Table fetcher, the SAP Table consumer, and the Extraction Process. These four components represent a configuration – setting up the source object, target object, and transformation rules. The following steps navigate you through the preparation of the whole flow – creating all required objects and executing the load.

1. Creating Glue table:

   1. Run the transaction /DVD/GL80, and select Object Navigator.

   2. Right-click on the package. Choose the possibility Create GLUE table from external.

   3. A pop-up comes up. Fill in the name of the newly created Glue table – the name of the target table. Then fill in the name of the source External table and choose the appropriate Storage ID on which the source table exists. The package is populated automatically but you can change it. Confirm.
      
      

      Open

      

   4. The table will be automatically created and activated, and you can check the tabs Attributes and Fields. The Glue table in this case represents the structure of the external object, which will be read during data transfer execution.
      
      

      Open

      

      
      
      

2. Creating GLUE table Fetcher:

   1. Run the transaction /DVD/GLUE, and select Object Navigator.

   2. Right-click on the desired package and select Create Extractor 2.0 object.

   3. A pop-up appears. Enter the name of the new Fetcher in the Object name.

   4. Select GLUE Table Fetcher in the Component type dropdown and confirm the pop-up.
      
      

   5. Fill in the GLUE table with the required GLUE table name from the first step and press ENTER. For a basic scenario, we will leave the Delta type to FULL. Further options can be found in the documentation.

   6. The fields from the GLUE table will be added to part of the Filter definition. If you want to load data with a selection (filter on some fields), check the checkbox in column Selection for these fields.
      
      

   7. Activate fetcher.
      
      
      

3. Creating SAP table Consumer:

   1. Run the transaction /DVD/GLUE, and select Object Navigator.

   2. In the context menu(right-click) of the desired package select option Create Extractor 2.0 object.
      
      

   3. Enter the name of the new Consumer in the Object name and select Consumer under the Component type dropdown and the SAP table consumer under the Component implementation dropdown.

   4. Confirm the pop-up.

   5. After creation, the object is in the saved state. Fill in the SAP table name (Z* SAP table needs to be precreated manually in the target system. SNP Glue does not create this Z* table) and press ENTER.
      
      

   6. Activate consumer.
      
      
      

4. Creating Extraction Process:

   1. Run the transaction /DVD/GLUE, and select Object Navigator.

   2. In the context menu(right-click) of the desired package, select the option Create Extractor 2.0 object.

   3. Enter the name of the new Extraction Process under the Object name.

   4. Select Extraction Process under the Component type dropdown and Component implementation dropdown.
      
      

   5. Confirm pop-up.

   6. Insert the Fetcher name and Consumer name created in the steps before. Press ENTER.

   7. Suggest a transformation mapping button in the toolbar. The mapping between target and source fields is now created in a 1:1 fashion. Further options for modification of the rules are described in the documentation.
      
      

   8. Activate extraction process.
      
      
      

5. Executing Extraction Process:

   1. Click Execute.
      
      

   2. Execute(F8) the replication with default settings. Select Background and Immediate in upcoming pop-ups for scheduling SAP jobs.