Online Tutorials & Training Materials |
Register Login

MAX & MIN Calculation at Run Time in a BEx Query?

amit butola || 31 Jan 2014 1:49 pm || 1

Hi experts,

I have scenario I need input of date range from the selection screen and according to it need to show MAX & MIN of quantity(Key Figure) field based on certain characteristic. Can anyone suggest any option?

Thanks in Advance.

You can view more tutorials about SAP BW


  • 04 Feb 2014 5:22 am Best Answer

    You can select 0FISCPER or any other date variable in the BEx variable screen and configure a selection range for the date. As an alternative you can write a customer exit include for selection of a date range. There are MIN and MAX functions in the variable screen on the key figure also. Or you can create a calculated key figure(s) and set it to the MAX and or the MIN.