create a select using something like sql group by

[Former Member]

hi

i tried but with no succsess to creat a select query which will give me all the pernr that have more than 1 id number.

can someone help me ?

thanks ami

[Former Member]

take this example for group by

*data : BEGIN OF it_vbrp OCCURS 0,
*       vbeln like vbrp-vbeln,
*       netwr like  vbrp-netwr,
*   END OF it_vbrp.
*
* data : wa_vbrp like it_vbrp.
*
*       select vbeln max( netwr ) from vbrp INTO TABLE it_vbrp
*         where netwr > 0.
*         group by vbeln.
*
*         Loop at It_vbrp INTO wa_vbrp.
*           endloop.

[Former Member]

Hi Ami,

Check this links,

[Link1|https://www.sdn.sap.com/irj/scn/forumsearch]

[Link2|]

[Link3|]

[Link4|]

In all above links, it has your required the modification codes.

Thanks & regards,

Dileep .C

[Former Member]

Hi ,

try this.

select vbeln from vbrp INTO TABLE it_vbrp

group by vbeln.