Control break statements

Former Member — Thu, 24 Jan 2008 15:44:42 GMT

Hi,

Any one please send me one exxample using control break statments like AT LAST,AT END OF ...etc...

using the SUM in the report...

Thanks & regards,

Shaheen.

Edited by: Alvaro Tejada Galindo on Jan 24, 2008 10:56 AM

Re: Control break statements

Former Member — Thu, 24 Jan 2008 15:46:57 GMT

YOu can have alook at the Demo program: DEMO_EXTRACT_AT_NEW

Regards,

Ravi

Re: Control break statements

former_member249594 — Thu, 24 Jan 2008 15:50:27 GMT

Hi,

Below is example codes for Excel ouptut with control break in the loop. Hope it can help you.


  LOOP AT gt_output INTO gs_output.
    ls_output_ttl = gs_output.
***** Subtotal by Vendor
    AT NEW lifnr.
      CLEAR: ls_output_ttl-seq,
             ls_output_ttl-verkf,
             ls_output_ttl-ebeln.
      SUM.
      ls_output_ttl-dmbtr_in = gs_output-dmbtr_in.
      ls_output_ttl-dmbtr_out = gs_output-dmbtr_out.
      l_new_vendor_indicator = 'X'.
      PERFORM fill_row USING     lo_excel
                                 l_new_vendor_indicator
                                 ls_output_ttl
                                 6
                                 1
                        CHANGING l_row_num
                                 l_col_num.
      l_new_vendor_indicator = ''.
      CLEAR ls_output_ttl.
    ENDAT.

***** subtotal by contract
    ls_output_ttl = gs_output.
    AT NEW verkf.
      CONCATENATE 'By Contracl
                  ls_output_ttl-verkf
                  'Subtotal:'
                  INTO ls_output_ttl-verkf.
      CONDENSE ls_output_ttl-verkf NO-GAPS.
      CLEAR: ls_output_ttl-seq,
             ls_output_ttl-lifnr,
             ls_output_ttl-name1,
             ls_output_ttl-ebeln.
      SUM.
      ls_output_ttl-dmbtr_in = gs_output-dmbtr_in.
      ls_output_ttl-dmbtr_out = gs_output-dmbtr_out.
      PERFORM fill_row USING     lo_excel
                                 l_new_vendor_indicator
                                 ls_output_ttl
                                 36
                                 1
                        CHANGING l_row_num
                                 l_col_num.
      CLEAR ls_output_ttl.
    ENDAT.

    PERFORM fill_row USING     lo_excel
                               l_new_vendor_indicator
                               gs_output
                               ''
                               ''
*                               sy-tabix
                      CHANGING l_row_num
                               l_col_num.
    CLEAR ls_output_ttl.
****** Total
    AT LAST.
      SUM.
      ls_output_ttl-dmbtr_in = gs_output-dmbtr_in.
      ls_output_ttl-dmbtr_out = gs_output-dmbtr_out.
      PERFORM fill_row USING     lo_excel
                                 l_new_vendor_indicator
                                 ls_output_ttl
                                 4
                                 1
                        CHANGING l_ttl_row_num
                                 l_col_num.
    ENDAT.
  ENDLOOP.

Code Formatted by: Alvaro Tejada Galindo on Jan 24, 2008 10:57 AM

topic Re: Control break statements in Application Development and Automation Discussions

Control break statements

Re: Control break statements

Re: Control break statements