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

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