topic Re: Delete duplicates from query output in Application Development and Automation Discussions

Delete duplicates from query output

andrea_brusarestelletti — Mon, 24 Jan 2011 12:45:33 GMT

Hello,

I would like to delete duplicated records before the output of a SAP query

I tried writing in SQ02 in additional coding, under "Free coding":

data %dtab type standard table of /1BCDWB/IQ000000001053 with header line.

sort %dtab by vbeln posnr.

DELETE ADJACENT DUPLICATES FROM %dtab.

In this way I get the short dump when running the query: "Statement is not accessible.".

If I declare %dtab in the additional coding under "DATA", when I run the query I get the error "%DTAB" has already been declared.".

If I don't declare %dtab, I can't generate the infoset.

Do you have any suggestion about the way of obtaining this result?

Thanks in advance for your support.

Best regards,

Andrea

Re: Delete duplicates from query output

Rushikesh_Yeole — Thu, 31 Mar 2011 05:26:36 GMT

did you get any solution on this? i am also facing the same..

please reply me

Re: Delete duplicates from query output

andrea_brusarestelletti — Fri, 01 Apr 2011 07:07:22 GMT

Hello,

I didn't find any solution to this problem. I choosed another way: I asked an ABAPer to develop a report to get the same information I wanted to get with the query, as in the ABAP report there's more "space to move".

Best regards,

Andrea

Re: Delete duplicates from query output

former_member659396 — Sun, 10 Apr 2011 11:48:25 GMT

Hi,

Did you get the solution, I am also facing the same issue.

What could be the way forward for this, If i get the solution i will let you know u you would have already got the solution please let me know,

Regards

Rohan

Re: Delete duplicates from query output

andrea_brusarestelletti — Tue, 12 Apr 2011 08:13:41 GMT

Hello,

sorry: I didn't find a solution. To be fair, I'm not looking for it anymore. But if I'll discover something, I'll let you know.

Best regards,

Andrea