Go to Query studio, from the toolbar and click on "New Query" which will open a new Query builder.
Use existing connection Profile with drill down button, here utilizing "SAP ECC".
For SAP datasource to create a visual query and using table VBAK in this scenario
Click on the "Search tables" design element on right side palette and provide VABK and click enter.
It generates a VBAK table in the visual query space.
Select the fields and click on the filter to provide the "User defined Variables".
Now drag and drop "Available Fields", "Available Operators" and "$$"(variable) to the space below the filter expression window.
In this scenario, we are creating a User-defined variable from the output of the Oracle currency table and passing the "currency values" dynamically to query the SAP ECC TABLE VBAK.
When you drag and drop the "$$" variable to the below space, it will open up a new window.
Click the "User defined Variable" and click "new variable"
Below new session in the separate window will open with "variable Builder"
Provide details like Variable name, description, and input options as "Output from query".
Click on Test Variable to validate the output.
Close it and click save variable.
Go back to Query Builder window and you can see the new User-defined variable that you created in variable builder would appear here, enable the check box beside the new "User defined variable"
Click "Test Result" and OK.
Now will see the selected user-defined variable in the filter expression.
Now, the visual query is ready to execute. Click on Execute.
It will generate the output in the results window, could see only the "Currency Values": 'KRW' and 'INR'.