SAP HANA Data Source Limitations and Characteristics
These notes pertain to SAP HANA SPS 09:
• SAP HANA DATETIME types have an ABAP-specific special value of EMPTY, which is not the same as NULL. The SAP HANA JDBC driver passes both EMPTY and NULL values to TDV as NULL, and so the results of some calculations made in TDV versus in SAP HANA may differ.
For example, the function ADD_DAYS (DATE_ADD in TDV), when given an EMPTY value and 1 as arguments, returns 0001-01-02 when executed in SAP HANA, and NULL when executed in TDV, because TDV sees the first argument as NULL.
• SAP HANA supports the return of cursors from procedures. You need to expand the cursor signature and save that change on the procedure; otherwise, the procedures will not display the results. You can check Design Mode in Studio and then use Design by Example to do this. See Defining a Cursor for Projection, and Designing a Cursor by Example.
• SAP HANA analytical views are multidimensional objects similar to OLAP cubes. A simple “SELECT *” query or “Show Contents” on such a view does not work. A valid query against an analytical view must contain an aggregate function and a GROUP BY clause.
• The following TDV functionality cannot be used with SAP HANA analytical views due to their multidimensional nature:
— Caching
— Statistics gathering
— Discovery