Financial Year

[Former Member]

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

[Former Member]

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

[Former Member]

hi,

u can use this FM - 'FI_PERIOD_DETERMINE'

and manipulate the select query.

regards

Reshma

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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,