Skip to Content
author's profile photo Former Member
Former Member

Currency In Planning - EC PCA

Hello SAP Gurus,

I have a request from my customer to load their budget and for that I'm using 7KE1 and 7KE3 transactions depending on GL account types.

The first issue is how to do a mass upload using excel?

=> I found some different posts on that topic. In the menu of those transactions, I found the option to do it :Planning > Plan Data Transfer > Upload from Excel > Execute

How can I determine the file layout correctly?

Second issue is about the currency. The controlling area in maintained in EUR but I would like to load the budget in BRL Currency ? In T-code 0KE5 the Profit Center Local currency type is 30 - Group Currency.

How can I display a different currency than EUR in 7KE1 and 7KE5?

Many thanks for your help on those 2 questions,

Karim

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 13, 2015 at 09:38 AM

    Hi Karim,

    Regarding planning in currency other that PCA currency (equal to group currency in your system): Just define or make use of a planning layout in transaction currency such 8A-191 "PrCtr in Trans. Cur".

    --> In transaction 7KE1, you can navigate between the different planning layouts assigned to your planner profile (SAP800 & SAP801 in standard) using the arrows.

    The value in transaction currency will be translated to PCA currency using the exchange rate type and value date stored in the PCA parameter of your version (in standard exchange rate type P and value date corresponding to the 01.01 of the year).

    I have no experience with mass planning upload using Excel but I already activate excel integration with planning layout as follow: in customizing for planner profile, navigate to "Layouts for Profit Center Accounting" then activate the check box "Integrate Excel" for your planning layouts.

    Good luck.

    Th.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Karim,

      Unless I am wrong, it is not possible to plan on profit center with dimension cost center (company code and functional area are possible).

      What you can do is execute cost center planning and due to cost center/profit center assignment, it will be reflected in profit center accounting.

      In any case, I suggest that you consider the above approach first (cost center planning with mirroring on profit center) and that you save profit center planning for area that cannot be planned to on cost centers (balance sheet accounts).

      Good luck,

      Th.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.