Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 24 at 10:25 AM

    Hi use FM to get last date of quarter:

    HR_99S_GET_DATES_QUARTER -

    and so you can deterimine last_date(6) = lastmonth

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26 at 09:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded