Get Example source ABAP code based on a different SAP table
ABAP_DDIC - Dynamic Caches A dynamic cache is a HANA tuning object that serves as an interface between dynamic result caches in SAP HANA and DDIC views. A dynamic cache is defined for a DDIC database table. It defines a restricted subquery on the database table with the goal to cache read results of the table in question to avoid repeated aggregation. This optimizes the performance in certain use cases. At the same time, a dynamic caches guarantees up-to-date data. Each time the cached database table is updated with INSERT, the cached data is updated automatically. ABAP Dictionary dynamic caches are defined using the
Dictionary DDL for Defining Dynamic Caches
ABAP_FURTHER_INFO ABAP Data Models development guide, section about HANA Tuning Objects.
Latest notes:
SAP HANA offers static and dynamic view caches. Only the dynamic version has been integrated into DDIC. Static view caches are called Result Cache on SAP HANA, and dynamic caches are called Dynamic Result Cache.
A DDIC dynamic cache is generated as SQL view on the database. Therefore, it is also referred to as view cache. NON_V5_HINTS
Further details on SAP HANA cached views and an executable example can be found in the topic about Cached Views in SAP HANA . ABAP_HINT_END
