topic Re: Problem with controla break statement in Application Development and Automation Discussions

Problem with controla break statement

Former Member — Thu, 29 Apr 2010 04:42:11 GMT

This is the structure of my internal table

TYPES:BEGIN OF ty_detailgrp,
  kunnr TYPE bsid-kunnr, "customer number
  bukrs TYPE bsid-bukrs, "company code
  zterm TYPE dzterm,
  name1 TYPE name1,
  dmbe2 TYPE bsid-dmbe2,
* waers TYPE bsid-waers, 
  30daysg TYPE bsid-dmbtr,                                   " 30 Days,
  60daysg TYPE bsid-dmbtr,                                    " 60 Days,
  90daysg TYPE bsid-dmbtr,                                    " 90 Days,
  120daysg TYPE bsid-dmbtr,                                   "120 Days,
  150daysg TYPE bsid-dmbtr,                                   "150 Days,
  total TYPE bsid-dmbtr,
END OF ty_detailgrp.

LOOP AT gt_detailgrp INTO gs_detailgrp.
      AT END OF kunnr.
        SUM.

        APPEND gs_detailgrp TO gt_detailgrp2.
        CLEAR:gs_detailgrp.
      ENDAT.
ENDLOOP.

My Problem is AT END OF KUNNR triggers every time when bukrs changes for the same kunnr.this happens when there are multiple kunnr in the internal table.

if i run for particular kunnr which is distributed over multiple companies,it triggers once and i am getting total of all rows.

I am confused .help plz..

Re: Problem with controla break statement

SuhaSaha — Thu, 29 Apr 2010 04:48:28 GMT

Did you sort your internal table baed on KUNNR ?

Re: Problem with controla break statement

Former Member — Thu, 29 Apr 2010 04:51:51 GMT

TYPES:BEGIN OF ty_detailgrp,
  kunnr TYPE bsid-kunnr, "customer number
  bukrs TYPE bsid-bukrs, "company code
  zterm TYPE dzterm,
  name1 TYPE name1,
  dmbe2 TYPE bsid-dmbe2,
* waers TYPE bsid-waers, 
  30daysg TYPE bsid-dmbtr,                                   " 30 Days,
  60daysg TYPE bsid-dmbtr,                                    " 60 Days,
  90daysg TYPE bsid-dmbtr,                                    " 90 Days,
  120daysg TYPE bsid-dmbtr,                                   "120 Days,
  150daysg TYPE bsid-dmbtr,                                   "150 Days,
  total TYPE bsid-dmbtr,
END OF ty_detailgrp.
 sort kunnr ascending.     "<--------------
LOOP AT gt_detailgrp INTO gs_detailgrp.
      AT END OF kunnr.
        SUM.
 
        APPEND gs_detailgrp TO gt_detailgrp2.
        CLEAR:gs_detailgrp.
      ENDAT.
ENDLOOP

Re: Problem with controla break statement

anup_deshmukh4 — Thu, 29 Apr 2010 05:02:54 GMT

Hello raghunandan mj ,

The prerequisite of using the control break statement is that you need to sort the internal table by the sequence of field as they are in the structre ie. sort itab field1 field2 ...(For all fields )so on...!

Please Refer to F1 help for more details.

Hope it helps.