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

Unit 1 Data Types

Image
11.   Advantage of User defined types:  Maintain definition centrally Local types available within the program Global types available within the system 12. Data Objects Text symbol is used to show messages. Adv of Text Symbol, translation can be maintained.   13. Data Formats Internal and External Format of Data Output Length of Data Types 15 Structure To define a type we can refer to a data object/data type or a database table definition in se11 . TYPES: BEGIN OF ty_makt, ...., END OF ty_makt. There are three types of ABAP structures:  Flat structures: Components are made of individual fields that refer to elementary types.  Nested structures :If at least one component of a structure refers to another structure, it’s a nested structure.  Deep structures:  References at least one table type (a type that defines an internal table). 16 Internal Table: Can store 2 GB of data, Basis would generally restrict it to 500 MB.  Standard Table Sorted Ta...
Read more