Q: 12
If you want to create a single filter that utilizes criteria from multiple tables in the same query, which
filter do you need to use in Query Designer?
Options
Discussion
Option C
C
I get why D looks right, since "Advanced" sounds powerful, but I think C is needed when filters need to hit more than one table in the query. Table-level filters like B or D only impact that specific table. Not totally sure if SAP changed this lately though. Agree?
C , D is tempting but that's just for a single table filter.
I get why folks might look at D, but in Query Designer it's C all day. You need Query Advanced filter if you want to mix criteria from more than one table. Not 100 percent, but that's how I've seen it asked.
Why not D? Table Advanced filter does sound powerful, but I think it only covers one table at a time, right?
C for sure, had something like this in a mock. Query Advanced filter lets you use fields from different tables when setting criteria, which is exactly what the question wants. The table filters (B or D) only look at one table at a time. Pretty confident here but jump in if you think otherwise.
C imo, unless you only need to filter a single table, because then D might actually be right.
Maybe C, but if the tables aren't joined or you want to filter a single table only, D flips it.
C . In SAP Query Designer, only the Query Advanced filter lets you combine logic across multiple tables, not just one. Pretty sure Table Advanced is limited to single-table fields. Could be wrong if there's been a UI update, but that's how it worked on similar practice sets.
Be respectful. No spam.
