How To Fix KK396 - Reference cost estimate was created using Microsoft Excel

SAP Error Message - Details

• Message type: E = Error

• Message class: KK -

• Message number: 396

• Message text: Reference cost estimate was created using Microsoft Excel

What causes this issue?

You have tried to reference a cost estimate created using Microsoft
Excel when creating a cost estimate to be processed using SAP unit
costing.
This function is not currently supported.

System Response

The system does not allow you to use this cost estimate as a reference.

How to fix this error?

A cost estimate created using Microsoft Excel can only be used as a
reference if it is also to be processed using Microsoft Excel.
If you want to use such a cost estimate, you have to cost using
Microsoft Excel.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message KK396 - Reference cost estimate was created using Microsoft Excel ?

  The SAP error message KK396, which states "Reference cost estimate was created using Microsoft Excel," typically occurs when a cost estimate is imported into SAP from an Excel file. This can happen during the process of creating or updating cost estimates in the SAP system.
  Cause:
  
  Excel Import: The cost estimate was created or modified using Microsoft Excel and then imported into SAP. This can lead to inconsistencies or issues if the data does not conform to SAP's expected format or if there are discrepancies in the data.
  Data Integrity Issues: The data in the Excel file may not meet the necessary criteria or standards required by SAP, leading to validation errors.
  Missing or Incorrect Data: There may be missing fields or incorrect data types in the Excel file that are causing the error when SAP tries to process the cost estimate.
  
  Solution:
  
  Check the Excel File: Review the Excel file used to create the cost estimate. Ensure that all required fields are filled out correctly and that the data types match what SAP expects.
  Use SAP Standard Tools: Instead of importing from Excel, consider using SAP's built-in tools for creating and managing cost estimates. This can help avoid issues related to data integrity.
  Validate Data: Before importing, validate the data in Excel to ensure it meets SAP's requirements. This may involve checking for correct formats, required fields, and valid values.
  Recreate the Cost Estimate: If the error persists, it may be necessary to recreate the cost estimate directly in SAP rather than importing it from Excel.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on creating cost estimates and the requirements for data formats.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific patches or updates related to this error message. SAP frequently releases updates that may address known issues.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Training and Best Practices: Consider training for users who are responsible for creating cost estimates to ensure they understand the proper procedures and tools available within SAP.
  
  By following these steps, you should be able to resolve the KK396 error and successfully manage your cost estimates within SAP.