Calculating with formula variables of type user exit

[Former Member]

I created the following query:

Rows: Characteristic = Employee

Column: KYF = Status

Filter: Year, Month

The KYF ist a formula containing a formula variable. This variable of type user exit should return a value recording to the value of employee and has to be read in a customizing (data-) table by the user exit.

Is it possible to read the values of employee row by row from the internal table which contains the amount of data before processing to output screen and fill the 'Status'-KYF or should I create a virtual keyfigure for this case.

Thanks for all your feedback,

Angelika

[Former Member]

Seems, the best solution will be to keep the values for 'Status' in my data modell.

Thank you.

[Former Member]

Hi,

It seems like Status is master data of Employee.

As per your process, if you do either formula variable or virtual keyfigure you will face query performance problem. More over you cant simply access record by record characteristic value in formula variable. It will be another complex process like you have to call the characteristic value via replacement path.

You have the following choices:

• You mentioned master data is availabe in custom table. Try to pull the custom table master data into employee info object. Maintain status as one of the attribute of the master data. Then you can display Status value simply in the report. This will be global access like you use this Status value n number of info providers which is having Employee as one of the info object in the info provider.

• If the previous way is not possible, include the Status in the info provider level and write a simple update routine to populate the values. This will be info provider level.

I am not sure whether you are in development environment or productive. If developement, then you can choose simply any one of the above ways.

Regards,

Vivek