You First need to pull the number of distinct materials from table LIPS to LIKP with PU_COUNT_DISTINCT(LIKP, LIPS.MATNR) . After that the result should be attached to table VTTP with BIND(VTTP, PU_COUNT_DISTINCT(LIKP, LIPS.MATNR)) Finally the distinct number of materials per shipment should be calculated with PU_COUNT_DISTINCT(VTTK, BIND(VTTP, PU_COUNT_DISTINCT(LIKP, LIPS.MATNR)))

Hello, this solved my problem, on a new analysis however this methodology is not working.

I'm trying to analyze the changes on the delivery headers (LIKP) but I wanna filter a specific plant. When I try to creat an OLAP table with the changes and the plant (LIKP.VSTEL) I get the following error message:

"No common table could be found. The tables s"_CEL_O2C_ACTIVITIES"] and d"LIKP"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: :_CEL_O2C_ACTIVITIES]N <-- 1!1VBAP]!1 --> N VBFA]N <-- 1 LIPS]N <-- 1 LIKP]. For more information on the join path, search for "Join functionality" in PQL documentation.", Does anyone know how to join these two tables ?

Thank you!

• I am trying to bind the colllums but its not working