Skip to Content
author's profile photo Former Member
Former Member

How to konw which tables were included in Cluster and Pool table?

Such as BSEG,it integrates data from table BSID BSAD BSIS BSAS BSIK BSAK.

But how should we find those tables above?

Looking for your respond!

Best Wishes!

Edited by: lorryhappy on Dec 18, 2009 11:59 AM

Edited by: lorryhappy on Dec 18, 2009 12:01 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2009 at 10:02 AM

    Hi Lorry,

    Go to SE11 And give BSEG and Press Display then go the tab DELIVERY & MAINTANANCE You will find the value of

    POOL/CLUSTER. Double click on it. It will take you to Cluster Display screen. Then find the where used list of POOL/CLUSTER in Tables. It will display all the tables used in that POOL/CLUSTER.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2009 at 04:58 AM

    Hi ,

    1)DD02L has all the details about tables.Please check the field TABCLASS.

    2)Cluster and pooled table details are in DD06L.

    "TABCLASS domain values
    TRANSP	Transparent table
    INTTAB	Structure
    CLUSTER	Cluster table
    POOL	Pooled table
    VIEW	General view structure
    APPEND	Append structure

    BSEG is stored in cluster RFBLG ,which is a Cluster for accounting document.The below tables are stored in this cluster

     BSEC       A                CLUSTER  RFBLG
     BSED       A                CLUSTER  RFBLG
     BSEG       A                CLUSTER  RFBLG
     BSES       A                CLUSTER  RFBLG
     BSET       A                CLUSTER  RFBLG

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 18, 2009 at 04:57 AM

    Hi

    Go to SE11 And give BSEG and Press Display then go the tab DELIVERY & MAINTANANCE You will find the value of

    POOL/CLUSTER and pass this value to SQLTAB in table DD02L

    go to DD02L and pass SQLTAB = RFBLG

    YOU find the following values.

    BSEC                           A        0000    CLUSTER  RFBLG
    BSED                           A        0000    CLUSTER  RFBLG
    BSEG                           A        0000    CLUSTER  RFBLG
    BSES                           A        0000    CLUSTER  RFBLG
    BSET                           A        0000    CLUSTER  RFBLG
    BSSEG                          A        0000    CLUSTER  RFBLG

    Hope this solve your problem

    Cheerz

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2009 at 04:58 AM

    Answered

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2012 at 02:58 PM

    we have the following problem, the tables incluides in the table cluster are cluster, table cluster AUAA, the SQLTAB is equal in almost.

    The problem that we have is that the table cluster includes other tables cluster, for what the SQLTAB is the same, we do not have identify like the tables that compose to the tables cluster of the second level.

    Thanks for yours helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.