How To Fix FMPP027 - Creation of columns is only allowed with local currency (Col &1)

SAP Error Message - Details

• Message type: E = Error

• Message class: FMPP - Planning processor

• Message number: 027

• Message text: Creation of columns is only allowed with local currency (Col &1)

What causes this issue?

You want to insert a key figure as an element that uses a currency other
than the local currency. This is not permitted.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Use the local currency as the key figure currency.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FMPP027 - Creation of columns is only allowed with local currency (Col &1) ?

  The SAP error message FMPP027 indicates that there is an issue with the creation of columns in a financial report or a similar context where local currency is required. This error typically arises when you attempt to create or modify a report or financial statement that includes columns for currencies other than the local currency defined in the system.
  Cause:
  
  Currency Settings: The report or financial statement you are trying to create or modify is set to include columns for currencies that are not defined as local currency in the system.
  Configuration Issues: The configuration of the report may not allow for the inclusion of certain currencies, or the local currency may not be properly set up in the relevant master data.
  Data Entry Errors: There may be an error in the data entry where the currency type is incorrectly specified.
  
  Solution:
  
  
  Check Local Currency Settings:
  
  Ensure that the local currency is correctly defined in the company code settings. You can check this in the SAP configuration under the Financial Accounting (FI) module.
  Navigate to SPRO > Financial Accounting > Financial Accounting Global Settings > Company Code > Define Company Code and verify the local currency.
  
  
  
  Modify Report Settings:
  
  If you are using a custom report or a standard report, check the settings to ensure that it is configured to allow for local currency columns.
  If necessary, modify the report layout to include only local currency columns.
  
  
  
  Use Local Currency:
  
  When creating or modifying the report, ensure that you are selecting local currency for the columns you want to create. This may involve changing the currency type in the report settings.
  
  
  
  Consult Documentation:
  
  Review the SAP documentation or help files related to the specific report or transaction you are working with to understand the currency requirements.
  
  
  
  Contact SAP Support:
  
  If the issue persists after checking the above settings, consider reaching out to SAP support for further assistance, especially if this is a recurring issue or if it affects multiple users.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as FBL1N, FBL3N, or FBL5N for displaying line items, which may help in understanding how local currency is applied in reports.
  SAP Notes: Check for any SAP Notes related to this error message, as they may provide additional insights or patches that address the issue.
  User Roles and Authorizations: Ensure that the user has the necessary authorizations to create or modify reports, as restrictions may lead to errors.
  
  By following these steps, you should be able to resolve the FMPP027 error and successfully create or modify your financial report with the appropriate currency settings.