topic Financial Year in Application Development and Automation Discussions

Financial Year

Former Member — Fri, 27 Apr 2007 09:56:18 GMT

Hi Friends,

How to select the data of the current financial year.

(Now I am getting all the data for a given document number, pertaining to previous financial year and current financial year.)

Kindly guide me.

TIA.

Regards,

Mark K

Re: Financial Year

Former Member — Fri, 27 Apr 2007 09:59:09 GMT

hi,

u can use this FM - 'FI_PERIOD_DETERMINE'

and manipulate the select query.

regards

Reshma

Re: Financial Year

Former Member — Fri, 27 Apr 2007 10:02:22 GMT

Hi,

What are the values to be entered in this FM.

CALL FUNCTION 'FI_PERIOD_DETERMINE'

EXPORTING

I_BUDAT =

I_BUKRS = ' '
I_RLDNR = ' '
I_PERIV = ' '
I_GJAHR = 0000
I_MONAT = 00
X_XMO16 = ' '
IMPORTING
E_GJAHR =
E_MONAT =
E_POPER =
EXCEPTIONS
FISCAL_YEAR = 1
PERIOD = 2
PERIOD_VERSION = 3
POSTING_PERIOD = 4
SPECIAL_PERIOD = 5
VERSION = 6
POSTING_DATE = 7
OTHERS = 8

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Kindly explain.

Regards,

Mark K

Re: Financial Year

Former Member — Fri, 27 Apr 2007 10:02:39 GMT

In most of the Finance tables like BSEG,BSID,BSAD,BSIS,BSAS,BSAk,BSIK

the field GJAHR Fiscal year is a key field,

So you have to enter the related correct year for which you wants fetch data

with the help of this field as well as with Posting Date field you can fetch the realted data for that year

or use gjshr = sy-datum+0(4) in the where condition of data fetch select.

reward if useful

regards

Anji

Re: Financial Year

Former Member — Fri, 27 Apr 2007 10:09:26 GMT

Hi,

The table I am using to select is a customised table. There is only the posting date field is available. From this posting date, I want to select the data of the current financial year. Kindly explain with complete coding.

Pls guide me.

Regards,