(Glue-2108) Capturing of deleted entries

Owned by SNP
Last updated: Aug 17, 2021 by Marian Vidra
2 min read

In addition to the standard SAP table to Storage extraction, the SAP Table Fetcher with trigger delta can be set up to transfer also deleted records. These records will have only key field values filled in the target Glue Table. If you want to distinguish them further, a deletion flag field can be added to the Glue table, which will have a value ‘D' filled for deleted records using the rule ‘Delete flag’ in the Extraction Process transformation mapping. Please note, that deleted records are transferred after standard inserted/updated records.

Additional steps to standard SAP table to Storage extraction

  1. To add the deletion flag field, go to Glue Table and add the GLDELFLAG field using the button Add deletion flag. You can also add your own field, but in that case, the rule in the Extraction process won’t be assigned automatically.

     

  2. In the SAP Table Fetcher, check the Read deleted entries checkbox.

     

     

  3. In the Extraction Process, the rule Delete flag should be assigned automatically using the Suggest transformation mapping button, if the default deletion flag field was used in step 1. Otherwise, select the rule manually.