topic ABAP query in Application Development and Automation Discussions

ABAP query

Former Member — Tue, 22 May 2007 22:57:06 GMT

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

Re: ABAP query

Former Member — Tue, 22 May 2007 23:02:38 GMT

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.

Re: ABAP query

Former Member — Tue, 22 May 2007 23:15:18 GMT

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

Re: ABAP query

Former Member — Tue, 22 May 2007 23:23:40 GMT

I am getting duplicate entries.

how to avoid it?

Re: ABAP query

Former Member — Wed, 23 May 2007 13:19:37 GMT

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