I have created 2 ztables in se11, namely ztable 1 and ztable2 . I wanted to assign ztable1 as the check-table of ztable2, where the common key-field is zcolor.
To do this I have defined their value-table first, where ztable1 is the value-table for both.
Now in the foreign key relationship table of ztable1 I have chosen ztable1 as its own check-table and ztable2 as its foreign-key table, where the foreign-key field is - zcolor.
Whereas for ztable2, the check-table is ztable1 and the foreign-key table (and fields) are left blank.
Upon doing so none of the table can be activated and error messages are shown like - 'ztable1 can't be activated as it is the check-table and foreign-key table as well ' -
Please help me.