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.
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...
Comments
Post a Comment