The data model looks like this.
(1) is VBAP
(2) is VBEP
(3) is MARA
(4) is MVKE
Now I created an OLAP table with columns from different SAP table.
When I now want to include the SAP field MVGR1 from table MVKE is receive following error message.
How should the formula look like by using e.g. DOMAIN_TABLE or BIND together with PU-Function so that I can display the field MVKE.MVGR1 in the OLAP-Table?
Hi
How are the tables linked to each other, regarding 1 to many relations?
For example:
VBEP - N:1 - VBAP - 1:N - MARA - 1:N - MVKE
This will help to understand how to setup the Pull Up functions.
VBEP - VBAP 1:n
MARA - VBAP 1:n
MARA - MVKE 1:n
Hi
the issue lies in the VBAP - MARA - MVKE relation, being in the format N:1:N. Here, a certain entry on the N side of the VBAP table does not know to which entry on the N side of the MVKE table it should be linked.
This can be solved by using a Pull Up function. Using an aggregation, you specify which single row (e.g. First/Last/Max/Min) from the MVKE table to link to the MARA table, and your connection therefore becomes N:1:1.
You can find all the details of the Pull Up (PU) functions on the Celonis Docs: https://docs.celonis.com/en/pull-up-aggregation.html
In your situation, if you want to keep the latest MVGR1 value (based on LDVFL) from the MVKE table, your code would be:
PU_LAST( “MARA” , “MVKE”.”MVGR1”, ORDER BY “MVKE”.”LDVFL” ASC)
I hope this helps!
thank you very much for your support!
I tried to use PU function before. Using PU_FIRST or PU_LAST the column always shows the same value for all articles and sales organizations. But this is not correct.
“MVKE”.”MVGR1 is dependent from the sales org. An article no. in the MARA can have a different “MVKE”.”MVGR1 based on the Sales org. (VBAK.VKORG)
VBAK - VBAP 1:n
In that case, I think it will be better if you include VKORG and VTWEG from VBAK to VBAP at transformation level and then link the MVKE table directly to VBAP using MANDT, MATNR, VTWEG, VKORG - these 4 columns as these are the primary keys in MVKE.
MVKE - VBAP - 1:N
I will try to check out this solution.
At the moment MVKE is connected to MARA and MARA is connected to VBAP. Trying to connect MVKE directly to VBAP I guess this will create duplicates.
Please link MVKE and VBAP at the data model level using the MANDT, MATNR, VTWEG, VKORG which are primary keys in MVKE. It should create a 1:N relation from MVKE to VBAP. Duplicate should not occur.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
