How To Fix FDT_EXPRESSIONS117 - Column name &1 is already used in decision table


SAP Error Message - Details

  • Message type: E = Error

  • Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

  • Message number: 117

  • Message text: Column name &1 is already used in decision table

  • Show details Hide details
  • What causes this issue?

    You have tried to add a column with name '&v1&' to the decision table.
    However, a column with that name already exists in the table.

    System Response

    The column cannot be added to the table.

    How to fix this error?

    Rename the column to a name which is unique in the context of the
    current decision table.

    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 FDT_EXPRESSIONS117 - Column name &1 is already used in decision table ?
    The SAP error message FDT_EXPRESSIONS117 indicates that there is a duplicate column name in a decision table within the SAP system. This error typically arises when you are trying to create or modify a decision table and you inadvertently use the same column name more than once.
    
    Cause: Duplicate Column Names: The primary cause of this error is that the decision table has been defined with two or more columns that share the same name. This can happen during the initial creation of the table or when modifying an existing table.
    Solution: To resolve this error, you need to ensure that all column names in the decision table are unique. Here are the steps you can take: Review the Decision Table: Open the decision table in the SAP system and carefully check the column names. Rename Duplicate Columns: If you find any duplicate column names, rename them to ensure that each column has a unique identifier.

    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
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant