Skip to Content
0
Nov 18, 2021 at 11:11 AM

Database calculation on SMW3_BDOC Table

303 Views

I am performing select operation on SMW3_BDOC table to fetch the BDOC's and I see huge number of records in it. However to restrict the number of entries I need to select only records for which the UPD_TIME and SND_TIME difference is greater than 60 minutes.

I wanted to write the condition on the select statement itself instead of fetching all the records and later deleting the entries which does not match the criteria to avoid the performance issues.

How can I achieve this?