topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Tue, 29 Jul 2008 13:37:17 GMT

Why Master table can't be used as pool or cluster table?

Re: Table

Former Member — Tue, 29 Jul 2008 13:45:39 GMT

Why Master table can't be used as pool or cluster table?

who said this?

check BSEG

Re: Table

Former Member — Wed, 30 Jul 2008 05:36:03 GMT

Hi anindita,

AS u know master tables are used to retrieve data depending on our requirement but pooled & cluster tables cannot be used with joins,that is the reason why master tables are generally avoided as pooled & cluster tables.However it is not restricted to create master tables as pooled & cluster tables.

Best of luck,

Bhumika

Re: Table

Former Member — Wed, 30 Jul 2008 05:37:15 GMT

Hi,

there is no thumb rule that "Master table can't be used as pool or cluster table".

Regards,

Anirban

Re: Table

Former Member — Wed, 30 Jul 2008 15:35:22 GMT

becase all the masters tables are mostly used as transparent thats why you never seen this in general.....but we cannot use as well ..

Re: Table

JozsefSzikszai — Wed, 30 Jul 2008 15:37:07 GMT


> Why Master table can't be used as pool or cluster table?
> who said this?
> 
> check BSEG

actually BSEG is transaction table

Re: Table

Former Member — Thu, 31 Jul 2008 06:06:45 GMT

Thanks a lot for your answer.

Can u help me to find out the answers for the following questions -

1.Can u suggest me that if I don't use join, only for select

statement can master table be created as cluster or pooled

table?

2. What are the code written to retrieve , update or delete data

from Cluster or Pooled table?

3. What is the basic deifference between Cluster and Pooled

table?

Re: Table

Former Member — Thu, 31 Jul 2008 08:25:49 GMT

Hi,

In short to summarize the answer to your queries:

Pooled table

u2022 Every physical pool contains one or more pooled tables. Every record in a pooled table

corresponds to a record in a physical pool.

u2022 No index definition possible in ABAP Dictionary.

Cluster table (store together what belongs together)

u2022 Cluster tables combine functionally-dependent data that is distributed over different tables. The

intersection of the key columns of the cluster tables form the key of the table cluster (cluster

key).

u2022 No index definition possible in ABAP Dictionary.

u2022 ABAP clusters can store any internal table data together in the database.

Hope this helps,

Poornima