Skip to Content
0
Jul 01, 2021 at 11:48 AM

no fields from the right-hand table of a LEFT OUTER JOIN may appear in the where condition

348 Views

Hi,

no fields from the right-hand table of a LEFT OUTER JOIN may appear in the where condition: "b~kunde".

Can someone help me to find a solution?

SELECT  a~equnr a~matnr a~sernr
          a~kunde b~kunde
    FROM  equi AS a LEFT OUTER JOIN
          v_equi_eqbs_sml AS b
      ON  a~equnr EQ b~equnr
    INTO TABLE lt_equiview
    WHERE a~equnr IN s_equnr8
      AND a~matnr IN s_matnr8
      AND a~sernr IN s_sernr8
      AND a~kunde IN s_ekunde
      AND b~kunde IN s_vkunde
      AND b~kunnr IN s_kunnr8.