Skip to main content
Question

How to Connect VTTP table to LIPS Table ?

  • March 13, 2023
  • 2 replies
  • 28 views
R
Level 2

Hello, I'm trying to know how many different Materials I have inside a shipment. This shipment can have multiple DNs, when I try to create an OLAP table with Shipment Nº/Delivery No./ Material I get the following error: "No common table could be found. The tables ["VTTP"] and ["LIPS"] 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: [VTTP]N <-- 1![LIKP]!1 --> N[LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.". How can I solve this issue? Thank you

2 replies

badrinath.nooka13
Level 3
Forum|alt.badge.img+14

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)))

 

R
Level 2
  • rodrigo.viana
  • Author
  • Level 2
  • March 22, 2023

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 ["_CEL_O2C_ACTIVITIES"] and ["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![VBAP]!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

 

Community Code of ConductAccessibility statement