topic Link between tables in Application Development and Automation Discussions

Link between tables

Former Member — Fri, 11 Jul 2008 13:27:21 GMT

Hi,

is there a link between CSKS table and USR02 ?

If yes what is the field which links each the above tables ?

Regards

Re: Link between tables

ThomasZloch — Fri, 11 Jul 2008 13:31:12 GMT

CSKS has a foreign key linking USR02-BNAME and CSKS-VERAK_USER.

You could have found that by looking at CSKS in SE11.

Re: Link between tables

Former Member — Fri, 11 Jul 2008 13:32:36 GMT

Hi,

There is a field verak_user in the table CSKS which have a foreign key linking with the table USR02.You would find this relation in ECC 6.0 but not in ECC 4.7.I have checked that.

If you want to find the relationship of two table, just go to the entry help/check tab & see there

Best of luck,

Bhumika

Re: Link between tables

Former Member — Fri, 11 Jul 2008 13:37:59 GMT

Hi,

In these two tables CSKS AND USR02 I found

a field JV_JIBCL which is in CSKS and

a field CLASS in USR02.

The Check table for the field JV_JIBCL is T8J6A.

So in this Check table you have a field called CLASS which is in the table USR02. Just Check it out once.

Regards,

Swapna.

Re: Link between tables

Former Member — Fri, 11 Jul 2008 13:38:56 GMT

Hi,

There is no Foreign key Realtionship or any kind of Realtionship Between these two table In Below Version ECC 6.

But in Version ECC6 you will find the Foreign key relationship

between them.

Regards,

Sujit

Re: Link between tables

Former Member — Fri, 11 Jul 2008 13:47:58 GMT

Hi,

If you are using ECC 6.0 version the go and check in Entry and help check tab..

If you are using 4.7 EE version then there is no relation..

Regards

Narin Nandivada