Skip to Content
Technical Articles

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

6 Comments
You must be Logged on to comment or reply to a post.
    • 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

       

  • 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

     

    • 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

       

  • 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

    • 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.