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

If you have no data from the source table, this usually happens. Check the filter condition of the table and check the logs to see if you get 0 chunks in the extraction.

Thank you Mukesh,

We inherited filters from another environment.