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

[Former Member]

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

[former_member1245113]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Answered

[Former Member]

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.