Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

relation between tables

Former Member
0 Likes
835

Dear all,

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

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
    4 REPLIES 4
    Read only

    Former Member
    0 Likes
    796

    hey

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

    regards

    ASA

    Read only

    Former Member
    0 Likes
    796

    Yes - they are both transparent tables.

    Rob

    Read only

    0 Likes
    796
    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
      Read only

      0 Likes
      796

      ;-(

      Rob