The following section describes the functions of the Xtract Table CDC component of Xtract IS.
The component can be used to extract delta contents from SAP tables. It creates a log table in SAP that record insert, update, and delete activities that apply to a selected SAP table.

Warning! Missing Authorization To use the Table CDC component, access to the designated authority objects (RFC) in SAP must be available. For more information, refer to the knowledge base article SAP User Rights: Table CDC.

Tip: To get information on the basics of Xtract Universal, refer to Getting Started.

About Table CDC #

Change Data Capture (CDC) is a method to keep track of data changes such as insert, update and delete in SAP tables. The Table CDC component creates a log table in SAP that records any changes made to a selected table. The content of the log table is cleared after every successful run of the extraction. Data that was not extracted is not cleared from the log table.

Note: Clusters, pool tables and views are not supported by the Table CDC component.

Requirements #

  • SAP version 7.40 SP05 or higher.
  • The installation of the custom function modules Z_THEO_DELETE_LOG_ENTRIES and Z_THEO_READ_TABLE version 2.10 or higher is mandatory. The SAP transport requests for the installation are provided in the installation directory C:\ProgramFiles\[XtractProduct]\ABAP\, see Custom function module for TableCDC.

  • Required function modules and their package hierarchy:

    Function Module Package Hierarchy
    DMC_DDIF_TABL_GET_WRAPPER ECC: CNVM → DMIS_BASIS_MWB → DMIS_BASIS → DMIS
    S4: CNV_DMC_REMOTE → DMIS_BASIS_MWB → DMIS_BASIS → DMIS
    IUUC_CREATE_TABLE CNV_INC_PROCESSING_REMOTE → DMIS_BASIS_INC_FW → DMIS_BASIS → DMIS
    IUUC_DD_TABL_DEL_WRAPPER IUUC_DD_TABL_DEL_WRAPPER → CNV_INC_PROCESSING_REMOTE → DMIS_BASIS_INC_FW → DMIS_BASIS → DMIS
    IUUC_COUNT_ENTRIES_LOGGING_TBL CNV_INC_PROCESSING_REMOTE → DMIS_BASIS_INC_FW → DMIS_BASIS → DMIS
    IUUC_CRE_ACT_ADBC_TRIGGER IUUC_CRE_ACT_ADBC_TRIGGER : CNV_IUUC_REMOTE → DMIS_BASIS_INC_FW → DMIS_BASIS → DMIS
    IUUC_DELETE_ADBC_TRIGGER CNV_IUUC_REMOTE → DMIS_BASIS_INC_FW → DMIS_BASIS → DMIS
    Z_THEO_READ_TABLE Z_THEO_READ_TABLE
    Z_THEO_DELETE_LOG_ENTRIES Z_THEO_CDC

Note: Support for IBM databases will be available in Q4 2023.

How to use the Xtract Table CDC component #

  1. Define a valid connection manager that connects to an SAP system, see Connection Manager.
  2. Drag&drop the Xtract component from the SSIS toolbox into your data flow task.
    Toolbox
  3. Double-click the component. The main window of the component opens. The majority of the functions of the component can be accessed using the main window.

More information on working with the Xtract Table CDC component is provided in the following sections.

Defining a Table CDC Extraction

WHERE Clause

Settings