cancel
Showing results for 
Search instead for 
Did you mean: 

Need to create at BEX Query to get last 30 days data.

Former Member
0 Kudos

Hi,

I need to create a bex query based on input date need to calculate last 30 days outstanding and 31-60 days outstanding 61-90 days outstanding 91-180 days outstanding and greater than 180 days outstanding. Please find the format of the report.Kindly help me.

                                                                                                                      Thanks & Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member199945
Active Contributor
0 Kudos

Before posting if you search in SCN you can find lots of docs with sam escenarios.

1.

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

2.

Former Member
0 Kudos

Hi Seshu,

  I want to calculate based on posting date and user input date. Not based on current date.


Regards,

Alagappan

former_member199945
Active Contributor
0 Kudos

Based on those documents you can easily create.

1. First create variable (Mandatory) user input

2. Posting date is avaialble as char you will get

3. need to calcualte difference b/w those 2 dates  you can refer below  By using replacement path we can convert both dates into get difference.

http://www.sd-solutions.com/SAP-HCM-BW-Replacement-Path-Variables.html

4. now need to create  Bucketing logic  formula  as per requirement above documents will give idea.