topic Re: abap statement in Application Development and Automation Discussions

abap statement

Former Member — Fri, 08 Jun 2007 01:57:21 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 02:02:07 GMT

Hi Jeff,

The query seems right.

What is the issue?

Regards,

Atish

Message was edited by:

Atish Sarda

Re: abap statement

Former Member — Fri, 08 Jun 2007 02:04:52 GMT

if there are no records in payr we are unable to extract the reguh details

Re: abap statement

Former Member — Fri, 08 Jun 2007 02:15:33 GMT

Hi Jeff,

No it should not happen. The query is perfectly write.

Can you please recheck if there are entries in REGUH for the criteria you are giving.

Also for checking what you can do is just write a query on reguh and see if it is giving the output or not.

something like this

SELECT zbukr hbkid hktid vblnr

zaldt znme1 rwbtr ubhkt

waers zbnkl rzawe

INTO CORRESPONDING FIELDS OF TABLE itreguh

FROM reguh

WHERE zbukr = cmp_code

AND hbkid = hse_bank

AND hktid = acc_id

AND vblnr <> space.

See if it is giving the output or not.

Regards,

Atish

Re: abap statement

Former Member — Fri, 08 Jun 2007 02:22:11 GMT

Maybe put a break-point before:

DELETE ADJACENT DUPLICATES FROM itreguh COMPARING chect

and check what's in the internal table - you should really sort itreguh by chect prior to doing the delete adjacent duplicates.

Also, if there is no PAYR, then your CHECT will be blank and all these will get removed, bar one row, by the delete.

Message was edited by:

Jonathan Coleman