Table

[Former Member]

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

[Former Member]

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

who said this?

check BSEG

[JozsefSzikszai]

>

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

actually BSEG is transaction table

[Former Member]

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

[Former Member]

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?

[Former Member]

Hi,

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

Regards,

Anirban

[Former Member]

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

[Former Member]

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