problem in left join

[srahemi]

Hi guys,

i got this error when use left join

"Not all ON clauses contain a condition that compares a field from the right table with a field from the left table. "

Where did I go wrong ?

My Code:

  SELECT
    VBAK~ZEFF_DATE_M VBAK~KUNNR VBAK~BSTDK VBAK~VBELN AS VBELN1 VBAK~BSTNK VBAK~VKGRP
    VBFA~VBELN AS VBELN2
    VBRP~MATNR VBRP~KZWI1 VBRP~KZWI6 VBRP~NETWR VBRP~MWSBP VBRP~WERKS
    MARA~MATKL
    VBRK~FKDAT
    MAKT~MAKTX
    VBAP~KWMENG
    ZSD_ORDER_PL~LIST_NO
    FROM VBAK
    INNER JOIN VBFA ON VBFA~VBELV = VBFA~VBELN
    INNER JOIN VBRP ON VBRP~VBELN = VBFA~VBELN
                   AND VBRP~POSNR = VBFA~POSNN
    INNER JOIN MARA ON MARA~MATNR = VBRP~MATNR
    INNER JOIN VBRK ON VBRK~VBELN = VBRP~VBELN
    INNER JOIN MAKT ON MAKT~MATNR = MARA~MATNR
                   AND MAKT~SPRAS = 'E'
    INNER JOIN VBAP ON VBAP~VBELV = VBFA~VBELN
                   AND VBAP~POSNR = VBFA~POSNV
    INNER JOIN ZSD_ORDER_PL ON ZSD_ORDER_PL~BSTNK = VBAK~BSTNK
                           AND ZSD_ORDER_PL~MATNR = VBRP~MATNR
    LEFT JOIN MVKE ON MVKE~MATNR = MARA~MATNR
                  AND MVKE~VKORG = '1110'
                  AND MVKE~VTWEG = '10'
    INTO TABLE IT1
    WHERE VBAK~BSTZD = '80'
    .

[abo]

INNER JOIN VBFA ON VBFA~VBELV = VBFA~VBELN

[srahemi]

Thanks 🙂