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