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~KO...