abap statement

Former Member — Fri, 08 Jun 2007 01:54:10 GMT

hi i have to write a statement in abap.

where i need to extract data from REGUH and PAYR table comparing company code, housebank and few more conditions.

even if there are no records in PAYR we have to extract the records from REGUH.

PAYR entries will be empty then.

that means if there are 10 records in REGUH and 5 records in PAYR.

all 5 records in payr have key field in REGUH.

10 entries should be extracted. 5 wiht combination of REGUh and PAYR other 5 wihtout cmbination.

this is the query i wrote pls check it.

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

a_{zaldt a}znme1 a_{rwbtr a}ubhkt

a_{waers a}zbnkl a~rzawe

b_{chect b}checf b~gjahr

INTO CORRESPONDING FIELDS OF TABLE itreguh

FROM reguh AS a

LEFT OUTER JOIN payr AS b

ON a_{vblnr = b}vblnr

AND a_{zbukr = b}zbukr

AND a_{hbkid = b}hbkid

AND a_{hktid = b}hktid

WHERE a~zbukr = cmp_code

AND a~hbkid = hse_bank

AND a~hktid = acc_id

AND a~vblnr <> space.

DELETE ADJACENT DUPLICATES FROM itreguh COMPARING chect.

Re: abap statement

Former Member — Fri, 08 Jun 2007 05:36:09 GMT

hi jeff,

instead of <b>inner join</b> u can use <b>for all enries</b> here,

ex:

select * from REGUH into <itab> where bukrs in s_bukrs.

if not <itab> is initial.

select * from PAYR into <itab1> for all entries in <itab> where bukrs = <itab>-bukrs and other coditions.

endif.

then in loop u can move all these field into global <itab> and disply.

reward points if helpful,

regards,

seshu.