Question Re: Function Module for calquater in Technology Q&A

Function Module for calquater

former_member184624 — Thu, 29 Jul 2021 09:43:39 GMT

Dear BW Experts,

In one of the BW report, User is entering CALQUATER as a input (20182). In the output, I want to show the data from 20182, 20183, 20184 and 20191. Can you please share, any standard function module which can get next quarters (20183, 20184 and 20191) as output. so that i can show in the report.

Thanks.

Re: Function Module for calquater

rathy_moorthy2 — Fri, 30 Jul 2021 08:17:53 GMT

Not aware of a standard one for it.

But since quarter is only 4, you can easily create a custom one with following logic.

return

{

if (right substring (1)of user input not eq 4) then A = (user input + 1) else A=year+1 and 1

if (right substring (1)of A not eq 4) then B= (A + 1) else B =year+1 and 1

if (right substring (1)of B not eq 4) then C= (A + 1) else C =year+1 and 1

if (right substring (1)of C not eq 4) then D= (A + 1) else D =year+1 and 1

}

Hope it helps

Regards,

Rathy

Re: Function Module for calquater

former_member184624 — Tue, 03 Aug 2021 03:44:00 GMT

Thank you. I have acheieved using offset on calquater info object.