which SQL is used to build transformation scripts? is it possible to adjust template coding for predefined process? is it possible to join transparent and cluster tables (BKPF/BSEG, CDHDR, CDPOS)? how flexibly filter conditions for tables be applied?

Hello,

All the transformations are build in Vertica SQL, to check which scripts each transformation uses you can go to the transformation section into the EMS and check for the different queries (there is usually one per table created).

Yes, you can adjust the template coding, simply overwrite the transformations and once you save it, you can chose to make all those changes be added to the template transformations or just affect that transformation. Nevertheless, that will not affect the process conector transformation (as those affect every Celonis user) it will just affect your own transformations.

Yes, you can join/add/create/delete any table that you want in SQL just like you normally would as long as there are fields to join them for.

You can also add any filter conditions that you deem necessary completely flexibly, as I said, this will only affect your team's transformations

Hi,

To be more exact: currently Celonis data ingestion module use Vertica 10.1.x (At least accordingly to Celonis documentation - I'm unable to really check it with 'SELECT VERSION();' query) with limited set of functions:

A) Available function list for case-centric data pool: Supported Vertica functions for case-centric transformations (celonis.com)

B) Available function list for object-centric data pool: Supported functions for object-centric transformations (celonis.com)

Link to documentation of that specific Vertica version: SQL Functions (vertica.com)

In terms of cluster tables there are articles in Celonis Documentation about those

Replacing SAP cluster tables (BSEG) (celonis.com). In short: you can access them, but it's advice to replace them, for the reasons described in the article.

In you're interested in such topics I would recommend finishing Get data into EMS training track. It will answer all those questions, but also provide overall perspective on data topics with Celonis.

Best regards,

Mateusz Dudek