ALV on HANA - Feature Matrix

[Former Member]

The videos (ALV and FPM on SAP HANA, ALV transformation) and document concerning ALV on HANA are using features which we delivered in NW7.40. But as we are continuously developing the tool, it is not always clearly stated in which support package they are available. This matrix will help you to get an overview on the availability of features in SAP GUI for Windows. Since SAP Basis SP11 the SAP GUI for Java 7.40 (as of revision 2) is also supported - the SAP GUI for HTML will follow.

Feature	Next SP	SAP UI SP12	SAP UI SP11	SAP UI SP10	SAP UI SP9	SAP UI SP8	SAP UI SP7	SAP UI SP6***	NW 7.40 SP4	NW 7.40 SP3	NW 7.40 SP2	NW 7.40 SP0*
Entities supported by ALV with Integrated Data Access (IDA)
DDIC views and tables	X	X	X	X	X	X	X	X	X	X	X	X
Core Data Services(CDS) having simple projection (no analytics support) using native CDS name (don't use DDIC name)	X	X	X	X	X
Basic Functions
Query push down, paging, filtering, sorting, grouping and aggregation in the ALV Grid	X	X	X	X	X	X	X	X	X	X	X	X
API: Selection parameters	X	X	X	X	X	X	X	X	X	X	X
API: Initial Grouping	X	X	X	X	X	X	X	X	X	X	X
API: Initial Aggregation	X	X	X	X	X	X	X	X
Integrated authority-check on SAP HANA	X	X	X	X	X	X	X	X	X	X	X
Application defined authority provider	X	X	X	X	X	X
Unified consumption API for all databases - capability service	X	X	X	X	X	X	X
Integrated text search	X	X
Supported features of Core Data Services(CDS)
Usage of View Parameters	X	X	X	X
Support of Annotations(Key, Label, Currency+ Unit References)	X	X	X
Exists Operator in CDS view Associations (Select Options compliant)	X	X
Special SAP HANA features
Text and fuzzy search on SAP HANA	X	X	X	X	X	X	X	X	X	X
Definition of the search scope for text search	X	X	X	X	X	X	X	X
Consumption of DDIC external views ( Attribute Views only )	X	X	X	X	X	X	X	X	X	X	X
Support for HANA native data types representing DDIC types (e.g. date, time)	X	X	X	X	X	X
API: Support for SAP HANA view placeholder	X	X	X	X	X	X	X	X	X	X
Default sorting with locale, binary search electable	X	X	X	X	X	X	X
Influence the field attributes( Field catalogue API)
Setting of refererence fields (currency and unit relationship, setting of texts)****	X	X	X	X	X	X	X	X	X	X
Field display options (as button, icon, link) and their cell actions	X	X	X	X	X	X	X	X
Setting of data elements exchanging the complete technical representation	X	X	X	X	X
Set presentation mode 'Description' for a field having a DDIC domain fix value list	X	X
Layouting and Personalisation**
Basic layouting features (enabling, disabling of columns) in API and grid	X	X	X	X	X	X	X	X	X	X	X
Fixed key columns	X	X	X	X	X	X	X	X	X
Personalized toolbar buttons	X	X	X	X	X	X	X	X	X
Table display options (title, alternating row pattern)	X	X	X	X	X	X	X	X
Non persistent personalisation (settings dialogue)	X	X	X	X	X	X	X	X	X	X	X
Persisted personalisation (ALV variants)	X	X	X	X	X	X	X	X	X	X
Define a Start Layout	X	X
Access of ALV variants in toolbar	X	X	X	X	X	X
Usability improvements (cell merging of sorted columns, empty table text)	X	X	X	X	X	X
Additional navigation possibilities	X	X
Functions
Single row selection and application functions	X	X	X	X	X	X	X	X	X	X	X
Double click enablement	X	X	X	X	X	X	X	X
Printing and Excel Export (limited to 100 000 selected cells)	X	X	X	X	X	X	X	X	X	X	X
Support of Grouping lines in Excel Export (limited to 1 000 000 selected cells)	X
Disabling of standard functions for business reasons (e.g. aggregation of status codes not allowed)	X	X	X	X	X	X	X	X
F1/F4 support in table cells	X	X	X
Additional features
Complex where conditions	X	X	X	X	X	X	X	X	X	X	X
Treating null values as initial values in database selection	X	X	X	X	X	X	X	X	X	X
Calculated fields in ABAP (e.g. determination of icons)	X	X	X	X	X	X	X	X	X	X
Constant Currency for all values in a column	X	X	X	X	X	X	X	X	X
Integrated fullscreen mode	X	X	X	X	X	X	X	X

*NW 7.40 SP0: ALV on HANA is not released for productive usage - only for test purposes

**Frontend Features require SAPGUI 7.30 Patch 5 (see note 1883738)

*** SAPUI 7.40 SP06 is delivered with NW 7.40 SP05 or separately. As UI delivers on a faster tact, we continue with the UI SPs

****Fields in SAP HANA views do not refer to data elements, hence there are no texts or further DDIC conveniences available. These elements must be handled via the field catalogue API. These features can also be used for DDIC views and tables, but normally they are not necessary in this context