How To Fix SCMP_EXCP009 - &1-&2 is a key field and cannot be excluded


SAP Error Message - Details

  • Message type: E = Error

  • Message class: SCMP_EXCP - Comparison Tool Exception Handling

  • Message number: 009

  • Message text: &1-&2 is a key field and cannot be excluded

  • Show details Hide details
  • What causes this issue?

    You may have tried to put a table/view key field in the exclusion
    table, but key fields are the basis of Cross-System Viewer comparisons.
    If you have made an upgrade and you are reusing a previously-created
    exclusion table, it may contain exclusions which in turn contain key
    fields.

    System Response

    The system does not accept your entries.

    How to fix this error?

    Specify a non-key field, or choose another exclusion type.
    To delete inconsistent entries from older releases (see above):
    Go back.
    Call the exclusion table again.
    Mark all entries which contain key fields.
    Delete these entries.
    Save your changes.
    You can then make new entries.

    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 SCMP_EXCP009 - &1-&2 is a key field and cannot be excluded ?
    The SAP error message SCMP_EXCP009 indicates that a key field is being excluded from a process where it is required. This typically occurs in scenarios involving data processing, such as during the creation or modification of data records in SAP, where certain fields are designated as key fields and must be included in the operation.
    
    Cause: Key Field Exclusion: The error arises when an attempt is made to exclude a field that is defined as a key field in the database table or structure. Key fields are essential for uniquely identifying records in a database. Data Model Constraints: The data model or configuration may have constraints that require certain fields to be present in operations like data uploads, transformations, or during the execution of specific transactions.
    Solution: Review the Data Model: Check the data model or structure definition to identify which fields are designated as key fields. Ensure that these fields are included in your

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author