Workbook Queries

[sameer_mehta]

Hi,

I have a requirement to create workbook which will contain 2 queries. Both the queries have same selection criteria i.e. records are filtered based on Customer ID. For this I have designed a custom pop up through which user can enter customer id. Now the requirement is pop up must be displayed once for both the queries and the records get filtered in both the queries.

I have desgined one query and it is working fine but dont know how to satisfy the filter criteria with one pop up for both the queries.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

We canu2019t merge two queries variable pop up screen as one. Each query is having its own variable pop up screen. As you have added two queries in one workbook, then if you refresh it will display one by one variable pop up screen.

You said you have created custom pop up does it means have you written any macros??

Hope it helps you.

Thanks

Riyez

[sameer_mehta · Accepted solution]

Thanks for your reply.

Both the queries have common pop up. So it is useless to display same pop up again. The requirement is the value entered by the user should go to both the queries.

[sameer_mehta · Accepted solution]

Also I am using SAP functionality for the pop up. I have written the code for pop up in user exit under i_step = 1.

[Private_Member_49123]

Hi Megamin,

To get only 1 popup for both the queries

open ur workbook,

go to tab BEx Analyser drill it down then Design Toolbar -

---

>work book settings---->go to 'variables' tab--->check 'Display duplicate variables only once'.U'll get variables screen popup only 1 for both the queries.

Hope it helps out.

Shreya.

[former_member202684]

Hello,
if you are using the same variable in both queries, then you will get only one pop up for its value. 
There is a workbook setting "Display Duplicate Variables Only Once" that you should set.
SAP help for this setting:
If a workbook contains multiple queries that use the same variable, you are prompted to enter the variable values again for each query. To avoid this, set the Display Duplicate Variables Only Once flag
Regards,
Kirill

What Kirill said is absolutely what you need to do.

Because by default if you use the same variable, then you will NOT get two pop up screens. You only get the variable screen once. So you can use the same customer exit variable which you created in both the queries and you will get only one pop up for it.

Regards,

Joe

[Former Member]

Hello,

if you are using the same variable in both queries, then you will get only one pop up for its value.

There is a workbook setting "Display Duplicate Variables Only Once" that you should set.

SAP help for this setting:

If a workbook contains multiple queries that use the same variable, you are prompted to enter the variable values again for each query. To avoid this, set the Display Duplicate Variables Only Once flag

Regards,

Kirill