C11/System/CARLO/IQD/Belege/skr_kostentraeger.sql

select T1."EBENE31" as "Ebene31",
	   T1."EBENE32" as "Ebene32",
	   T1."EBENE33" as "Ebene33",
	   T1."EBENE34" as "Ebene34",
	   T1."EBENE35" as "Ebene35",
	   T1."EBENE36" as "Ebene36",
	   T1."EBENE37" as "Ebene37",
	   T1."EBENE38" as "Ebene38",
	   T1."EBENE39" as "Ebene39",
	   T1."EBENE40" as "Ebene40",
	   (T1."EBENE32") as "Kostenträger_mit_Bez",
	   CASE WHEN (T1."EBENE31" = 'Neuwagen') THEN ((substring(T1."EBENE32", 1, 5))) ELSE ((left(T1."EBENE32",2))) END as "Kostenträger",
	   CASE WHEN (T1."EBENE31" IN ('Neuwagen')) THEN (T1."EBENE32") ELSE null END as "Ebene_Marke"
from "Kostentraeger.csv" T1
where (((T1."EBENE32" <> '100 - Bilanz') and (T1."EBENE31" <> 'Zuordnung')) and (not ((T1."EBENE32")) IN ('00 - Bilanz','00 - NW Fremdmarke')))