Show TOC

Testing ExtractionLocate this document in the navigation structure

Use

You can use this function to test extraction from DataSources that were created using the maintenance for the generic DataSource. After the test extraction, you can display the extracted data and the associated logs.

Procedure
  1. Choose DataSource  →   Test Extraction.

    A screen appears in which you can set parameters and selections for the test extraction.

  2. Enter a request no. for the test extraction via a function module.
  3. Enter how many data records are to be read with each extractor call.
  4. The extractor is called up by the Service API until no more data is available. In the Display Extr. Calls field, you can specify the maximum number of times the extractor is to be called. This enables you to restrict the no. of data packages when testing the extraction. With a real extraction, the system transfers data packages until is no longer able to find any more data.
  5. Depending on the definition of the DataSource, you can test the extraction in various update modes.

    For DataSources that support the delta method, you can also test deltas and repeats as well as the full update.

    The modes delta and repeat are only available for testing when the extractor supports a mode in which the system reads the data but does not modify the delta management status tables.

    Caution
    • To avoid errors in BW, the timestamp or pointer that was set in delta management must not be changed during testing.
    • Before you are able to test the extraction in a delta mode in the source system, you need to have carried out an initialization of the delta method or a simulation of such an initialization for this DataSource.

    You can test the transfer of an opening balance for non-cumulative values.

  6. Specify selections for the test extraction.

    Only those extract structures fields you have selected in DataSource maintenance can be selected.

    To enter several selections for a field, insert new rows for this field into the selection table.

  7. Choose whether you want to execute the test extraction in debug mode or by tracing an authorization trace.

    If you test the extraction in the debug mode, a breakpoint is set just before the extractor initialization call.

    For information on the debugger, see ABAP Workbench: Tools.

    If you set an authorization trace, you can call it after the test by choosing Display Trace.

  8. Start the extraction.
Result

If the extraction was successful, a message appears that specifies the number of extracted records. The buttons Display List, Display Log and Display Trace (optional) appear on the screen. You can use Display List to display the data packages. By double-clicking on the number of records for a data package, you get to a display of the data records. Choose Display Log to display the application log.