Open

Foreign key is not part of the control table's key

I'm trying to create a table that defines a default bank account for each sales organization. The bank account has to belong to the sales organization's parent company.

My table has the following attributes (keys in bold): MANDT, VKORG, BUKRS, HBKID, HKTID

The problem is that I cannot define (VKORG, BUKRS) as a foreign key to table TVKO because BUKRS is not a key field in TVKO.

I need BUKRS in my table because it is a foreign key to table T012K which stores the bank account