Please enable JavaScript.

Coggle requires JavaScript to display documents.

Open SQL (New Open SQL (Improvements over older Open SQL (Allows…

- - - - Dropped
        
        Max dbtab in JOIN
        
        Flds of RHS dbtab
        in WHERE clause of
        LEFT OUTER JOIN
        
        RIGHT OUTER JOIN
        
        Only = in ON cond.
      - Persisting
        
        Access to Native
        HANA artifacts
        
        UNION [ALL]
    - - Arithmetic
        Expr
        
        MOD
        
        +, -, *, DIV
        
        ABS
        
        CAST col AS FLTP
        
        CEIL, FLOOR
      - String
        Expr
        
        &&
      - Conditional
        Expr
        
        CASE
        
        COALESCE
  - - - Reduce necessity
        to resort to
        Native SQL
        
        DB Dependent
- - - - DML
        
        Reflected
        in ABAP
        
        SELECT
        
        INSERT
        UPDATE
        MODIFY
        DELETE
      - DDL
        
        Reflected
        in ABAP
        
        CDS
        SP05 Onwards
        
        DDIC
      - DCL
        
        Not reflected
        in ABAP