Automate

Hello, I'm wondering if anyone has run into situations where a query does not display current accurate results?



------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Hey Derek,

Do you know if the table you are using also uses Validity Periods, or if there is a Deleted or Active / Inactive field?

Many times the data will remain in the table as a new record, and just have an indicator on the table that says it's no longer active.

Could you share your script and we can take a look further?


------------------------------
James Lofgren | Solutions Engineer
Winshuttle North America | [City] |
------------------------------

Original Message:
Sent: 09-17-2019 13:32
From: Derek Sayres
Subject: query not showing exact results

Hello, I'm wondering if anyone has run into situations where a query does not display current accurate results?

The routing in this case is set to Continuous flow prod, however the query shows optional overlapping.

I'm using today's date for both display in SAP and the query, I tried running the query with a material number as an input or the routing group number, both delivered the same result. I do know that the step had been set to optional overlapping at one point, but has been updated for months.

Thanks for any input.

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Hi Derek

Tried to create a query for the Routing fields you had, and mine show up properly.  I was having issues with lots of duplicate rows until I found the right tables to do the join properly.   Note it's a demo system, so there's not a lot of great data.

I would agree with James - to double check the joins and validity dates and/or various flags, like deletion flags.

Hope the attached example helps a little.  And yes if you can share yours, one of us can take a look.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Original Message:
Sent: 09-17-2019 13:32
From: Derek Sayres
Subject: query not showing exact results

Hello, I'm wondering if anyone has run into situations where a query does not display current accurate results?

The routing in this case is set to Continuous flow prod, however the query shows optional overlapping.

I'm using today's date for both display in SAP and the query, I tried running the query with a material number as an input or the routing group number, both delivered the same result. I do know that the step had been set to optional overlapping at one point, but has been updated for months.

Thanks for any input.

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------