Application Development and Automation 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: 
Read only

need unique record

Former Member
0 Likes
432

hi,

if it_tab not unique (vbeln and posnr in it_tab have duplicate), may i know internal table it_vbap will store as unique if using for all entries?

if it_vbap not unique, how can i make it unique after the select statement.

thanks

SELECT vbeln posnr vkorg vtweg spart vbtyp into TABLE it_vbap

FROM vbap

FOR ALL ENTRIES IN it_tab

WHERE vbeln = it_tab-vgbel AND

posnr = it_tab-posnr.

1 ACCEPTED SOLUTION
Read only

former_member632991
Active Contributor
0 Likes
407

Hi,

after select

sort it_vbap by vbeln posnr.

delete adjacent duplicate from it_vbap comparing vbeln posnr.

Regards,

Sonika

2 REPLIES 2
Read only

Former Member
0 Likes
407

Hi el,

U wont get if u r using for all entries as this is the limitation on for all entries

Read only

former_member632991
Active Contributor
0 Likes
408

Hi,

after select

sort it_vbap by vbeln posnr.

delete adjacent duplicate from it_vbap comparing vbeln posnr.

Regards,

Sonika