BPS Variable - All Values

[Former Member]

Hi All,

I am using Web Interfaces and there is a requirement to filter data on a set of variables.

If there is a value selected in the variable the data should be filtered else all of it should be displayed.

That is working fine. The problem is once the user selects a value in the variable, the system stores that values in the buffer and the user cannot go back to the option of displaying all the data.

I tried to find if there is any standard delete value functionality available as in planning folders but unfortunately nothing seems to be available. It is really hard to believe that SAP has not made anything available.

If anybody is aware of any standard functionality to display all the values without turning 'All Values' in customizing 'OFF', cause if that's done the system only displays values against which there are records, please let me know. I have not checked the option for required entry in BPS0

Thanks

Vanya

[Former Member · Accepted solution]

Hi,

There is a table which stores the value of a variable as set against a user ID; i think it is UPC_VAR_CHAR_ACT. If you delete the relevant record(s) from this table using an exit, this should solve your issue.

Hope this helps.

[Former Member]

Vanya,

Works if you do not require different values for each user that the user defined values provides. If this feature in the web interface is necessary and you require different values per user you could also implement it as a user exit variable that reads a custom table or ODS with user in the key. Otherwise you will need an exit to clear the variable as Mayank suggested.

Blake

[Former Member]

Vanya,

How is your variable set up in BPS0 and what is the "Appearance" set to on the variable in the web interface? I have productive examples of just what you described.

It is for a user exit characteristic variable that returns all values in the master data table for sales org with the "Restriction of Values Required by User" not selected. In BPS_WB the variable is setup with an "Appearance" of dropdown. When a user runs the interface the first item in the list is one called "(All)" followed by all of the items coming from the master data table. The user can then either select a single value or (All) to change what is displayed in the layout and processed against for planning functions without the need for an exit to remove what they had previously selected from the UPC_VAR_CHAR_ACT table.

Blake

[Former Member]

Blake,

It is a user defined variable with optional entry.

It does give the all option in the dropdown but only the first time, once the user selects a value and then tries and go back to displaying all the values, the option is no longer available.

The web interface has dropdown selection.

Cheers

Vanya

[Former Member]

Hi,

Thanks for the answer.

Blake - I have not put that flag.

Mayank - That was my last resort, I was wondering if a basic thing like this can be done without an exit?

[Former Member]

Vanya,

I assume on the variable you created in BPS0 you flagged the Restriction of Values Required by User flag? If you remove that restriction then the user should see the option of anything in the list of variable values and also one more that allows them to set it to all values. That should allow the user to set it to a single value or all depending upon their specific need at a point in time.

Blake