FOREIGN KEY

[Former Member]

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]

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.

[Former Member]

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]

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.