SAP® Documentation

Single view

CL_CHK_CI_2_CM_HANA_CLSTR - ORDER / BINARY SEARCH: Assumptions on order of db content

PERFORM Short Reference   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


This check examines database access in programs:

  • which makes assumptions on the order of database content
  • which accesses dormant cluster tables

Assumptions on Order

The SQL standard defines no implicit sequence for the result set of database queries on 'transparent' tables. Some DBMS have an implicit ordering by the primary key. Nevertheless ABAP programs must not rely on an implicit sort order to ensure platform independency.

ABAP programs need to use an explicit 'ORDER BY' clause or a 'SORT' statement in case a certain sequence is required by the program logic.


This examination follows the data flow over even across compilation units / programs. Multiple code locations / programs can contribute to an ill prone data flow. Each of this location can also contribute a cure to the flaw. And it is to mention that the finding is reported any program within the data flow by intention.

Access to Dormant Cluster Table

This kind of table exists for downward compatible syntax only. But database operations will no longer work out.

BAL_S_LOG - Application Log: Log header data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 1318 Date: 20190617 Time: 091709     sap01-206 ( 26 ms )

Our Service

Looking for Support? Questions?




Leave us your contact details and we will call you back. Panels marked with * are mandatory.