Hello everyone,

due to the nature of implicit joins in Celonis, I wonder if something like this is possible to do in Celonis FrontEnd.

Imagine this:

Table EKPO with many purchases of different materials, including their quantity and their price.

Table EBAN with many purchase requisitions of materials with their quantity but NO price (planned purchases in the future).

I already have created an OLAP with all purchases from EKPO aggregated to the material and the total price for that.

I now want a similiar OLAP with all planned purchases (purchase requisitions) from EBAN aggregated on material number.

But EBAN has no price. So I wanted to do a VLOOKUP like this:

We bought material X multiple times with the price of 10$ and that is shown in EKPO.

Now we still have 10 purchase requisitions with a total quantity of 100 of material X that are not a purchase order YET. All these purchase requisitions have NO purchase order since it wasnt created yet.

But since we bought material X for 10$, I want to multiply that 100 from EBAN with the latest price used for material X in an unrelated purchase order. The only relation is Materialnumber and plant.

Due to implicit joins it seems impossible to do that in the frontend. Am I wrong? Did someone have a similiar problem? And did you solve it in the backend?

Thanks!