Problem with controla break statement

[Former Member]

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..

[SuhaSaha]

Did you sort your internal table baed on KUNNR ?

[Former Member]

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

.

[anup_deshmukh4]

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.