We have connected one of our SAP system to Celonis with the O2C extractor provided by Celonis.We managed to execute the extractions in full load but when we are trying to execute the transformations in full load we are running into the next failure:

Hello,

Generally "ERROR: Relation "MAKT" does not exist" error means that the table is not existing, I would check first in the data pool if that's the true. It's possible that it is extracted but due to lack of data or/and wrong filtering (f.e. by wrong date field or using wrong join condition) no rows are returned. In that case celonis just doesn't create table at all. I had similar case with test SAP system and PP extractor provided by Celonis.

I would also investigate SAP data iself with SE16N transaction - from the other side. Hope it helps! :)

Best Regards,

Mateusz Dudek

Hello,

if MAKT is not always available (I would also investigate in SAP - SE16N and also check your extraction settings in Celonis) you can create an empty table at the beginning of the transformation with this code:

CREATE TABLE IF NOT EXISTS <%=insert here your sourxe data pool%>."MAKT" (

  MANDT varchar(12)

  ,MATNR  varchar(160)

  ,SPRAS  varchar(4)

  ,MAKTX  varchar(160)

  ,MAKTG  varchar(160)

  ,_CELONIS_CL_CHANGE_TYPE  varchar(4)

  ,_CELONIS_CL_TIMESTAMP  timestamp

  ,_CELONIS_CHANGE_DATE timestamptz(3)

);

But in my opinion it is quite unlikely that your MAKT is empty.

BR Thomas

Thank you Mukesh,

We inherited filters from another environment.