Solved
PU-Functions - I want to compare EKES.EINDT with EKET.EINDT (Case: Table: EKPO). I tried out the function PU_MAX(EKPO, "EKES"."EINDT") and PU_MAX(EKPO, "EKET"."EINDT"). The error message however does not disappear. Are there any other options?
+6
Best answer by manuel.wetze
In the Join Path I can see that it is actually N:1:N situation. So I guess you are on the right track to use PU function. BIND will not be necessary IMHO.
Pulling Data from EKET(N-side) to EKPO (1-side) with PU seems the right solution to me.
You could also pull EKES column to EKPO depending on what you are trying to solve
So in summary I would expect you approach to work. Maybe its worthwile to doublecheck if the "Quotes" are necessary in your syntax.
Or there is just any other column in your table that does not use PU function. If only a single PQL Column fails then the whole "table" will fail.
+4You can use the BIND function for 1:N:1 relationship, can refer to the following for the same
+8In the Join Path I can see that it is actually N:1:N situation. So I guess you are on the right track to use PU function. BIND will not be necessary IMHO.
Pulling Data from EKET(N-side) to EKPO (1-side) with PU seems the right solution to me.
You could also pull EKES column to EKPO depending on what you are trying to solve
So in summary I would expect you approach to work. Maybe its worthwile to doublecheck if the "Quotes" are necessary in your syntax.
Or there is just any other column in your table that does not use PU function. If only a single PQL Column fails then the whole "table" will fail.
+6Hello Abhishek and Manuel,
thank you so much for your input!
I solved the problem by incorporating the PU-function in every column.
BR
Julia Bauer
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.