relation between tables

Former Member — Sat, 19 Jun 2010 09:15:44 GMT

Dear all,

can you please tell me is there any relation between ska1 and bkpf?

Re: relation between tables

Former Member — Sat, 19 Jun 2010 18:37:38 GMT

hey

Go to transaction SQVI and create JOIN table query and than you will see the relations between the tables .

regards

ASA

Re: relation between tables

Former Member — Sun, 20 Jun 2010 19:47:59 GMT

Yes - they are both transparent tables.

Rob

Re: relation between tables

Former Member — Sun, 20 Jun 2010 22:26:57 GMT

they are both transparent tables

Excellent answer, but considering the question I think the poster needs possibly a longer explanation to fully understand and appreciate your answer. I will try to help, so let me start with some necessary definitions:

S is the set of all SAP tables

T is the subset of S of all transparent tables, i.e. T = { t∈S | t is a transparent table }

R is the relation (S, S, I) with I = { (a,b)∈S×S | a,b∈T }</li> </ul> If you look at the relation R, you'll see that it's reflexive, symmetric and transitive. The relation R reveals hidden (or at least non-obvious) links like for example the relation between bkpf (accounting document header) and t143 (temperature conditions for storing materials).

This shouldn't come as a surprise though, because SAP is an integrated system. It is amazing how the relation R also shows the difficulties to achieve full integration: Take for example bkpf and bseg (accounting document segment), which are not in R (note that R is not a total relation). I suspect though that in some future release this issue might be fixed and strongly recommend checking release notes.

Cheers, harald

Re: relation between tables

Former Member — Mon, 21 Jun 2010 13:07:58 GMT

;-(

Rob

topic Re: relation between tables in Application Development and Automation Discussions

relation between tables

Re: relation between tables

Re: relation between tables

Re: relation between tables

Re: relation between tables