How To Fix AD273 - Foreign key &-& does not originate from foreign key table &


AD273 - Overview

  • Message type: E = Error

  • Message class: AD - Data Dictionary application messages

  • Message number: 273

  • Message text: Foreign key &-& does not originate from foreign key table &

  • Show details Hide details
  • What causes this issue?

    You have selected a foreign key field, which is not in the foreign key
    table.

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

    System Response

    How to fix this error?

    When checking the foreign key against the check table on a screen, make
    sure that this field fits the current contents of the foreign key table.

    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message AD273 - Foreign key &-& does not originate from foreign key table & ?
    The SAP error message AD273 indicates a foreign key constraint violation. This error occurs when you attempt to insert or update a record in a table that references a foreign key, but the value you are trying to insert does not exist in the corresponding foreign key table. 
    
    Cause: Missing Foreign Key Entry: The value you are trying to insert or update in the child table does not exist in the parent table (the table that the foreign key references). Incorrect Configuration: The foreign key relationship may not be correctly defined in the database schema. Data Integrity Issues: There may be data integrity issues where the data in the child table is not aligned with the parent table.
    Solution: Check Foreign Key Values: Ensure that the value you are trying to insert or update in the child table exists in the parent table. You can do this by querying the parent table to see if

    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