topic Re: Simple date question in Application Development and Automation Discussions

Simple date question

Former Member — Mon, 10 Sep 2007 20:20:00 GMT

Hi Experts,

I do not know ABAP which explains my straight forward question.

I am coding in BI.

Based on an invoice date, I need to work-out the fiscal year.

If the month of the invoice date is >= 4, then the fiscal year, is the current year.

If the month of the invoice date is jan-march, then the fiscal year, it the current year-1.

Thank you.

Re: Simple date question

Former Member — Mon, 10 Sep 2007 20:43:25 GMT


data: gs_month(2) type c.

gs_month = gs_invoice_date+4(2).

if gs_month GE 4.
gs_fiscal_year = sy-datum+0(4).
elseif gs_month between '01' and '03'.
gs_fiscal_year = sy-datum+0(4) - 1. 
endif.

Greetings,

Blag.

Re: Simple date question

Former Member — Mon, 10 Sep 2007 20:51:00 GMT

Thanks. How should I declare gs_fiscal_year?

Re: Simple date question

Former Member — Mon, 10 Sep 2007 20:52:56 GMT

CAll FM DATE_TO_PERIOD_CONVERT. That's the easiest way.

Rob

Re: Simple date question

Former Member — Mon, 10 Sep 2007 20:56:07 GMT

Like this...


data: gs_fiscal_year type sy-datum.

Greetings,

Blag.

Re: Simple date question

Former Member — Mon, 10 Sep 2007 21:03:05 GMT

Blag - wouldn't you rather have a four character fiscal year?

If you do subsequent work on the field as you have declared it (say add a year), you will get unexpected results.

Rob

Message was edited by:

Rob Burbank