SELECT Z~BUKRS,
Z~BUDAT,
Z~BLDAT,
Z~HWAER AS WAERS,
Z~XBLNR,
Z~BLART,
Z~BELNR,
A~BUZEI,
A~MWSKZ,
A~SHKZG,
B~HKONT,
B~KOART,
E~MWART,
F~TEXT1,
CASE WHEN E~MWART EQ 'A' AND B~KOART EQ 'D'
THEN COALESCE( B~KUNNR , B~LIFNR )
WHEN E~MWART EQ 'V' AND B~KOART EQ 'K'
THEN COALESCE( B~LIFNR , B~KUNNR )
END AS PARTNER, <=
........
LEFT JOIN BUT020 AS H
ON PARTNER = H~PARTNER <=
ALIAS 'PARTNER' WHICH I ANNOUNCED CANT BE USED AS JOIN CONDITION WITH BUT020-PARTNER??
The program is activated well, but that join condion is not working in the end.
When using CASE in SQL Select, the alias cant be used in Table Join condition????