topic Re: FOREIGN KEY in Application Development and Automation Discussions

FOREIGN KEY

Former Member — Wed, 09 Jul 2008 08:27:57 GMT

HELLO ABAP MASTERS

I HAVE A PROBLEM CREATING FOREIGN KEY

I CREATED A FOREIGN KEY IN ECC6

I SELECT THE FIELD

I HAVE ASSIGNED SAME DOMAIN TO FIELD IN BOTH CHECK TABLE AS WELL AS FOREIGN KEY TABLE

ACTIVATE

ITS WORKING

BUT WHEN I FOLLOW SAME PROCEDURE IN 4.7

IT CREATES THE FOREIGN KEY

BUT IT ACCEPTS THE DATA WHICH IS NOT THERE IN CHECK TABLE

PLEASE HELP

THANKS IN ADVANCE

REGARDS,

ANIRUDDH

Former Member — Wed, 09 Jul 2008 08:33:36 GMT

Hello anirudh,

Check the name of your check table because foreign key works properly if the right check table is given.

Regards,

Bhumika

vinod_vemuru2 — Wed, 09 Jul 2008 08:48:21 GMT

Hi,

How r u inserting data into table?

If it is through INSERT/UPDATE statements from program then it will not check foreign key relation.

If u try through SM30 it will check the entry in existance in Check table.

Hope it is clear.

Thanks,

Vinod.