Bex Query designer

[Former Member]

Hello,

How to reduce the calendar date when user inputs a date, the date should be reduced to 30,60,90,120 days and so on.

regards,

Sridhar

[Former Member]

Hello Friens,

When customer gives a date for eg(20110213) from this the data should populated for kigfigure eg (ageing stock) with date (20110112) exactly 30 days from user input .And the same for 60,90.120...the keyfigure should be populated for colums 20101213,20101112....

Could some one help me how to write the abap code in the customer exit variable for this problem

Regards,

Sridhar

[skrathore303]

Hi,

Refer this article on Ageing reports.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30f15839-0cf1-2b10-c6a7-ebe68cc87...

Regards

Shubh

[Former Member]

On 0Calday, create a Customer exit variable, by selecting the Inpur range, and convert it to days by ABAP usage.

Thanks

[Former Member]

Hi,

You can achieve this by formula with Replacement path.

Regards,

Sai.

[former_member211907]

Are you looking to reduce a user's input into Business Days ? Days since the beginning of the year ? And are you planning on using these in a formula or a restriction / filter ?

In any case, look to the "Date" functions in the formulae. Alternatively you may need to create an exit variable to return "Days from beginning of the year"

[Former Member]

hi all

you can write some customer exit at selection variable level.with ur desired conditions.

Regards

satishsmse