Ansicht
Dokumentation

ABENHANA_CACHED_VIEWS_ABEXA - HANA CACHED VIEWS ABEXA

ABENHANA_CACHED_VIEWS_ABEXA - HANA CACHED VIEWS ABEXA

General Data in Customer Master   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

SAP HANA, Cached Views

This example demonstrates access to a cached view on the SAP HANA database.

Source Code

Execute

Description

The instance DEMOCDSCACH of the CDS view DEMO_CDS_CACHED_VIEW on the SAP HANA database is designed for caching using ADBC and the SQL statement ALTER TABLE. The maximum cache lifetime cannot be specified. It is also possible to delete an existing cache.

When the CDS view is accessed using the statement SELECT, the database hint %_HINTS HDB 'RESULT_CACHE' can be used to specify that the cache is accessed.

The addition EXTENDED RESULT of the INTO clause can be used to determine whether a cache is available, and the cache properties are read.






Fill RESBD Structure from EBP Component Structure   General Material Data  
This documentation is copyright by SAP AG.

Length: 1683 Date: 20240328 Time: 094555     sap01-206 ( 29 ms )