ABAP query

[Former Member]

Hi,

I need to extract data from two tables REGUH and PAYR common key is vblnr.

fields are zbukr hbkid hktid vblnr from REGUH and CHECT from PAYR,

could anyone help me to write the sql statement

Jeff

[Former Member]

tables : REGUH,

PAYR .

data : begin of itab occurs 0,

zbukr like reguh-zbukr,

hbkid like reguh-hbkid,

hktid like reguh-hktid,

vblnr like reguh-vblnr,

CHECT like payr-CHECT,

end of itab.

start-of-selection.

select a_{zbukr a}hbkid a_{hktid a}vblnr

b~chect into table itab

from reguh as a inner join payr as b on b_{vblnr = a}vblnr.

[Former Member]

I am getting duplicate entries.

how to avoid it?

[Former Member]

Jeff, you are getting duplicates because the field chect is not key in table reguh.

You can: DELETE ADJACENT DUPLICATES FROM i_reguh comparing chect.

But verify if functionally is ok that yoy delete whose records and you are not losing information. Otherwise you should use and inner join comparing both tables by vblnr or ZBUKR or put more conditions in the where clause like ZBUKR = i_reguh-zbukr.

Regards,

Roxana

[Former Member]

Hi Jeff,

Maybe you can do:

select zbukr

hbkid

vblnr

from reguh

into i_reguh.

select chect

from payr

for all entries in i_reguh

where chect = i_reguh-chect.

It will be more performant if you put some condition in the where clause of reguh selection.

Regards,

Roxana