Skip to Content
Technical Articles
Author's profile photo Abhishek Agrawal

Error: No value could be determined for variable /ERP/P_0CURRENCY03.

Another short blog: How to fix currency error:

“No value could be determined for variable /ERP/P_0CURRENCY03”

Issue background: 

I was trying to access FIORI app “Cost Center Plan/Actual” and after entering mandatory parameters when I hit on ‘Ok’ button I got this error:

Technical Details:

This FIORI App is based on BEx query /ERP/SFIN_M01_Q2001 which uses variable /ERP/P_0CURRENCY03 to determine default user currency. This variable is populated by a standard FM /ERP/RSVAREXIT_P_0CURRENCY03 and this FM tries to determine default currency based on Controlling Area maintained in your user profile.

Solution

Maintain “Controlling Area” in your user profile. Now there could be two places where you may need to maintain this parameter depending on which platform you are using to access the Cost Center app/query:

1- FIORI Launch Pad:

If you are running app from FIORI launch pad then you can maintain default parameters under user settings. You may need to log-out and login again after saving the default value for CA.

2- Using RSRT/Analysis for Office:

If you are running this query using Tcode RSRT in S4 or through AO then you may need to maintain this parameter in SAP GUI:

TCode: SU3

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo naveen jain
      naveen jain

      Hi Abhishek,

      I already maintained the controling area (CAC) in fiori laucnhpad settings, but still getting same error while executiing Profit center plan actual app.

      https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F0926A')/S14OP

       

      Please suggest what we are missing.

      Author's profile photo Abhishek Agrawal
      Abhishek Agrawal
      Blog Post Author

      Hi Naveen,

      I tried application Profit Center-Plan/Actual in my system and when I am removing Controlling Area from Default Parameters and trying to run app I am getting Currency error however when I am running app with Default Controlling Area maintained then I am able to run the app.

      Check these two things in your system:

      1- Check if the currency is maintained for your Controlling Area configuration using TCode OX06.

      2- Maintain Controlling Area defaults in GUI and run Profit Center Actual/Plan query (/ERP/RSVAREXIT_P_0CURRENCY03) in Tcode RSRT and  put a breakpoint in FM /ERP/RSVAREXIT_P_0CURRENCY03 and check if this FM is determining currency or not.

       

      Abhishek

       

      Author's profile photo naveen jain
      naveen jain

      Hi Abhishek,

       

      Thanks for the quick response, please find response below.

      1. Yes, i checked currency EUR is maintained in the OX06 tcode for controlling area.
      2. I executed BexQueryERP/SFIN_M01_Q2701 by using RSRTtcode, it's working fine there and returning data, and also put the breakpoint and i saw it's returning EUR currency.
      3. Everything is ok from RSRT getting proper output, but at UI side i am getting currecny issue.

       

      Thanks

      Naveen Jain

       

      Author's profile photo Abhishek Agrawal
      Abhishek Agrawal
      Blog Post Author

      Hi Naveen,

      Sorry for the delay in response. Can you put external break-point in the currency FM and then run your FIORI app? I had put an external breakpoint in the FM and executed FIORI app and it was triggering Currency FM, this will give you an idea why FM is not able to determine currency from UI.

      Abhishek

       

      Author's profile photo Yuveer Popat
      Yuveer Popat

      Hi Abhishek,

      I get the following error in Fiori when trying to run the C_CostCenterPlanActQ2001 CDS view :

      No value could be determined for variable !CDS_F_2CIFICHOFACC.

      Any idea what could be going wrong here?

      Regards,

      Yuveer

      Author's profile photo Abhishek Agrawal
      Abhishek Agrawal
      Blog Post Author

      Hi Yuveer,

      From the name of the variable, it looks like Chart of Account value is not getting determined.

      Did you try to run this view in HANA Studio? I was looking at this view in HANA Studio and in this view it is trying to derive "Chart of Account" using the value entered in Controlling Area field:

      Can you check this: 

      Open SQL view IFICONTAREA (this is SQL view of CDS view "I_ControllingArea") in SE16n and pass Controlling Area value as you are passing in FIORI and check if it shows Chart of Account value. If it is not showing COA then this could be one of the reason.

       

      Author's profile photo Thorsten Klingbeil
      Thorsten Klingbeil

      Hi Yuveer, Hi Abhishek,

      just in case you could not solve the problem so far – I got the same error message ?

      In order to fix it, you need to add Parameter CAC with the value of your default Controlling Area to your User Parameters with transaction SU3 or SU01 (table USR05).

      Regards

      Thorsten

      Author's profile photo HANA TEAM
      HANA TEAM

      Hi Team,

      For the P&L Fiori app, the above Issue got resolved after maintaining CO area, but getting another error.

      -System error in program CL_RSR_OLAP_VAR and form BLOCK_CHECK-02

      Author's profile photo Abhishek Agrawal
      Abhishek Agrawal
      Blog Post Author

      This does not look like a Config error, it looks like an ABAP program error and I see there are quite a few Notes on this class, can you please check SAP Notes?

      https://launchpad.support.sap.com/#/solutions/notesv2/?q=CL_RSR_OLAP_VAR