Question Re: Conversion to 0fiscper in Technology Q&A

Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 01:53:21 GMT

Hi experts,

I need to know the code about 0fiscper conversion. I have the infoobject 0CALMONTH, and I wnat to convert to 0FISCPER in the update rules. Could somebody write me the ABAP code?

Re: Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 02:23:13 GMT

Hello Mauricio,

Use Function Module FISCPER_FROM_CALMONTH_CALC. Give the value of 0CALMONTH and fical variant as input and you will get Fiscal year / period as output.

Hope it helps.

Regards,

praveen

Re: Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 02:26:23 GMT

Hi Mauricio,

You can use function module DATE_TO_PERIOD_CONVERT which converts a calendar date to fiscal year and posting period according to a fiscal year variant.

I hope this helps!

John

P.S. Actually Praveen's solution is better, yet it is similar as FISCPER_FROM_CALMONTH_CALC calls DATE_TO_PERIOD_CONVERT.

Message was edited by: John Danoff

Re: Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 02:31:24 GMT

I'm new in BW. Could somebody explain me step by step, please?

Thanks

Re: Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 02:40:44 GMT

In your update rules, choose update method routine and then click on the create icon. after that, you will need to copy and paste the code below and save:

$$ begin of routine - insert your code only below this line -

fill the internal table "MONITOR", to make monitor entries

data: l_fiscper type rsfiscper.

call function 'FISCPER_FROM_CALMONTH_CALC'

exporting

iv_calmonth = comm_structure-calmonth

iv_periv = 'K4'

importing

ev_fiscper = l_fiscper.

result value of the routine

result = l_fiscper.

if abort is not equal zero, the update process will be canceled

abort = 0.

$$ end of routine - insert your code only before this line -

Note that you may have to modify the code with respect to the fiscal year variant used. K4 is used here just for illustration.

Re: Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 02:44:52 GMT

Thanks John, I assigned points

Re: Conversion to 0fiscper

Former Member — Tue, 18 Apr 2006 03:00:22 GMT

Hi,

And also take a look on the links for more information.

With rgds,

Anil Kumar sharma .P