(Glue-2005) SAP Table Fetcher

Owned by SNP
Jun 02, 2020

The SAP Table Fetcher uses an SAP table as a data source. For data read provide multiple Delta types and Load types. It also supports filtering on selected data.

Creation of an SAP Table Fetcher

Perform the steps outlined in How to Create a Fetcher Object with SAP Table Fetcher as the option selected under the Component implementation dropdown of step 4.

Activation of an SAP Table Fetcher

After creation, the object is in the saved state.

Mandatory inputs to be filled before the activation

  • SAP Table
    • name of SAP table for data read
    • provided with F4 help
  • Delta type
    • a dropdown menu with all available delta types
    • for more information see 1463779344
  • Load type
    • default extraction type
    • changeable before each extraction
    • for more information see Load type

Optional inputs before the activation

  • Selection
    • checkbox for each field of the SAP table that allows you to mark them relevant for selection before the extraction

Delta type

The SAP Table Fetcher provides multiple delta types:

  • FULL, DATE, TMSTMP, VALUE, VALUE_DIST
  • TRIGGER

Trigger delta type for SAP Table Fetcher 

For general information about this delta type see Trigger delta.

Trigger state

On activation of the SAP Table Fetcher with delta type TRIGGER, the saving of newly added records is not automatically turned on (mentioned in the link above).
There are two ways to do this:

  • execute extraction with any Load type except the basic Full Load (Repair) Without Delta Update
  • manually activate triggers through the use of the (Glue-2005) Trigger Management functionality accessible via the Manage Trigger button

State of the trigger is also displayed next to Manage Trigger button. There are 3 different states in which the trigger can be: Active, Inactive, Inconsistent (can be repaired by reactivation of the trigger in Trigger Management).

Read deleted entries

After selecting the TRIGGER delta type, there is an additional setting available - Read deleted entries checkbox. When this is checked, also keys of entries that were deleted since the last extraction will be read after entries that were inserted or updated.