Restrict Values shown in Dropdown Lists - Web Layout

[Former Member]

Hello,

We currently have a requirement in our BPS application, where the users want the list in a dropdown to be restricted to only those values for which no planning has been carried out.

Example. We have master data for Project IDs. While inserting a new line in the layout, the users want the dropdown list to be restricted to only those Project IDs for which no planning has been entered in the BPS application.

The entire planning tool is web based.

Is it possible to restrict the list?

Thanks

Sunil

[Former Member]

Hi Sunil,

This is achievable. I had done so for my web layout. But yes, Anand is right on the performance part.

Cheers,

Gim

[Former Member]

Hello Gim,

That is a positive news.

Could you share the exact steps and some sample code if possible? It will be a great help.

In the mean time we are also working on a different approach. I will update this post once we try it out.

Sunil

[Former Member]

Hi Sunil,

What I did was

1. create a variable in BPS0 and attach it to a planning level

2. create a user exit for this variable

3. have the selector in BPS_WB attached with to the relevant level.

[Former Member]

Hi Sunil,

As far as I know there's no standard option for doing this.

Someting that might be worth trying is create an exit type variable for project and populate it with the project for which no planning has been performed. The way you can check this is read the cube for compare it with master data. The issue will be with performance.....

thanks