rerarding transparent tables

[Former Member]

is there any option to check to check whether table is transparent table or poole or cluster table.

whther it possible to change transparent table to other by changing that option????????

[Former Member]

hI,

Go to se16 enter DD02L---Click on table contents(F7),Then enter ur desird table name then excute u will get the result.

Regards

[Former Member]

It's possible, but SAP strongly recommends against it. Please see for instance note 24864.

Rob

[Former Member]

go to se11

give table name

click display

before the table name we have the type of table

that is whether transparent,pooled ,cluster.

ex: mara- transparent table

bseg - cluster table

a001- pooled table

[Former Member]

Change table format??? - No!!

A transparent table has a key and data fields which are stored like this in the database (perhaps optimised by the database engine in some way)

A Cluster table has key fields which include a couple of extra ones such as seqence number, and then has a single long RAW field that holds the data in a compressed format. The database does not know about what fields are in this - the Aplication Server unpacks it and presents it to your application as if it was the fields you asked for. A Cluster table can contain many different data layouts identified by a field in the key that the application server uses to unpach different records in a different way.

Pooled tables are separate in the dictionary, but can be stored in a common table in the database.

So any change to the definition in SE11 will mean SAP will be unable to read the data in the table as it will be looking at it the wrong way. The only way to convert tables like this is to have a program that exports all existing data from the current format and then inserts it back into the new format table(s) - this is not a trivial exercise, especially given that most cluster / pooled tables are quite large.

Check out http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

Andrew

[Former Member]

<i>is there any option to check to check whether table is transparent table or poole or cluster table.</i>

<b>

go to se11

enter table name -> click display.

in the left of the table name it would be given the type.</b>

<i>whther it possible to change transparent table to other by changing that option????????</i>

<b>Changing to pooled table

se11 --> extras --> enter table name

select Change table category .</b>

regards,

srinivas

<b>*reward for useful answers*</b>

[Former Member]

hi subash,

It is shown explicitly on the screen of se11 when we press disply button after entering table name...

To change go to extra and go to Change table Category..

Kindly reward if useful....

Regards,

Mandeep.

[Former Member]

Hi,

Go to se11

Enter table name -> click display.

In the left corner of the table it will show the type of table.

Ex:-1. For kna1 it will be.

Transparent Table kna1

2. For bseg it wil be

Cluster Table bseg.

3. For t001g it will be.

Pooled table t001g.

Above i have given the example for three types of tables.

For example go to se11 display the table like bkpf after that click on display button.

In application tool bar click on other object button give the table name then click on continue.

Reward points if useful.

Thanks & Regards,

Vasudeva Rao.

[Former Member]

go to se11

enter table name -> click display.

in the left of the table name it would be given the type.

For eg for mara ble it will be

Transparent Table MARA

for BSEG it wil be

Cluster Table BSEG.

Changing to pooled table....

Go to extras in se11 after enter the table name .

select Change table category .Here u can chge table type

reward if useful

table.

Message was edited by:

Arjun Puthuruthy