topic Re: need unique record in Application Development and Automation Discussions

need unique record

Former Member — Sat, 14 Apr 2007 09:59:06 GMT

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.

Former Member — Sat, 14 Apr 2007 10:04:22 GMT

Hi el,

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

former_member632991 — Sat, 14 Apr 2007 10:06:28 GMT

Hi,

after select

sort it_vbap by vbeln posnr.

delete adjacent duplicate from it_vbap comparing vbeln posnr.

Regards,

Sonika