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
0 Replies