topic Re: create a select using something like sql group by in Application Development and Automation Discussions

create a select using something like sql group by

Former Member — Tue, 07 Apr 2009 07:29:30 GMT

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

Re: create a select using something like sql group by

Former Member — Tue, 07 Apr 2009 08:07:23 GMT

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.

Re: create a select using something like sql group by

Former Member — Tue, 07 Apr 2009 09:15:38 GMT

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

Re: create a select using something like sql group by

Former Member — Tue, 07 Apr 2009 12:30:14 GMT

Hi ,

try this.

select vbeln from vbrp INTO TABLE it_vbrp

group by vbeln.