Skip to main content

Celonis Product Documentation

One Time Extraction from SAP ECC and S/4

The recommended data integration option between the on-premise SAP system and Celonis EMS is the continuous connection. It allows to replicate the data in real-time from any whitelisted table in SAP, and ensures a constant flow of data for operational use cases. However, if the continuous connection is not feasible, there is the alternative of the one-time extraction. It is not recommended though, because usually takes more time and resources on both sides. It should be considered only if the continuous connection is absolutely not feasible.

To facilitate the one-time extraction process, Celonis provides tools to export and upload the data from SAP. While theoretically, users can leverage native SAP tools to export the data, i.e. the transaction code SE16, in practice these tools are not performant enough for the big data use cases. To address this gap, Celonis has developed its ABAP Report which is a GUI program that is run directly in SAP and can export big data from it. The Report is generated dynamically based on the user-defined data scope and then is executed in SAP by the customer's Basis team. This produces csv files, which should be uploaded into EMS via the ABAP Output Uploader, another Celonis tool.

The overall process consists of 3 parts:

The table below explains the e2e process, and which user is responsible for the respective step.

Celonis User

SAP BASIS

1

Downloads the process connector template from the Celonis Marketplace

2

Defines the data scope in the one time ABAP Extraction Data Job

3

Generates the ABAP Report based on the data scope defined in step 2

4

Sends the ABAP Report to the customer's BASIS team

5

Executes the report in SAP

6

Uploads the files to Celonis EMS via the EMS ABAP Uploader or an SFTP client

7

Imports the uploaded files into Celonis cloud database via the ABAP Uploader tool