https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052533#M423308 <HTML><HEAD></HEAD><BODY><P>Hi Rohit</P><P> It is a concept where if a table field is assigned a foreign key table, then this field can only accept values which are already present in the Foreign key table.</P><P></P><P>For example, you are trying to create an entry in table SPFI from SE11 transaction. Here you have entered CARRID as 'XX'. Here the field SPFLI-CARRID is assigned the foreign key field SCARR-CARRID (Master table for CARRIDs). Now, lets say table SCARR does not have entry 'XX'. In this case the system will prompt an Error message. So here we are enforcing the user to enter a CARRID which already exists in the Master Table (SCARR). I think this explains Foreign Key enforcement.</P></BODY></HTML> Sun, 11 Mar 2007 19:33:37 GMT Former Member 2007-03-11T19:33:37Z https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052532#M423307 <HTML><HEAD></HEAD><BODY><P>hi expects,</P><P> what is foreign key enforcement?</P></BODY></HTML> Sun, 11 Mar 2007 18:36:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052532#M423307 Former Member 2007-03-11T18:36:46Z https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052533#M423308 <HTML><HEAD></HEAD><BODY><P>Hi Rohit</P><P> It is a concept where if a table field is assigned a foreign key table, then this field can only accept values which are already present in the Foreign key table.</P><P></P><P>For example, you are trying to create an entry in table SPFI from SE11 transaction. Here you have entered CARRID as 'XX'. Here the field SPFLI-CARRID is assigned the foreign key field SCARR-CARRID (Master table for CARRIDs). Now, lets say table SCARR does not have entry 'XX'. In this case the system will prompt an Error message. So here we are enforcing the user to enter a CARRID which already exists in the Master Table (SCARR). I think this explains Foreign Key enforcement.</P></BODY></HTML> Sun, 11 Mar 2007 19:33:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052533#M423308 Former Member 2007-03-11T19:33:37Z https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052534#M423309 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>But does this enforcement work when you write to the table via an 'INSERT' statement?</P><P></P><P>Thanks</P><P></P><P>Sanjay</P></BODY></HTML> Thu, 15 Mar 2007 11:28:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/foreign-key-enforcement/m-p/2052534#M423309 Former Member 2007-03-15T11:28:21Z