CDS Views

Benefits of CDS views
  • Currency/ Unit Conversion
  • No Semantic Gap
  • Reusable SQL



Limitations of Dictionary Views
  • No Outer Join
  • No Complex Joins
  • No inline comments
  • No Unions
  • No View on View

CDS Views
  • WithOut Parameters
  • With Parameters
with Parameters

Session Variables

Aggregate functions


String Functions


LPAD:- in above ex. 20 is the total length, if url is less than 20 then the difference length is filled with 'x' on left side i.e at the begining. 
Substring: Starting from 2nd character in url copy the next 3 characters.
Currency Conversion

Date Function

Numeric Function

Union

Annotations

  • ABAP Annotations:-  Evaluated by ABAP runTime environment.
  • Component Annotations: Evaluated  where it is comsumed, eg OData.
Annotation

Element Annotation

Preserve Key: respect the key field mentioned in Field List.

key field

Key field



OData as Annotation

TCode : /IWFND/MAINT_SERVICE to activate OData Service.






Comments

Post a Comment

Popular posts from this blog

Enhanced SQL

 REPORT zdemo_esql_02. " Usage of Sum expression TYPES: BEGIN OF d_final,          carrid TYPE s_carr_id, *         CONNID TYPE S_CONN_ID,          price  TYPE s_price,        END OF d_final. DATA: gt_final TYPE STANDARD TABLE OF d_final. SELECT sf~carrid, *       SF~CONNID,        SUM( sf~price ) AS price        FROM sflight AS sf             INNER JOIN sbook AS sb             ON sf~carrid EQ sb~carrid             INTO TABLE @gt_final             GROUP BY sf~carrid             ORDER BY sf~carrid. IF sy-subrc EQ 0.   LOOP AT gt_final ASSIGNING FIELD-SYMBOL(<fs>).     WRITE:/ <fs>-carrid. "<fs>-connid,<fs>-carrid.   ENDLOOP. ENDIF.
Read more