cancel
Showing results for 
Search instead for 
Did you mean: 

Selection dialog offers incorrect (number of) choices

Former Member
0 Kudos

Howdy?

We've created a BEx report which is working fine except for the selection choices for a filter.

Here's what happens: A filter variable Currency (optional) (0CURRENCY) offers only # - Not assigned, and USD - US Dollar as selection choices. Thing is, if I enter, say, EUR in that dialog as currency and click on OK, the filter is correctly loaded with Euro and all figures in the report are correctly displayed in Euros.

What I can't seem to figure out is why the selection menu on Currency doesn't offer more than those two choices - I've set "Maximum Records" to 1000.

I've also verified that 0CURRENCY has the correct master data, which, of course, is confirmed by the correct results on the report side.

Any ideas anyone? Please don't hesitate to ask if anything is unclear. I'll be happy to provide a screenshot.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

In the Query Designer, click on 0CURRENCY and check what option you have selected in the Properties / Advanced tab / Filter Value Selection During Query Execution section...

Try checking "Values in Master Data Table"... Since you say the Master Data has been properly loaded, it should show...

Former Member
0 Kudos

Advanced -> Access Type for Result Values - Posted Values

Advanced -> Filter Value Selection During Query Execution - Values in Master Data Table

I must note that we're not using 0CURRENCY directly but through a variable and conversion type. I just checked ob08 and it looks maintained. I also checked the data in 0CURRENCY directly and it's filled. There must be something I'm missing. I'm puzzled.

Former Member
0 Kudos

Does anybody have an idea?