How To Fix KK397 - Cost estimate was created using Microsoft Excel

SAP Error Message - Details

• Message type: E = Error

• Message class: KK -

• Message number: 397

• Message text: Cost estimate was created using Microsoft Excel

What causes this issue?

You tried to change a cost estimate which was created using Microsoft
Excel using SAP unit costing.
This function is not currently supported.

System Response

The system does not allow you to change the cost estimate using unit
costing.

How to fix this error?

A cost estimate created using Microsoft Excel can only be change using
Microsoft Excel.
You can however display the cost estimate using SAP unit costing.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message KK397 - Cost estimate was created using Microsoft Excel ?

  The SAP error message KK397, which states "Cost estimate was created using Microsoft Excel," typically occurs when a cost estimate is imported into SAP from an Excel file. This error indicates that the system has detected that the cost estimate was not created directly within SAP but rather was generated externally, which can lead to issues with data integrity and validation.
  Cause:
  
  External Creation: The cost estimate was created in Microsoft Excel and then imported into SAP, which is not a standard practice for creating cost estimates in the system.
  Data Integrity Issues: SAP has strict validation rules for cost estimates, and importing data from Excel may bypass these checks, leading to potential inconsistencies or errors.
  Configuration Settings: The system may be configured to reject cost estimates that are not created within SAP.
  
  Solution:
  
  Create Cost Estimates in SAP: The best solution is to create cost estimates directly within the SAP system using the appropriate transaction codes (e.g., CK11N for creating a cost estimate).
  Review Import Process: If importing from Excel is necessary, ensure that the data is formatted correctly and adheres to SAP's requirements. You may need to use specific tools or interfaces designed for data import.
  Check Configuration: Review the configuration settings in SAP to see if there are options to allow for external cost estimates or to adjust validation rules.
  Consult Documentation: Refer to SAP documentation or help resources for guidelines on creating and importing cost estimates to ensure compliance with best practices.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as CK11N (Create Cost Estimate), CK40N (Change Cost Estimate), and CK24 (Display Cost Estimate).
  SAP Notes: Check SAP Notes for any updates or patches related to cost estimates and Excel imports that may address this issue.
  Training and Support: Consider training for users on how to properly create and manage cost estimates within SAP to avoid future issues.
  
  If the problem persists after following these steps, it may be beneficial to consult with your SAP support team or a consultant who specializes in SAP costing and financial modules.