Skip to Content
0

How to get last month of the quarter value in BW Bex

Jan 22 at 01:42 PM

68

avatar image
Former Member

Hi All,

I am working on HR module and I need help on quarterly calculation report, please find below scenario.

1. User will run the report and give the input YYYYQ

2. Then report should give last 4 quarters values

3 But, Each quarter should show last month value of the Quarter as a result.

If user run the report for 20181 (1st Quarter of 2018), then result should show, 01.2018(Current Quarter), 12.2017, 09.2017, 06.2017 and 03.2017 data.

I am unable to get the Last month of the quarter value, could you please someone throw the light on this scenario.

Thanks in Advance,

Ajay Kumar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Jan 24 at 10:25 AM
0

Hi use FM to get last date of quarter:

HR_99S_GET_DATES_QUARTER -

and so you can deterimine last_date(6) = lastmonth

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Jan 26 at 09:34 AM
0

Hi,

You can do a CMOD based on the entered value. If you need help with CMOD, I can help you. Just provide sample code in your CMOD so I can modify it based on the variables your CMOD is using.

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded