Skip to main content

Celonis Product Documentation

SAP Extractor new version (RFC Module: 3.1, Extractor: 3.7/2021-11-16)

The new SAP Extractor (RFC Module: 3.1, Extractor: 3.7.0/2021-11-15) has been released and is available for download on this page.

Changes in the RFC Module
The Change log tables can be created per process with one click in the /Celonis/CLMAN_UI

The button 'Add Change Log Table(s)' opens a pop-up to add one or multiple change log tables. Additionally, you can select one or multiple processes (AP, AR, O2C, P2P are available) and the required tables are automatically added.

59048652.png

Note

This version on the FULL transport does not contain any pre-packaged Changelog tables anymore. Instead, they can be created per process in the /CELONIS/CLMAN_UI

The Changelog timestamp is now captured in microseconds

In previous versions, the timestamp of an operation (insert, update, delete) in the Change log table was captured in seconds. This can lead to inconsistencies of the deletions in case an insert/update was captured at the same time as a deletion. With this version, we allow the creation of changelog tables and triggers that can capture the timestamp in microseconds. This allows better accuracy for determining the sequence in which different operations have happened.

Compatibility

This feature requires the re-creation of the changelog tables and triggers and at least the Extractor v 3.7.0. Older Extractor versions are not compatible.

The RFC module is still compatible with older Extractor versions in case the changelogs and triggers were created with an older RFC module (not supporting microseconds).

Added the system timezone as an offset for the dependency of CDHDR/CDPOS according to the system timezone

The SAP system timezone is now fetched and shown in the Extractor information.

This timezone is applied as an offset on the dependency filter on CDHDR/CDPOS in the Replication Cockpit. Previously, the UDATE+UTIME were used to generate this dependency filter which led to a lag in the record processing because dates from different timezones (UTC + system timezone) were compared with each other.

Checks and validations when creating a Change Log table

In /CELONIS/CLMAN_UI there is a new button 'Check Tables' which allows you to validate the Change log tables before creating them. The feature checks

  • if the table is transparent

  • the changelog table name

  • if the table already exists in the table /CELONIS/CLMAN

  • if the table already exists in the SAP system according to DDIC

  • if the table already exists in the database

Additionally, we are also validating whether a Change Log table exists in the database before creating a corresponding change log.

Changes in the Extractor
Added the system timezone as an offset for the dependency of CDHDR/CDPOS according to the system timezone

The SAP system timezone is now fetched and shown in the Extractor information.

This timezone is appledd as an offset on the dependency filter on CDHDR/CDPOS in the Replication Cockpit. Previously, the UDATE+UTIME were used to generate this dependency filter which led to a lag in the record processing because dates from different timezones (UTC + system timezone) were compared with each other.

The Changelog timestamp is now captured in microseconds

The extractor is now supporting changelog timestamps in microseconds (instead of seconds).