SAP ABAP

 https://help.sap.com/doc/9d07e72b92284b2984cb92b4ff5e7d8a/3.6/en-US/3799b23d3d5f4499854ae21da4d93838.html

 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.

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

  Case Statement "disbable returns which are have active audit case, @field selectable, and pre select eligible returns @a_chkbox    CONSTANTS :  lc_check       TYPE  boolean  VALUE  abap_true,                  lc_uncheck     TYPE  boolean  VALUE  abap_false,                                                lc_open        TYPE  fbsta_ps  VALUE  'IP014',                  lc_no_case     TYPE  fbsta_ps    VALUE  IS  INITIAL .    SELECT  taxpayer  AS  a_tp_tin , ...

 Internal tables store data in rows and columns To Read data from internal table we need a work area. An internal table can be read by index or key.   

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...