How To Fix FKKINV059 - External number of document additional item &3 is not unique

SAP Error Message - Details

• Message type: E = Error

• Message class: FKKINV - Invoicing in Contract Accounts Receivable and Payable

• Message number: 059

• Message text: External number of document additional item &3 is not unique

What causes this issue?

For the billing document with the <DS:DE.REFDOCNO_KK>external document
number</> &v1& in the <DS:DE.LOGSYS>logical system</> &v2&, the
<DS:DE.REFADDITEM_KK>number of the document additional item in the
external system</> &v3& is not unique.

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?

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 FKKINV059 - External number of document additional item &3 is not unique ?

  The SAP error message FKKINV059 indicates that there is a problem with the uniqueness of the external number for a document's additional item. This typically occurs in the context of the SAP Convergent Charging or Contract Accounts Receivable and Payable (FI-CA) modules, where external document numbers are used to identify transactions.
  Cause:
  The error arises when the system detects that the external number assigned to an additional item is not unique. This can happen due to several reasons:
  
  Duplicate Entries: There may be multiple entries in the database with the same external number for the same document type.
  Incorrect Configuration: The configuration settings for external number ranges may not be set up correctly, leading to overlaps.
  Data Migration Issues: If data was migrated from another system, it may have introduced duplicates.
  Manual Entry Errors: Users may have manually entered the same external number for different transactions.
  
  Solution:
  To resolve the error, you can take the following steps:
  
  
  Check for Duplicates:
  
  Use transaction codes like SE16 or SE11 to access the relevant database tables (e.g., FKKINV for invoices) and search for the external number in question. Identify if there are duplicate entries.
  
  
  
  Correct the Data:
  
  If duplicates are found, you may need to delete or modify the duplicate entries to ensure that each external number is unique.
  
  
  
  Review Configuration:
  
  Check the configuration settings for external number ranges in the SAP system. Ensure that the number ranges are correctly defined and do not overlap.
  
  
  
  Data Migration Review:
  
  If the issue arose after a data migration, review the migration process to ensure that it correctly handled external numbers and did not introduce duplicates.
  
  
  
  User Training:
  
  If manual entry is a common cause, consider providing training to users on how to properly enter external numbers to avoid duplicates.
  
  
  
  Consult SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that may address this specific error or provide additional guidance.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as FKKINV (for invoice management) and FBL5N (for customer line items) to help in troubleshooting.
  Documentation: Review SAP documentation related to FI-CA and external number management for best practices and configuration guidelines.
  Support: If the issue persists, consider reaching out to SAP support for assistance, especially if it involves complex configurations or custom developments.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.