How To Fix CPF063 - Formula &1 is used in at least one document.

SAP Error Message - Details

• Message type: E = Error

• Message class: CPF -

• Message number: 063

• Message text: Formula &1 is used in at least one document.

What causes this issue?

You tried to change a formula that is already used in a document.

System Response

You are allowed to change a formula that is already used in a document,
but must bear in mind that your change has an impact on all documents
where the formula is used.

How to fix this error?

We recommend that you do not change a formula that is already used in a
document.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CPF063 - Formula &1 is used in at least one document. ?

  The SAP error message CPF063, which states "Formula &1 is used in at least one document," typically occurs in the context of SAP's formula management, particularly in modules related to production planning, costing, or similar areas where formulas are defined and utilized.
  Cause:
  This error indicates that the formula you are trying to delete or modify is currently in use in one or more documents. This could include:
  
  Production orders
  Costing documents
  Recipes
  Bills of materials (BOMs)
  Other related documents that reference the formula
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Identify Usage: Determine where the formula is being used. You can do this by:
  
  Checking the relevant transaction codes (like C223 for formulas) to see if the formula is linked to any active documents.
  Using the SAP transaction code SE16 or SE11 to query the database tables that might reference the formula (e.g., tables like T001, T003, etc.).
  
  
  
  Review Documents: Once you identify the documents using the formula, you can:
  
  Review the documents to see if they can be modified or if the formula can be replaced with another one.
  If the documents are no longer needed, consider archiving or deleting them if appropriate.
  
  
  
  Modify or Delete: If you need to modify or delete the formula:
  
  Ensure that all documents referencing the formula are updated to use a different formula or are deleted if they are no longer necessary.
  After making the necessary changes, you should be able to delete or modify the formula without encountering the CPF063 error.
  
  
  
  Consult Documentation: If you are unsure about the implications of modifying or deleting a formula, consult your organization's documentation or reach out to a functional consultant who specializes in the relevant SAP module.
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as:
  
  C223: Change Formula
  C222: Display Formula
  C221: Create Formula
  
  
  SAP Notes: Check SAP Notes for any known issues or additional guidance related to CPF063.
  User Roles: Ensure you have the necessary authorizations to view and modify the documents and formulas in question.
  
  By following these steps, you should be able to resolve the CPF063 error and manage your formulas effectively within SAP.