cluster table

[Former Member]

example for cluster table?

[Former Member]

BSEG Table

Cluster tables - These are logical tables that are arranged as records of transparent tables. One cannot use Native SQL on these tables (only Open SQL). They are not manageable directly using database system tools.

[ferry_lianto]

Hi,

Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

Example Cluster Tables:

BSEC - One-Time Account Data Document Segment

BSED - Bill of Exchange Fields Document Segment

BSEG - Accounting Document Segment

BSES - Document Control Data

BSET - Tax Data Document Segment

CDPOS - Change document items

For more information cluster table, please check this link.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

Regards,

Ferry Lianto

[Former Member]

Hi

Cluster Tables (KONV, BSEG,BSEC)

Should be accessed via primary key - very fast retrieval otherwise very slow

No secondary indexes

Select * is Ok because all columns retrieved anyway. Performing an operation on multiple rows is more efficient than single row operations. Therefore you still want to select into an internal table. If many rows are being selected into the internal table, you might still like to retrieve specific columns to cut down on the memory required.

Statistical SQL functions (SUM, AVG, MIN, MAX, etc) not supported

Reward points for useful Answers

Regards

Anji