Comments

Post a Comment

Popular posts from this blog

Enhcnaced SQL

Image
  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 , ...
Read more

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