cancel
Showing results for 
Search instead for 
Did you mean: 

How to count no. of days from selection criteria in BEx

Former Member
0 Kudos

hi,

I need to do some calculations in query and one of requirements is to count number of days for which query was executed (day period is in query selection criteria)

I would like to use it for calculated KF definition.

Does somebody knows how to get this number?

Regards,

Andrzej

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Andrzej,

you need to use I_STEP = 2 and fill via user exit a formula variable...

What do you have exactly in the selection pop-up ?

Bye,

Fabio

Former Member
0 Kudos

hi,

what do you mean by I_STEP = 2 (I do not know much on user exits) ?

In selection I have variable for 0calday:

variable type: char value

processing by: user entry / default value

variable repres: interval

var entry is: optional

Regards,

Andrzej

Former Member
0 Kudos

Hi Andrzej,

The answer is correct - you have to do it in user-exit. You have to learn it becouse its a very powerfull solution and is very ofen used in reporting.

See help ... http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a56f5e09411d2acb90000e829fbfe/content.htm

In the interface of this exit you will find all query selections + sy-datum = what you need.

Pozdrowka

Wojtek

Answers (0)