topic Delete adjacent duplicates in Application Development and Automation Discussions

Delete adjacent duplicates

former_member263707 — Thu, 02 Apr 2015 21:48:47 GMT

Writing a query using tables VBRK & VBRP. Require VBRP-VGBEL in the query. VBRP-VGBEL is always the same on all line items. I just want the report to show 1 line. I have tried different coding but still get multiple lines. I think my issues is I need some coding around the VBRP-POSNR.

Not sure what I am missing. If VBRK-VBELN eq VBRP-VBELN then return one line.

Data: ls_vbrp like standard table of vbrp with header line.

Select VBELN into corresponding fields of table ls_vbrp from vbrp

where vbeln eq vbrk-vbeln.

sort ls_vbrp by vbeln descending.

delete adjacent duplicates from ls_vbrp comparing vbeln.

I've tried including vgbel and only using vgbel. I've tried up to 1 rows. I have tried adding VBRP-VGBEL as an additional field instead of using the table and the field appears blank.

Any assistance would be greatly appreciated.

Pamela

Re: Delete adjacent duplicates

ThangaPrakash — Fri, 10 Apr 2015 10:57:21 GMT

Hello Pamela,

Use SELECT SINGLE as below and try.

SELECT SINGLE vbeln FROM vbrp INTO CORRESPONDING FIELDS OF TABLE ls_vbrp WHERE vbeln EQ vbrk-vbeln.

Regards,

Re: Delete adjacent duplicates

guilherme_frisoni — Fri, 10 Apr 2015 12:56:32 GMT

Hi Pamela,

your code is correct, when using DELETE DUPLICATES you will get only one of each VBELN records.

The code your are testing is the same you pasted here?

Regards,

Frisoni