2007 Aug 30 9:12 AM
Hi guys ,
FISCPER - Fiscal Year /Period is available in the Datasource (Example, 0FI_GL_6) but not available in BSEG,BSEG_ADD ,ZTABLES, FAGLFLEXA Tables..
How to get into BI..
I have found the field POPER (POSTING PERIOD ) AND GJAHR (FISCAL YEAR) IN faglflexa is the same field as fiscper in the datasource
am i correct , need somebuddys advice if not what are the fields and where from we can get that .
Valuble points are surly rewarded .
Thanks ,
Vinay .
2007 Aug 30 9:40 AM
Hi vinay ,
u can get the fiscal year and fiscal period from BAPI 'BAPI_COMPANYCODE_GET_PERIOD,by passing company code
and sy-datum.
Use the bapi in the following manner,it should work because iam using that bapi and it works fine for me.
CALL FUNCTION 'BAPI_COMPANYCODE_GET_PERIOD'
EXPORTING
COMPANYCODEID = VBAK-BUKRS_VF
POSTING_DATE = SY-DATUM
IMPORTING
FISCAL_YEAR = L_FISCAL_YEAR
FISCAL_PERIOD = L_FISCAL_PERIOD.
reward if useful,
Balaji