Database calculation on SMW3_BDOC Table

[former_member776985]

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?

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.