-->

Thursday, October 26, 2023

SAP CLUSTER TABLES


SAP ABAP Cluster Table


·         It has a many-to-one relationship with table in the database.

·         The database table has different name, different number of fields and fields have different names.

·         Secondary indexes cannot be created.

·         They can be accessed using open SQL only.

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

·         Whenever we write query on any cluster table in the table cluster data will be fetched for the entire table as data for all the tables in the cluster stores as a single record.

·         Cluster tables are logical tables that must be assigned to a table cluster when they are defined.

·         Cluster tables can be used to store control data.

·         They can also be used to store temporary data or texts, such as documentation

To get SAP Job Updates