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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GVO_Fibu_Beleg
DATASOURCENAME,D:\GAPS\Portal\System\IQD\Belege\GVO_GuV_8_Autonom.imr
TITLE,GVO_GuV_8_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,
	   T1."Verdichtung 9" 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%')) THEN ('-1') WHEN (((T1."Feld1" BETWEEN '8210' AND '8212') and (T1."Feld7" LIKE '5%')) and (T1."Feld8" LIKE 'Auslage%')) THEN ('1') ELSE null END as c42,
	   CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END as c43,
	   CASE WHEN (T1."Verdichtung 1" = 'Umsatzerloese') THEN ((CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END)) ELSE (0) END as c44,
	   CASE WHEN (T1."Verdichtung 1" = 'Einsatzwerte') THEN ((CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END)) ELSE (0) END as c45,
	   (CASE WHEN (T1."Verdichtung 1" = 'Umsatzerloese') THEN ((CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END)) ELSE (0) END) - (CASE WHEN (T1."Verdichtung 1" = 'Einsatzwerte') THEN ((CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END)) ELSE (0) END) as c46,
	   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 c47,
	   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 c48,
	   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 c49,
	   T1."Feld1" as c50,
	   ((od_left(T1."Feld6",2)) || '.' || (substring(T1."Feld6" from 3 for 2)) || '.' || (od_right(T1."Feld6",2))) as c51,
	   '' as c52,
	   (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 c53,
	   (CASE WHEN (T1."Verdichtung 1" IN ('Umsatzerloese')) THEN (T1."Feld9" * -1) ELSE (T1."Feld9") END) as c54
from "s089900_8" T1

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
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
COLUMN,42,Summe
COLUMN,43,UE Ist
COLUMN,44,EW Ist
COLUMN,45,DB 1 Ist
COLUMN,46,Betrieb
COLUMN,47,KST_1
COLUMN,48,KST_2
COLUMN,49,Acct Nr
COLUMN,50,Bookkeep Date
COLUMN,51,Marke
COLUMN,52,Kostenstelle
COLUMN,53,Betrag