If you have already downloaded the table you could create a new view on the original table.

i.e. 

CREATE or REPLACE VIEW "JEST_VIEW" AS

   SELECT *

   FROM “JEST”
;

Or are you asking if you can do a join on data that isn’t present in Celonis?

br Florian

Hi @florian.mrkvi,

I’m trying to do the join before they are present in celonis.

I’m trying an idea whre I first download the Tables AUFK and AFVC in the first extraction step an then add two more Extraction steps and there configure the Join Configuration:

Then I create a UNION and safe everything to a table JEST.

I hope this will do what I want…

Or is there maybe a better way?

I never had to use a join like this in an extraction so I can’t tell if there is a better way. You probably don’t have to download the AUFK and AFVC tables first to define a join. I assume you can reference the tables in the SAP database. But I’m just guessing. Pretty sure someone else can answer this better than me.

Good luck!