Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report - INNER JOIN Problem

Hi,

In my report List of Block Customer's, INNER JOIN is not working..

Code:----

**************************************************************

SELECT DISTINCT M1KUNNR M1KTOKD M1NAME1 M1CASSD M1AUFSD M1LIFSD M1~FAKSD INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM KNA1 AS M1 INNER JOIN KNVV AS M2 ON M1KUNNR = M2KUNNR

WHERE M1~KTOKD IN ('0001' , 'KTOKD')

AND M1~CASSD EQ 'X'

OR M1~AUFSD NE ''

OR M1~LIFSD NE ''

OR M1~FAKSD NE ''

OR (M2~AUFSD NE ''

OR M2~LIFSD NE ''

OR M2~FAKSD NE ''

OR M2~CASSD EQ 'X'.

**************************************************************

Here, condition on 0001 is not matching..

Plz tell me, what is the problem in it..

Thanks

Edited by: Prince Kumar on Oct 20, 2008 9:37 AM

Tags:
Not what you were looking for? View more on this topic or Ask a question