topic Re: cluster table in Application Development and Automation Discussions

cluster table

Former Member — Tue, 12 Jun 2007 16:34:51 GMT

example for cluster table?

Re: cluster table

Former Member — Tue, 12 Jun 2007 16:45:38 GMT

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.

Re: cluster table

ferry_lianto — Tue, 12 Jun 2007 16:50:18 GMT

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

Re: cluster table

Former Member — Tue, 12 Jun 2007 16:51:09 GMT

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