Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Control break statements

Former Member

‎2008 Jan 24 3:44 PM

0 Likes
360

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

2 REPLIES 2
Read only

Former Member

‎2008 Jan 24 3:46 PM

0 Likes
340

YOu can have alook at the Demo program: DEMO_EXTRACT_AT_NEW

Regards,

Ravi

Read only

former_member249594
Participant

‎2008 Jan 24 3:50 PM

0 Likes
340

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