Hi Randy
Hope you're well.
There isn't an end date in the tables. You might check for views, infosets or logical databases that may have it. You could also use a BAPI, which works pretty well, especially if you have revisions/change numbers: BAPI_CSAP_MAT_BOM_READ
Am attaching a query that seems to work without end date. I can't tell if you've already tried something similar, because I can't see all of the tables you're using, so I hope it helps.
Best Regards,
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 04-15-2020 10:47
From: Randy Springer
Subject: CS02 - BOM Download.Qsq
Uploaded CS02 - BOM Download query and have made some changes because I needed more fields then just the basic. I want to only find active BOM components with a "Valid To" of today or later.
Do you know how I can bring in RC29P-DATUB and make it > (todays date) so I only see valid data?
------------------------------
Randy Springer | Sr MDM Analyst
Timken | 2342622624
------------------------------