This article shows how to load data incrementally from an SAP Table based on date fields. The following example scenarios use the table VBAK (SAP Sales Document Header), which has two date fields: ERDAT for creation date and AEDAT for update date.

Extract Data using a Date Parameter #

The following example extracts data that was created or changed after a specific date. The date is provided as a parameter at runtime.

  1. Create a new Table extraction.
  2. Look up a table you want to extract data from, e.g., VBAK.
    VBAK-Table
  3. Open the WHERE clause tab of the Table component and enter the following criterion:
    ( VBAK~ERDAT GE @LastDate AND VBAK~AEDAT EQ '00000000' ) OR VBAK~AEDAT GE @LastDate
    This criterion extracts data if one of the following conditions is true:
    The data was created (ERDAT) after the date provided by the parameter @LastDate and it has not been changed (AEDAT).
    Or the data has changed (ARDAT) after the date provided by the parameter @LastDate. Where-Clause_Date-Param
  4. Click [OK] to confirm your input.
  5. Open the Run Extraction menu and navigate to the Custom tab for runtime parameters.
    Where-Clause_Run-Extraction-Param
  6. Enter a value for the @LastDate parameter in the format YYYYmmDD.
  7. Click [Run] and check the results.

Daily Data Extraction #

The following example extracts data that was created or changed the day before. This example uses script expressions to query the current date.

  1. Create a new Table extraction.
  2. Look up a table you want to extract data from, e.g., VBAK.
    VBAK-Table
  3. Open the WHERE clause tab of the Table component and enter the following criterion:
    (ERDAT >= '#{ DateTime.Now.AddDays(-1).ToString(\"yyyyMMdd\") }#' AND AEDAT = '00000000') OR AEDAT >= '#{ DateTime.Now.AddDays(-1).ToString(\"yyyyMMdd\") }#'
    This criterion extracts data if one of the following conditions is true:
    The data was created (ERDAT) the day before the current date and it has not been changed (AEDAT).
    Or the data has changed (ARDAT) the day before the current date. Where-Clause_Daily
  4. Click [OK] to confirm your input.
  5. Open the Run Extraction menu.
  6. Click [Run] and check the results.

This extraction can be scheduled every night at 1p.m. or later to extract all changes of the day before. Providing extraction dates is not necessary.