topic Re: database table relationships ?? in Application Development and Automation Discussions

database table relationships ??

Former Member — Fri, 27 Apr 2007 03:51:43 GMT

Hi,

i want to konw how to check the relationships among database tables, based on foreign key, for example, relations among "SCARR, SPFLI, SGEOCITY, SCOUNTER....."

better there's a diagram description .

thanks!

Re: database table relationships ??

Former Member — Fri, 27 Apr 2007 03:54:47 GMT

zhang ,

give your mail id i will send docs.

Re: database table relationships ??

SantoshKallem — Fri, 27 Apr 2007 03:56:52 GMT

check it in tcode sqvi (quick viewer)

give the table names in table join method.

Re: database table relationships ??

Former Member — Fri, 27 Apr 2007 03:59:58 GMT

In the tables SPFLi and SCOUNTER check against the field CARRID the foreign key check table is SCARR

so the link between these tables are SCARR-CARRID = SPFLI-CARRID.

and SCARR-CARRID = SCOUNTER-CARRID

other table SGEOCITYdoesn't have any foreign key relationship with those above tables SCARR and SPFLI

but you can link with the CITY and COUNTRY fields of this table SGEOCITY with the CITYFROm and COUNTRY FROm or CITY TO or COUNTRY TO fields as per the requirement

reward if useful

regards

Anji

Re: database table relationships ??

Former Member — Fri, 27 Apr 2007 04:57:49 GMT

hi, kaipha,

my mail is zhangkun167@163.com

thanks!

Re: database table relationships ??

Former Member — Fri, 27 Apr 2007 05:10:19 GMT

yes, Anji,

but how to know whether there's a foreign key or not ?

i know SCARR-MANDT restricted by T000, and SCOUNTER-CARRID by SCARR, and SPFLI-CITYTO restricted by SGEOCITY, etc.

i just want to know if i key in "SPFLI " in some place, whether the system can show me the table name "T000, SCARR, SGEPCOTY", for example, and how these table relate with SPFLI.

Re: database table relationships ??

Former Member — Fri, 27 Apr 2007 05:20:13 GMT

Hi,

Goto SQVI,

create new query

goto layout mode

add tables one by one

u will find (foreign) relationship automatically

this is common for all SAP table ...

Hope it will help u.

Jogdand M B