problem in left join

srahemi — Mon, 05 Sep 2022 06:17:20 GMT

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'
    .

Re: problem in left join

abo — Mon, 05 Sep 2022 06:22:05 GMT

INNER JOIN VBFA ON VBFA~VBELV = VBFA~VBELN

Re: problem in left join

srahemi — Mon, 05 Sep 2022 06:30:11 GMT

Thanks 🙂

topic Re: problem in left join in Application Development and Automation Discussions

problem in left join

Re: problem in left join

Re: problem in left join