SAP DDIC DATABASE TABLES STORAGE



Get Example source ABAP code based on a different SAP table
  



ABAP_DDIC - Storage Type of Database Tables
The storage type has an effect only if the current database is an SAP HANA database. The specified storage type is ignored by other database systems and the platform-dependent storage type is used instead. The following settings can be defined for the SAP HANA database:
Column store This setting should be used in the following cases:
The DDIC database table is designed for application data analyzed in SAP HANA.
The DDIC database table contains a very large number of rows since the storage type Column Store provides better compression.
BEGIN_SECTION VERSION 5 OUT
The DDIC database table has a full text index.
END_SECTION VERSION 5 OUT
The DDIC 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. For global temporary tables (GTTs), it is the only possible setting.



Latest notes:

For more information about the differences between row store and column store on the SAP HANA database, see the SAP HANA docu mentation.
NON_V5_HINTS
ABAP_HINT_END
BEGIN_SECTION SAP_INTERNAL_HINT
The setting undefined was possible for pool and cluster tables only.
END_SECTION SAP_INTERNAL_HINT