Form Based Process
https://help.sap.com/doc/9d07e72b92284b2984cb92b4ff5e7d8a/3.6/en-US/3799b23d3d5f4499854ae21da4d93838.html
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.
Comments
Post a Comment