relation between tables

[Former Member]

Dear all,

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

[Former Member]

Dear all,

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

[Former Member]

hey

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

regards

ASA

[Former Member]

Yes - they are both transparent tables.

Rob

[Former Member]

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

1. 
   

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

1. 
   

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

[Former Member]

;-(

Rob