I have written a inner join to join tables: MARA and MAKT.
In both tables, column MATNR is common so i join them. Still i get duplicate values when i run the query so i need to find more columns that are related by primary key and foreign key.
In SE11 (MARA table), the Fields tab shows the primary keys for MARA and Entry help/check tab tells me about foreign keys on table MARA and the check table name.
However, None of the foreign keys show check table as MAKT.
So how do i decide how are MARA and MAKT related?