数据字典中的三种类型数据表

最新推荐文章于 2026-05-03 09:32:03 发布

原创最新推荐文章于 2026-05-03 09:32:03 发布 · 712 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#数据库 #sql #oracle

ABAP 专栏收录该内容

339 篇文章

订阅专栏

本文详细介绍了ABAP数据字典中的三种表类型：透明表、池表和簇表。透明表具有一对一的关系，数据库中表名与字段名与ABAP字典相同，主要用于存储应用数据。池表用于存储系统数据和定制数据，多个ABAP字典表对应数据库中的一张表池，包含大量小记录。簇表同样用于存储应用数据，多个表组成一个簇表，数据量较大。池表和簇表的数据库表名和字段名与ABAP字典不同，且簇表不支持JOIN操作，查询性能较低。

文章目录

- - 1 Introduction.
  - 2 Detail

1 Introduction.

In the sap ,there are three kinds of table. I will demostrate it in the detail. They
are Transparent table ,Pooles tabel,Cluster tables.

2 Detail

Transparent table: One to one relation

One table in data dictionary equal to one table in data base.

i. e When u create one transparent tabel in ABAP dictionary one table will be created in Database(Typically Oracle, U can have others also) with same name(Both tabel and fields).

Basically used to hold application data.

EG: EKKO,VBAK etc.

Pooles tabel: Many to one relationship

Many tables in ABAP dictionary equal to one table pool in database. Basically used to hold system data and customization data. One table pool contains large number of pooled tables having data of around 100 records each.

Cluster tables: Many to one relationship

Many tables in ABAP dictionary equal to one table cluster in database. Basically used to hold application data. One table cluster contains few number of cluster tables having data of around large quantities.(In lakhs)

eg:CDPOS, BSEG etc.

Incase of pooled and cluster tables ABAP data dictionary table name and Data base table and field names differs unlike same in case transparent table.

There are some limitations on cluster tables like we can’t use joins on these tables, Select on cluster table is always very slow.

When ever we write query on any cluster table in the table cluster data will be fetced for all the table as data for all the tables in the cluster stores as a single record.

In reality we hardly create pooled and cluster tables.