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