2007 Mar 11 6:36 PM
hi expects,
what is foreign key enforcement?
2007 Mar 11 7:33 PM
Hi Rohit
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.
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.
2007 Mar 15 11:28 AM
Hi Guys,
But does this enforcement work when you write to the table via an 'INSERT' statement?
Thanks
Sanjay
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |