How to find ForeignKey in SAP Dictionary tables?

Table AUFK has a column called ADRNRA.

The values in column ADRNRA have matching rows in table ADRC.

In this case I found ADRC because someone told me the solution.

Maybe I am blind, but it looks like AUFK-ADRNRA is no explicit foreign key.

Is there a way to do introspection and find the matching related table (in this example ADRC) with a script or with SQL?

Solution

Indeed the field is not marked as foreign key of the field ADDRNUMBER of the table ADRC but should you have looked at the domain of the field ADRNRA of the table AUFK you would have found the reference in just a few seconds.

The domain (in this case AD_ADDRNUM) has an explicitly specified value table which is, surprise, surprise, ADRC.