8 Kasım 2008 Cumartesi

Cluster & Pool tables



 









 Should be accessed via primary key-very fast retrival otherwise very slow
  No secondary indexes
  No aggreagate functions (sum,avg,min,max)
  pool and cluster table is many to one
  cannot be read outside SAP
  Cluster Tables : BSEC BSED BSEG
  













The basic idea of a table pool, as opposed to table clusters, is storage of data records from the tables defined in the ABAP Dictionary that are not dependent on one another.You would like combine small R/3 tables to a database table.
Pool tables are defined to host lots of small tables.
Pool tables --> A001 A002 A003








Hiç yorum yok: