Query from a UDT showing hundreds of records.

[lsauser]

Hey all,

I am trying to zone in on a row field from a service call pane added by coresuite. I believe i've managed to find the right table and field (i hope) but when I try and query it (or also use the field in a PLD which is the end goal here) i get not only the actual field information i am after but also seemingly hundreds of other rows that are not part of that service call. Below is a picture of the information I am trying to access, (1) is the line information and (2) is the system information.

By digging deeper into the UDF i noticed there was a table called @SWA_CT_EFFORTS which looked like the culprit and had an associated field called U_Remarks, i could very well be wrong though.

This is the query I am using below, as you can see i've tried isolating remarks only relating to the service call with T0.[DocNum] = '1286' however I am still getting a LOT of other records not even relating to that docnum.

Ultimately I need to get it to display only the rows in that effort pane (1 from the first image) in my PLD, but first i need to make sure i have the right table and field.

Any help will be much appreciated.

[jerryjanda]

Hi, Nick:

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Kind regards,

--Jerry

[lsauser]

Ok so as i understand it, my query is showing all the records from OSCL and combining them with all the records from @SWA_CT_EFFORTS

Is there a link or way we can query coresuite time records in SAP B1?