C11/System/AUTOLINE/IQD/Belege/Kontenrahmen_Service_Erfolgsrechnung.sql

select T1."KONTO_NR" as "Konto Nr",
	   T1."KONTO_BEZEICHNUNG" as "Konto Bezeichnung",
	   T1."KONTO_ART" as "Konto Art",
	   T1."KOSTENSTELLE" as "Kostenstelle",
	   T1."STK" as "Stk",
	   T1."KONTO_1" as "Konto 1",
	   T1."KONTO_2" as "Konto 2",
	   T1."KONTO_3" as "Konto 3",
	   T1."KONTO_4" as "Konto 4",
	   T1."KONTO_5" as "Konto 5",
	   T1."EBENE1" as "Ebene1",
	   T1."EBENE2" as "Ebene2",
	   T1."EBENE3" as "Ebene3",
	   T1."EBENE4" as "Ebene4",
	   T1."EBENE5" as "Ebene5",
	   T1."EBENE6" as "Ebene6",
	   T1."EBENE7" as "Ebene7",
	   T1."EBENE8" as "Ebene8",
	   T1."EBENE9" as "Ebene9",
	   T1."EBENE10" as "Ebene10",
	   T1."EBENE11" as "Ebene11",
	   T1."EBENE12" as "Ebene12",
	   T1."EBENE13" as "Ebene13",
	   T1."EBENE14" as "Ebene14",
	   T1."EBENE15" as "Ebene15",
	   T1."EBENE16" as "Ebene16",
	   T1."EBENE17" as "Ebene17",
	   T1."EBENE18" as "Ebene18",
	   T1."EBENE19" as "Ebene19",
	   T1."EBENE20" as "Ebene20",
	   T1."EBENE21" as "Ebene21",
	   T1."EBENE22" as "Ebene22",
	   T1."EBENE23" as "Ebene23",
	   T1."EBENE24" as "Ebene24",
	   T1."EBENE25" as "Ebene25",
	   T1."EBENE26" as "Ebene26",
	   T1."EBENE27" as "Ebene27",
	   T1."EBENE28" as "Ebene28",
	   T1."EBENE29" as "Ebene29",
	   T1."EBENE30" as "Ebene30"
from "Kontenrahmen.csv" T1
where ((T1."EBENE1" IN ('Ersatzteilhandel','Werkstatt')) and (T1."KONTO_1" IN ('Umsatzerlöse','Einsatzwerte')))