topic Re: select distinct fields into itab in Application Development and Automation Discussions

select distinct fields into itab

Former Member — Tue, 07 Oct 2008 13:36:33 GMT

Is it possible to create a select distinct statement for a structure where only one field should be distinct.

example:


data: ta_vbrk type standard table of vbrk. 

select vbeln vkorg vtweg (distinct kunag)
  into corresponding fields of ta_vbrk
  where auart = 'xxxx'
     and vtweg = 'yy'

My goal is to fill out the four fields ta_vbrk record but only for the kunag once.

I hope that's clear. It's hard to state when you don't know how to do it

Re: select distinct fields into itab

rainer_hbenthal — Tue, 07 Oct 2008 13:42:59 GMT

If you have

A B E

F G E

X Y E

M N F

How should the result look like having only column3 as a distinct value?

? ? E

? ? F

Re: select distinct fields into itab

Former Member — Tue, 07 Oct 2008 13:55:57 GMT

Hi Rainer,

Thanks for replying.

In your example, I would want

A B E

M N F

Re: select distinct fields into itab

Former Member — Tue, 07 Oct 2008 13:56:29 GMT

Hi Rainer,

Thanks for replying.

In your example, I would want

A B E

M N F

Re: select distinct fields into itab

rainer_hbenthal — Tue, 07 Oct 2008 14:00:32 GMT

Select all rows and then do a delete duplicates on column3 afterwards. There is no such functionality in SQL. Do not forget to sort the internal table before deleting the duplictaes.

Re: select distinct fields into itab

Former Member — Tue, 07 Oct 2008 14:10:21 GMT

Yup. That's what I did. I was just hoping to minimize the traffic across the network. But, I guess it's not possible.