How to get excact Budget planning value without exchange differences

[patrick_g1]

Dear community,

our system has EUR as global standard currency but has a entity within CH and their currency CHF.

Problem now within SAP PS is how to get the exact budget for a project using CHF instead of EUR and its actual valuation compared to EUR?

We use TCode: S_ALR_87013558

We can change the display of the currency with this function:

Disadvantage here is that the calculation of the value will be done based on the actual maintained currency valuation from EUR to CHF.

Is there a way to show the budget in CHF without any calculation from EUR to CHF?

thanks in advance. Best regards

Patrick

[Ken_Melching]

The company code assigned to the WBS element will define the Object Currency.  Then when you enter the budget make sure you are entering the values in object currency.  The object currency will automatically be converted to CO Area Currency and saved, but the entered values in the object currency are the "base" values.

[patrick_g1]

Hi,

Thanks for your reply. I still have a question.

F1 help on field Database Currency shows me this information:

Foreign currency key

Currency in which the values were entered in the line item or transferred from another application. The system translated the values from this currency to the currency of the operating concern.

When I now check the operating concern this is assigned to a controlling area with currency EUR.

This means, if I am not completely wrong,  that always the values will not show the exact CHF value but the calculated value based on the exchange rates between CHF and EUR.

Am I right here? Please feel free to correct me if I am wrong.

Many thanks in advance

Best regards

Patrick

[Ken_Melching]

In the Budget Profile you define what currency is the entry currency and then all other currencies are calculated from that value. In the Budget Profile you can set the entry currency as CO Area, Object, or Transaction.

[mathurifico]

In SAP, when a global currency like EUR is used as the standard currency, and a local entity uses a different currency like CHF, the challenge is often tied to ensuring accurate reporting and budgeting without unnecessary currency conversions.

For your specific issue, where you want to display the project budget directly in CHF without conversions from EUR, here are some options to explore:

1. Use Parallel Currencies

Configuration: Check if the system is set up with parallel currencies (local, group, and hard currency). This can be configured in the controlling area settings.

Benefit: If CHF is set as the local currency for the Swiss entity, SAP will automatically post and store values in both EUR (global currency) and CHF (local currency) at the time of transaction. You can then directly report the budget in CHF without conversion.

Steps to Check:

A) Go to SPRO and navigate to Controlling → General Controlling → Organization → Maintain Controlling Area.

B) Verify the Currency Type settings for parallel currencies.

2. Set the Budget Directly in CHF

Method: When entering the budget for the project, input it in CHF instead of EUR. SAP allows you to define the budget in the local currency if the project is assigned to a company code that uses CHF as its currency.

Steps:

A) Use CJ30 (Change Project Budget) or CJ32 (Change Budget for WBS Elements).

B) Ensure that the budget is entered in CHF directly under the company code linked to CHF.

3. Custom Report/Enhancement

Custom Report: Develop a custom report that fetches and displays the project budget in CHF directly without converting it from EUR. This report can use the original currency values stored in the system.

Steps:

A) Work with your ABAP development team to create a custom report.

B) Use tables like COSP and COSP_B to fetch budget information in the required currency.

4. Alternative Reporting Options

Use Report Painter/Writer (GRR1):

A) Create a custom report using Report Painter/Writer that specifically pulls the budget values in CHF.

B) Ensure the layout excludes currency translation logic.

SAP Query (SQ01):

A) Use SAP Query to create a specific report that directly displays the values in CHF for the desired project.

5. User-Defined Currency Setting

T-Code S_ALR_87013558: This report allows you to switch currencies dynamically.

Custom Logic: If the currency conversion from EUR to CHF is not desired, you may need to adjust the settings or implement a user exit (e.g., COOM0001) to bypass the conversion and directly show the budget in CHF.

Considerations:

Ensure exchange rate types and valuation areas are properly maintained if you need accurate EUR-to-CHF translations.

Always test the changes in a sandbox or quality system to ensure the accuracy of your budget reports.

[RaymondGiuseppi]

Basically each line item for budgeting is stored in the currency in which it was entered and in controlling area and object currencies. The exchange rates are calculated from the exchange rate type and the value date, this information comes from the  budget profile.

Did you customize the objects related to the CH entity in CHF, this would allow display in both currencies, object (CHF) and controllin area (EUR)