Skip to content

ABAP Keyword Documentation →  ABAP Dictionary →  Classic Objects in ABAP Dictionary →  Database Tables →  Technical Attributes of Database Tables →  Table-Specific Technical Attributes of Database Tables 

Storage Type of Database Tables

The storage type only has an effect if the current database is an SAP HANA database. The specified storage type has no effect on other database systems. In this case, the platform-specific storage type is used. The following settings can be defined for the SAP HANA database:

  • Column store
This setting should be used in following cases:
  • The database table is designed for application data analyzed in SAP HANA.
  • The database table contains a very large number of rows and the storage type column store provides better compression.
  • The database table contains table fields with HANA data types that are supported only by the storage type column store.
  • Row store
This setting should only be used in SAP HANA databases if the database table is used mainly for frequent single row accesses.
  • Undefined
  • This setting cannot be used for transparent tables. Column store or row store must be specified for these tables instead.
  • This is the only setting possible for pooled tables and cluster tables Pooled tables and cluster tables are not characterized as database tables on the database, which means there is no point in specifying a fixed storage type. The fixed storage type is set when pooled tables and cluster tables are transformed to transparent tables. Column store is usually the recommended type here.

Other versions: 7.31 | 7.40 | 7.54


Note

For more information about the differences between row store and column store on the SAP HANA database, see the SAP HANA Platform documentation.