Skip to Content
Technical Articles
Author's profile photo Cirlei Guedes

How to Import Financial Plan Data

I have seen that some users are still not clear about how plan data import works or how it behaves in SAP S/4HANA Cloud – Finance.

For this reason, I am writing this blog post, I would show you an example of a case where the mistake is common.

Let’s call this Case X, below I am putting an example of the description of the issue given by a user:

Symptom

Planned values missing on Profit Center in the SAP Firori app ‘Profit Centers – Plan/Actual’.

“SAP Fiori App: Import Financial Plan Data”

— Support Assistant —
Product / Product Area Selected
SAP S/4HANA Cloud – Finance

Path Taken
Management Accounting and Margin Analysis
Overhead Accounting
SAP Fiori App: Import Financial Plan Data

Questions Answered

Q: What error do you encounter?
A: Cost Center and Profit Centers are not showing the same values.

— Description —

The Cost Center Plan was uploaded to the P system and is displayed in the Cost Center report (for Cost Center 10101301 assigned to Profit Center YB110). But the same values are not populated in the Profit Center report (for Profit Center YB110). 

 

Following, I would explain with an example, how the import plan data app works and why the user has these results.

In this example, I am using the SAP Fiori App “Import Financial Plan Data” to upload financial plan data stored in a comma-separated values file (CSV file).

App%3A%20Import%20Financial%20Plan%20Data

 

In this example let’s see why it happened:

 

Step 1 –  Import Cost Center plan data

 

I import plan data records stored in my CSV file.

 

Plan%20data%20scope

 

Attention! The Profit Center will be derived.

 

Table%20ACDOCP

Table ACDOCP

 

 

Now I can see the result in this reporting

 

The Cost Center 10101301 and Profit Center YB110 have as plan data the amount of $1.000,00

 

Step 2 –  Now I am importing the Profit Center YB110 Plan Data with a different account number 410000000

Attention! The third row defines the planning scope.

You must define the scope of your plan data in the source file. To do this, enter an X for each field that you want to be part of the scope of your plan data.

In the source file, you specify the plan data that you want to be imported into the system. Each plan data value in the file that belongs to a field marked with an X contributes to the selection of plan data that will be overwritten by new plan data. This means that existing plan data in the system that contains any of the combinations of these values will be deleted before new plan data is posted.

Attention! There is advised about the plan data will be reversed.

 

Result in table ACDOCP:

New plan data from the file are imported, but according to the plan data scope, before all plan data for Profit Center YB110 will be reversed (with Cost Center = blank):

 

Result in reporting:

 

Cost Center Report:

 

Profit Center Report displays data aggregated by Profit Center:

Plan data from the Cost Center are reversed on the Profit Center level

 

So what is the solution for Case X?

If you use a different account for Profit Center plan data you must follow these steps:

  1. Upload Profit Center plan data
  2. Upload Cost Center plan data

or adapt planning scope in Profit Center file:

Add column RCNTR for Cost Center and include it in the planning scope (set “X” in the third row) and leave it blank.

The upload will then only reverse plan data for the Profit Center with the Cost Center blank and it will not reverse plan data for Cost Centers.

 

I hope that this example helps you understand how the SAP Fiori App Import Financial Plan data work.

 

Related Information:

 

You can perform your integrated financial planning in SAP S/4HANA Cloud or SAP S/4HANA 2021 using the following apps:

 

If you need to create a question, start with a descriptive title that briefly outlines what your question is about. When writing your question, please share what steps you took already. Also, provide specific details, such as which product version you are using and what error message you’re receiving. And make sure you apply the appropriate tags. You can ask a question here

 

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.