topic Re: Relationship Model between tables in Application Development and Automation Discussions

Relationship Model between tables

Former Member — Mon, 18 Jun 2012 15:52:06 GMT

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

Re: Relationship Model between tables

matt — Wed, 20 Jun 2012 10:57:58 GMT

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.

Re: Relationship Model between tables

Former Member — Wed, 20 Jun 2012 12:17:12 GMT

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.

Re: Relationship Model between tables

former_member282968 — Tue, 26 Jun 2012 05:44:11 GMT

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,

Re: Relationship Model between tables

Puneet_Gupta — Tue, 26 Jun 2012 20:48:15 GMT

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