Can you filter data with layout filters before it calls the database at transaction execution?

[former_member1082066]

I've used a custom transaction that essentially is just a page of fields to query a data table.

When you execute it, it takes you to a nice spreadsheet layout, with a suite of options. I can apply filters/sorting and save them to the layout, and then specify that layout at the initial query screen the next time i execute it.

However, when i execute the query at the beggining with said new layout, it still requests a full record set of the initial query, processing it all, and then filtering. it seems incredibly inefficient and i want to suggest they look into seeing if the filters can be integrated with the first query to reduce the data call.

As the title states, can the filters saved in a layout be integrated into the initial query upon excecution to save calling excess data?

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

-Alex