HI Derek
I didn't have PLKO for the description of the task list, so I added it and didn't get duplicates.
Here are my joins. Check out the work center plant joins - I don't know if you have them.
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 08-27-2020 16:27
From: Derek Sayres
Subject: query for reference operation set numbers not displaying all results
Thank you both very much! That really helped me get closer. I am now experiencing a different issue where I am getting too many results.
for this particular reference operation set I have 38 entries, the PLPO table has 76 entries based off changes, the PLAS table has 42 entries, only two of them have a deletion indicator.
is there another table I need to add to limit the results to only what's currently in the reference operation set (task list type S)?
Thanks,
Derek
------------------------------
Derek Sayres | SAP PLM Business Analyst
Original Message:
Sent: 08-26-2020 13:28
From: sigrid kok
Subject: query for reference operation set numbers not displaying all results
FYI, in the example I attached, I'm using PLAS, too.
S-
------------------------------
Sigrid Kok
PSE | Winshuttle NA
Original Message:
Sent: 08-26-2020 12:56
From: JENNIFER HWANG
Subject: query for reference operation set numbers not displaying all results
Hey Derek -
What happens if you remove the Internal Counter join? I have an example that works but I actually have an intermediate table PLAS being used to join PLPO and PLKO. That might also be an option to try.
Thank you!
------------------------------
JENNIFER HWANG | SE
Winshuttle North America
Original Message:
Sent: 08-25-2020 22:06
From: Derek Sayres
Subject: query for reference operation set numbers not displaying all results
Hello,
I am trying to query reference operation set header data and operation numbers. I am passing in task list type S, the group number and the plant from the PLKO table.
When I go into SE16 to check the results I am only seeing 8 entries in Winshuttle, the PLPO table shows 9.
------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------