Hi Team,
I am trying to use standard Three way match formulas from App store.
It is showing the below error message:
Pull-Up-Function could not be executed. Table EKPO is not a child of table EKBE. Use a non Pull-Up-Function instead.
In the data model, the tables EKPO (case table) and EKBE are joined on the columns MANDT, EBELN & EBELP.
Could you please suggest what could be the cause of the issue?
Page 1 / 1
Hi Team,
The data model is showing the join between EKBE to EKPO as 1:n. Hence, in Celonis, EKBE has become child table I believe. This looks opposite to usual.
Can you suggest if it is only due to underlying data or is there any setting available to do in the model to modify to specify the right relationship between the 2 tables?
Regards,
Shiva
The data model is showing the join between EKBE to EKPO as 1:n. Hence, in Celonis, EKBE has become child table I believe. This looks opposite to usual.
Can you suggest if it is only due to underlying data or is there any setting available to do in the model to modify to specify the right relationship between the 2 tables?
Regards,
Shiva
Hi @shiva.ponna.cg
I guess that in your case, you actually have a 1:1 relationship in your data between the two tables, which means that there are no duplicates in the (foreign) keys of both tables. However, all join relationships are always regarded as 1:N relationships in Celonis.
In the case of a 1:1, it cannot be determined automatically what the N-side and what the 1-side of the join is (because both is possible). Instead, the order set in the data model editor is used. The table on the left (source table) is then taken as the child table (1 side), and the one on the right (target table) is taken as the parent table (N side):
image1442545 19 KB
So in order to fix the issue, I would suggest to flip the tables of the foreign key in the data model editor. In your case, the EKPO table should be on the left, and the EKBE table should be on the right. After doing that, you need to do a complete reload of your data model.
Hope this helps!
Best
David
I guess that in your case, you actually have a 1:1 relationship in your data between the two tables, which means that there are no duplicates in the (foreign) keys of both tables. However, all join relationships are always regarded as 1:N relationships in Celonis.
In the case of a 1:1, it cannot be determined automatically what the N-side and what the 1-side of the join is (because both is possible). Instead, the order set in the data model editor is used. The table on the left (source table) is then taken as the child table (1 side), and the one on the right (target table) is taken as the parent table (N side):
image1442545 19 KB
So in order to fix the issue, I would suggest to flip the tables of the foreign key in the data model editor. In your case, the EKPO table should be on the left, and the EKBE table should be on the right. After doing that, you need to do a complete reload of your data model.
Hope this helps!
Best
David
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.