How to get previous fiscal period(Fiscal Period-1)

[Former Member]

Hi ,

According to my business scenario for reporting-(BI-7) , I want to move FISCPER by 1 . The formula for this is ,

Formula: (Restricited key figure)Sales Order $ (Prior)=Char = Fiscal Period - 1

KF = Sales Order $

I also need a variable for fiscal period for user entry -Single value and mandatory.

I specifically have the task of not including FISCVAR newhere into my query design.

Please suggest how to go about implementing the above scenario ?

Thanks

[Former Member · Accepted solution]

Use a SAP Exit variable & offset it by -1 ....or check if any exists fr ur scenario.

I am sure there exists one for FISCPER - smthing like Customer Exit ..

U need not have FISCVAR u can jst hardcode it by K4 or whatever in the filter.

[Former Member]

hi

you should create RKFs. The variable can be a exit type which givs the current period. Use offset -1

http://help.sap.com/saphelp_nw04s/helpdata/en/f1/0a563fe09411d2acb90000e829fbfe/content.htm

http://help.sap.com/bp_epv260/EP_EN/documentation/EP/N05_BB_ConfigGuide_EN_US.doc

regards

abiram