GAPS/Portal/System/IQD/Belege/GVO_GuV_8_STK_Autonom.iqd

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