1. SAP Glossary
  2. ABAP Dictionary
  3. constant foreign key


What is 'constant foreign key' in SAP BC-DWB-DIC - ABAP Dictionary?


constant foreign key - Overview

  • Component: BC-DWB-DIC

  • Component Name: ABAP Dictionary

  • Description: A foreign key where fields in the foreign key table are checked against constant values.


constant foreign key - Details


  • Key Concepts: A constant foreign key is a type of foreign key in the ABAP Dictionary of SAP. It is used to define a relationship between two tables, where the value of the foreign key in one table is always the same as the value of the primary key in the other table. This type of foreign key is used when there is a one-to-one relationship between two tables.
    How to use it: To create a constant foreign key, you must first create two tables in the ABAP Dictionary. Then, you must define a primary key for one table and a foreign key for the other table. The foreign key must have the same data type and length as the primary key, and it must be marked as “constant”. Finally, you must specify that the value of the foreign key is always equal to the value of the primary key.
    Tips & Tricks: When creating a constant foreign key, make sure that you have defined both tables correctly and that they have compatible data types and lengths. Also, make sure that you have marked the foreign key as “constant” so that it will always have the same value as the primary key.
    Related Information: For more information about creating constant foreign keys in SAP, see SAP Help Portal article “Creating Constant Foreign Keys” (https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/7.5.10/en-US/f8d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84d2f9f3d8a84e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0b6e1b0).

    Already have an account? Login here!





constant foreign key - Related SAP Terms

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