Where to find the information regarding relationships between the tables?

[Former Member]

I am developing a Windows based app which among other things let’s users view SAP table schema and relationships.

If I use SAP GUI and dig up a bit on say the MARA table I can see that

Material Master (MARA) is related with

1) MaterialDescription (MAKT) on columns MANDT and MATNR

2) MaterialPlantData (MARC) on columns MANDT and MATNR

and so on…

My question is - in which table the information regarding relationships between the tables is stored? There must be a data dictionary table which would be storing the relationships data. Which is it? Note: I will programatically access the table, NOT from the UI.

[Former Member]

Hi Salil,

Has your problem been resolved.

Bye

Dinesh.

PS: Do not forget to assign points!!!

[Former Member]

Hi Salil,

You can use the tables - DD05S, DD08L and DD08T(text).

Bye

Dinesh

[Former Member]

Thanks a lot...

I am still working on it, but here are the current findings. DD05S, DD08L and DD08T: The schemas for these tables were very promising for the thing I was looking for. Unfortunately the data within dose not seem to serve my exact purpose.

I found another one DD26S, which has almost 90% of the relationships I wish to explore. Do you know what is it supposed to contain?

Thanks a lot for your help.

Message was edited by: Salil Khedkar