topic Relationship between two tables in Application Development and Automation Discussions

Relationship between two tables

Former Member — Wed, 07 Feb 2007 07:27:33 GMT

Hi,

Can some one tell me how can i find the relationship between two tables in CRM. is there any transaction for the same. Is it possible to see the data model.

Thanks

Akila.R

Re: Relationship between two tables

Former Member — Wed, 07 Feb 2007 07:30:10 GMT

Hi,

try to generate a view for those tables and take fields from there

Regards

Shiva

Re: Relationship between two tables

Former Member — Wed, 07 Feb 2007 07:31:46 GMT

Do i need a OSS developer key to create a view, please tell me the trsan code where i can create a new custom view

Thanks

Akila.R

Re: Relationship between two tables

Former Member — Wed, 07 Feb 2007 07:46:35 GMT

No need of access key for this

goto se11 and create a view with starting Z

goto SQ02 or SQVI and generate a query

Regards

Shiva

Re: Relationship between two tables

Former Member — Wed, 07 Feb 2007 08:17:01 GMT

Hi,

By relationship do you mean a <b>foreign key or check table </b> kind of relation?

or do you mean data relationship?

In case you want to know the foreign key or checktable relation, you can go to se11 and display one table and then choose foreignkey/check table tab and see if the other table is present against any field. If yes then it means they have a relationship otherwise you have to check how the two tables are used to determine data relationship.

Hope this helps

Regards

Nishant

Re: Relationship between two tables

Former Member — Thu, 08 Feb 2007 20:38:36 GMT

Go to se11 and enter that table. Do a where use on the data element searching within tables. It'll give list of all tables using that same data element/field. Chances are you'll find some type of relationship from those list of tables if they exist.

Re: Relationship between two tables

Former Member — Wed, 21 Nov 2007 16:40:13 GMT

Hi Nishant ,

Could you please explain brief about the Data relationship ......??

I can see the Foreign Key & Check Table relation in se11 .

Since I am in the Analysing phase ,

what are all the details can i get from Foreign Key & Check table kind relations ...??

Thanks

Rgds

Ganesh