Need help on select statement in ABAP

Former Member — Thu, 03 Apr 2008 21:04:42 GMT

Hi,

I have 2 table. in that I need to do join. But 2 fields of table A that I need to join with the 2 fields in table B.

But problem is that both the fields of table A can be NULL(either of them).

i.c.

Table A Table B

KONDA KUNNR PRICESHEET KONDA KUNNR

KA NULL A KA 1000

KA NULL B KA 1001

DZ NULL C DZ 1002

NULL 1000 D DZ 1003

NULL 1001 E DZ 1004

NULL 1002 F

NULL 1003 F

NULL 1004 G

After Joining I need for KONDA = 'KA'

KONDA KUNNR PRICESHEET

KA NULL A

KA NULL B

NULL 1000 D

NULL 1001 E

Could you plz help me...Plz reply soon. Thanks in advance

Regards

Anutosh

Re: Need help on select statement in ABAP

Former Member — Thu, 03 Apr 2008 21:47:39 GMT


select a~konda a~kunnr a~pricesheet  from table_a as a
join table_b as b on ( a~konda = b~konda or a~konda eq space ) and (a~kunnr = b~kunnr or a~kunnr eq space )
where b~konda = 'KA'.

Try that

Edited by: Ramiro Escamilla on Apr 3, 2008 11:48 PM

topic Re: Need help on select statement in ABAP in Application Development and Automation Discussions

Need help on select statement in ABAP

Re: Need help on select statement in ABAP