Application Development 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
Showing results for 
Search instead for 
Did you mean: 

create a select using something like sql group by

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Hi ,

try this.

select vbeln from vbrp INTO TABLE it_vbrp

group by vbeln.