Execute planning functions on selected rows

[Former Member]

Hello all

I have a planning process. The user works on WAD with input ready layout. He has a button that execute planning function. I want him to be able to choose row (or several rows), and execute the function on these rows only.

I i have the document "How Tou2026run planning functions on changed records in SAP NetWeaver BW integrated planning". Can it help me? If not, what is the best way?

Best

Yuval

[Former Member]

Before you can execute the function, you need to transfer the selected row(s) to the filter (which is used be function). For this, use the command "SET_SELECTION_STATE_BY_BINDING".

Hope it helps,

Christian

[Former Member]

Hi Yuval,

The only simpleset i can think of is the following solution:

1. Add to your aggregation level a new characteristic that can hold the concatenation of all the characteristics in the line

2 . add a FOX to the opening of the WAD template that each time the wad is opened the function is filling the new characteristic

With all combinations of characteristics in the line ,this way you can get a unique identifier for each line

3. once 2 is done and the wad in prompt up ,you can do data binding from the new characteristic to a variable in the filter that expects to get those values

4. Once the function ended you can choose either to leave the new characteristic or to repost the records to #

Be aware that this solution is possible only if :

1. the new characteristic will not hold a value longer then 60 chars and should not be created with master data (without master data is not always possible with wad ,check it!)

2. i am not sure but i think you can choose to hide this characteristic in the query disigner and still the data binding will work.

3. you will have to supress zero lines because when the FOX from 2. will be triggered at the opening of wad leaving 2 records, 1 with # concatanation and zero in all KF and 1 with assigned concatanation and the original values of the KF's.

Regards,

Eitan.