Relationship Model between tables

[Former Member]

Hello,

do anybody now if where is any transaction (or similar) that show relationships between multiple database tables? E.G. an Entity-Relationship Model?

I have several tables in one package (about 20), and I want to better understand how they are related.

Thanks for help.

Regards,

Julia

[matt]

Such things exist in some of the training courses that SAP offer. You can get an idea by looking at related logical databases.  Otherwise, there isn't anything really.

[Former Member]

Hi Julia,

Some standard SAP tables have a graphical relationship view (of sorts) available via SE11 but in ~13 years I've never found it to be particularly useful.  If you are talking about custom tables, it is probably completely useless!

I've known colleagues to use an external SQL tool, such as something within the MySQL suite to actually take the time to build the relationship model themselves, as part of either the design or build process.  Of course, this could be done retrospectively with already existing tables.  The advantage is that you will probably learn all you need to know about the table relationships whilst building the model - the downside being the amount of time it may consume and of course, if the SAP tables change, you will need to maintain the relationship model in parallel.

Hope this helps,

Gareth.

[former_member282968]

Hi Julia,

Please check the below info, it may help in your task:

1.Goto t-code SQVI.

2.Give a test QuickView name and create with data source 'Table join' in layout mode.

3.Goto Edit->insert table.Mention the table name and add the table.

Like wise you can insert as many table as you want and in the layout mode the key relationships are shown.

Hope this helps for you.

With regards,

[Puneet_Gupta]

Hi Julia,

I don't think there is an easy way to look for all the tables at once.

The only way within SAP would be within SE11 via the graphic button (Ctrl+Shift+F11).

The other cumbersome version would be to find a Where Used List restricted to used in "Database Tables" but this will not give the relationships. You will have to figure out that piece manually looking at each table.

Thanks,

Puneet