topic Re: ABAP statement in Application Development and Automation Discussions

ABAP statement

Former Member — Tue, 22 May 2007 23:32:16 GMT

I didnt giev exact requirement.

my requirement

is REGUH table has fields

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

a_{zaldt a}znme1 a~rwbtr

a_{waers a}zbnkl a~rzawe

PAYR has fields

b_{chect b}checf b~gjahr

common fiels is vblnr

reguh can have 10 records and payr will have 10 or less then that.

for example 5.

but i want to extract all the 10 records.

from reguh but additional field check frok payr to be filled in for 5 records.

remaining 5 fields can be empty.

could you help me out

jeff

Re: ABAP statement

Former Member — Tue, 22 May 2007 23:35:27 GMT

Hi jeff,

Just change the query given by Seshu as below.

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 <b>LEFT OUTER JOIN</b> payr as b on b_{vblnr = a}vblnr.

Reward points if useful.

Regards,

Atish

Message was edited by:

Atish Sarda

Re: ABAP statement

Former Member — Tue, 22 May 2007 23:37:29 GMT

You can use LEFT OUTER JOIN between 2 tables.

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

a_{zaldt a}znme1 a~rwbtr

a_{waers a}zbnkl a_{rzawe b}chect b_{checf b}gjahr

INTO TABLE ITAB

FROM REGUH AS A

LEFT OUTER JOIN PAYR AS B

ON A_{VBLNR = B}VBLNR.

WHERE....

Re: ABAP statement

former_member214288 — Wed, 23 May 2007 00:02:38 GMT

Hi Jeff,

Resulting set for outer join

The outer join basically creates the same resulting set as the inner join, with the difference that at least one line is created in the resulting set for every selected line on the left-hand side, even if no line on the right-hand side fulfils the join_cond condition. The columns on the right-hand side that do not fulfil the join_cond condition are filled with null values.

Your query should be something like this.

SELECT a~zbukr a~hbkid a~hktid a~vblnr
       a~zaldt a~znme1 a~rwbtr
       a~waers a~zbnkl a~rzawe  
       b~chect b~checf b~gjahr
from REGUH as a 
LEFT OUTER JOIN PAYR as b on a~vblnr = b~vblnr
 AND a~XXXXX = restriction field

Do let me know if I can be further help on this and reward points if helpful.

Regards,

Ram