Skip to Content
0
Former Member
Oct 15, 2009 at 07:27 AM

info set query

150 Views

Hello everybody,

I have a problem with the creation of info set (tcode : sq00 and sq02)

I need your help, i have to develop a query with a number Purchase Order and number of invoice.

For example : for a number of invoice : 5105617263

i have with TOAD (soft) this :

select distinct ekko.ebeln, rseg.belnr

from sapsr3.ekko, sapsr3.rseg

where ekko.ebeln = rseg.ebeln

and rseg.belnr = '5105617263'

and ekko.mandt = '350'

EBELN BELNR

4500013374 5105617263

4500014267 5105617263

I've tried to have the same result with an info set (sq02) and i have this :

Purchase Order Invoice

4500013374 5105617263

4500013374 5105617263

4500013374 5105617263

4500014267 5105617263

4500014267 5105617263

4500014267 5105617263

4500014267 5105617263

I dont know to develop in ABAP and i want to know if it's possible to have DISTINCT in an info set ?

Or which table can i use to have this ?

Thank you very much