Skip to Content
0
May 21, 2015 at 06:34 AM

No fields from the right-hand table of a left outer join ...where condition : "ZPP_T004~CRDAT"

283 Views

Hi friends,

I couldn't use left outer join both where clause. I need filtering so where clause using 'IN'. IF I use 'IN' , I get an error title.

I have examined the question asked earlier but not solving.

How to use left outer join together with 'IN' clause.

Thanks for your advise.


SELECT DISTINCT ZPP_T004~CRDAT AS CRDAT_1 ENAME ZPP_T004~CRUZT AS CRUZT_1 ARBPL ZPP_T004~MATNR MAKTX ZTBARKOD BARKOD ZTELCAP1 ZTELCAP

ZMUKAVEMET ZBURMA ZHIZ LOW HIGH ZPARTI ZSABUN ZDRESAJ ZACIKLAMA

ZPP_T004~AUFNR KANTAR KADET SEPET BRAGR NTAGR TEYIT ZQM_T001~CRDAT ZQM_T001~CRUZT

INTO CORRESPONDING FIELDS OF TABLE gt_tablo UP TO SAYI ROWS FROM ZQM_T001

LEFT OUTER JOIN ZPP_T004 ON ZQM_T001~ZTBARKOD = ZPP_T004~CHARG

JOIN MAKT ON ZPP_T004~MATNR = MAKT~MATNR

JOIN AUFK ON ZPP_T004~AUFNR = AUFK~AUFNR

JOIN PA0001 ON ZPP_T004~PERNR = PA0001~PERNR

JOIN ZPP_T001 ON ZPP_T001~MKVNO = AUFK~MKVNO

where ZTBARKOD IN TBARKOD AND ZPP_T004~CRDAT IN KKTARIH