COGNOS QUERY STRUCTURE,1,1 DATABASE,GVO_Fibu_Beleg DATASOURCENAME,D:\GAPS\Portal\System\IQD\Belege\GVO_GuV_8_STK_Autonom.imr TITLE,GVO_GuV_8_STK_Autonom.imr BEGIN SQL select T1."Betrieb" as c1, T1."Hauptbetrieb" as c2, T1."Rechtseinheit" as c3, T1."Feld1" as c4, T1."Feld2" as c5, T1."Feld3" as c6, T1."Feld4" as c7, T1."Feld5" as c8, T1."Feld6" as c9, T1."Feld7" as c10, T1."Feld8" as c11, T1."Feld9" as c12, T1."Feld10" as c13, T1."Feld11" as c14, T1."Feld12" as c15, T1."Feld13" as c16, T1."Feld14" as c17, T1."Feld15" as c18, T1."Feld16" as c19, T1."Feld17" as c20, T1."Kto" as c21, T1."Name" as c22, T1."Verdichtung 1" as c23, T1."Verdichtung 2" as c24, T1."Verdichtung 3" as c25, T1."Verdichtung 4" as c26, T1."Verdichtung 5" as c27, T1."Verdichtung 6" as c28, T1."Verdichtung 7" as c29, T1."Verdichtung 8" as c30, 'verkaufte Stückzahlen' as c31, T1."Verdichtung 10" as c32, T1."Verdichtung 11" as c33, T1."Verdichtung 12" as c34, T1."Verdichtung 13" as c35, T1."Verdichtung 14" as c36, CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END as c37, 'G.V.O.' as c38, CASE WHEN (T1."Name" IS NOT NULL) THEN (T1."Kto" || ' - ' || T1."Name") ELSE (T1."Kto") END as c39, CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END as c40, (od_left(T1."Feld6",2)) || '.' || (substring(T1."Feld6" from 3 for 2)) || '.' || (od_right(T1."Feld6",2)) as c41, CASE WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" < -600000)) THEN (-1) WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" > 600000)) THEN (1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" < 0)) THEN (-1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" > 0)) THEN (1) ELSE null END as c42, CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese','Neutraler Ertrag')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END as c43, CASE WHEN (T1."Verdichtung 10" = 'VE Neuwagen') THEN ('Neuwagen') WHEN (T1."Verdichtung 10" = 'VE Gebrauchtwagen') THEN ('Gebrauchtwagen') ELSE null END as c44, CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese','Neutraler Ertrag')) THEN ((CASE WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" < -600000)) THEN (-1) WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" > 600000)) THEN (1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" < 0)) THEN (-1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" > 0)) THEN (1) ELSE null END) * -1) ELSE ((CASE WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" < -600000)) THEN (-1) WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" > 600000)) THEN (1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" < 0)) THEN (-1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" > 0)) THEN (1) ELSE null END)) END as c45, 'verkaufte Stückzahlen' as c46, (CASE WHEN (T1."Verdichtung 10" = 'VE Neuwagen') THEN ('Neuwagen') WHEN (T1."Verdichtung 10" = 'VE Gebrauchtwagen') THEN ('Gebrauchtwagen') ELSE null END) as c47, 'Autonom' as c48, '' as c49, '' as c50, '' as c51, T1."Feld5" || ' - ' || ((od_left(T1."Feld6",2)) || '.' || (substring(T1."Feld6" from 3 for 2)) || '.' || (od_right(T1."Feld6",2))) as c52, CASE WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Mainzer Landstrasse') THEN ('01') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Nordwest-Stadt') THEN ('02') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Eschborn') THEN ('03') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Hanauer Landstrasse') THEN ('04') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Offenbach') THEN ('05') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Neu-Isenburg') THEN ('06') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Enkheim') THEN ('08') WHEN ((CASE WHEN (T1."Betrieb" IS NULL) THEN ('POS Mainzer Landstrasse') ELSE (T1."Betrieb") END) = 'POS Nürnberger Strasse') THEN ('09') ELSE null END as c53, CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END as c54, CASE WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '3') THEN ('6') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '4') THEN ('3') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '5') THEN ('4') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '6') THEN ('5') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '8') THEN ('9') ELSE ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END)) END as c55, ((od_left(T1."Feld6",2)) || '.' || (substring(T1."Feld6" from 3 for 2)) || '.' || (od_right(T1."Feld6",2))) as c56, '' as c57, (CASE WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '3') THEN ('6') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '4') THEN ('3') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '5') THEN ('4') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '6') THEN ('5') WHEN ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END) = '8') THEN ('9') ELSE ((CASE WHEN (T1."Feld1" BETWEEN '2000' AND '2999') THEN ('0') ELSE ((substring((CASE WHEN (T1."Verdichtung 2" IN ('EW Neuwagen','VE Neuwagen')) THEN ('1 - Neuwagen') WHEN (T1."Verdichtung 2" IN ('EW Gebrauchtwagen','VE Gebrauchtwagen')) THEN ('2 - Gebrauchtwagen') WHEN (T1."Verdichtung 2" IN ('EW Teile & Zubehoer','VE Teile & Zubehoer')) THEN ('3 - Teile und Zubehoer') WHEN (T1."Verdichtung 3" IN ('EW Mechanik/Elektrik','VE Mechanik/Elektrik','EW Fremdleistungen','EW Sonstiges KD','VE Fremdleistungen','VE Sonstiges KD','VE Sonstiges Kundendienst','EW Sonstiges Kundendienst')) THEN ('4 - Mechanik') WHEN (T1."Verdichtung 3" IN ('EW Karosserie','VE Karosserie')) THEN ('5 - Karosserie') WHEN (T1."Verdichtung 3" IN ('EW Lackiererei','VE Lackiererei')) THEN ('6 - Lack') WHEN (T1."Verdichtung 2" IN ('EW Opel Rent','VE Opel Rent')) THEN ('7 - Sonstige') ELSE null END) from 1 for 1))) END)) END) as c58, (CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese','Neutraler Ertrag')) THEN ((CASE WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" < -600000)) THEN (-1) WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" > 600000)) THEN (1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" < 0)) THEN (-1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" > 0)) THEN (1) ELSE null END) * -1) ELSE ((CASE WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" < -600000)) THEN (-1) WHEN (((T1."Feld1" BETWEEN '8020' AND '8165') or (T1."Feld1" BETWEEN '8180' AND '8196')) and (T1."Feld9" > 600000)) THEN (1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" < 0)) THEN (-1) WHEN ((((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) and (T1."Feld9" > 0)) THEN (1) ELSE null END)) END) as c59 from "s089900_8" T1 where (T1."Verdichtung 10" IN ('VE Gebrauchtwagen','VE Neuwagen')) order by c52 asc,c11 asc,c8 asc END SQL COLUMN,0,Betrieb_ori COLUMN,1,Hauptbetrieb COLUMN,2,Rechtseinheit_ori COLUMN,3,Konto Nr COLUMN,4,Betrieb Nr COLUMN,5,Bezeichnung COLUMN,6,Feld4 COLUMN,7,Belegnr COLUMN,8,Feld6 COLUMN,9,Beleg COLUMN,10,B-text COLUMN,11,Summe_ori COLUMN,12,1-nw COLUMN,13,2-gw COLUMN,14,3-tz COLUMN,15,4-mech COLUMN,16,5-kaross COLUMN,17,6-lack COLUMN,18,7-sonst COLUMN,19,Feld17 COLUMN,20,Kto_ori COLUMN,21,Name COLUMN,22,Verdichtung 1 COLUMN,23,Verdichtung 2 COLUMN,24,Verdichtung 3 COLUMN,25,Verdichtung 4 COLUMN,26,Verdichtung 5 COLUMN,27,Verdichtung 6 COLUMN,28,Verdichtung 7 COLUMN,29,Verdichtung 8 COLUMN,30,Verdichtung 9 COLUMN,31,Verdichtung 10_ori COLUMN,32,Verdichtung 11 COLUMN,33,Verdichtung 12 COLUMN,34,Verdichtung 13 COLUMN,35,Verdichtung 14 COLUMN,36,Betrieb_alt COLUMN,37,Rechtseinheit COLUMN,38,Kto COLUMN,39,Kostenstelle_alt COLUMN,40,Datum COLUMN,41,Menge_ori COLUMN,42,Summe_alt COLUMN,43,Verdichtung 10 COLUMN,44,Summe COLUMN,45,Ebene1 COLUMN,46,Ebene2 COLUMN,47,Ebene3 COLUMN,48,Ebene4 COLUMN,49,Ebene5 COLUMN,50,Konto COLUMN,51,Acct Nr COLUMN,52,Betrieb COLUMN,53,KST_1 COLUMN,54,KST_2 COLUMN,55,Bookkeep Date COLUMN,56,Marke COLUMN,57,Kostenstelle COLUMN,58,Betrag