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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\SKR_Konten_Bilanz.imr
TITLE,SKR_Konten_Bilanz.imr
BEGIN SQL
select T1."EBENE1" as c1,
	   T1."EBENE2" as c2,
	   T1."EBENE3" as c3,
	   T1."EBENE4" as c4,
	   T1."EBENE5" as c5,
	   T1."EBENE6" as c6,
	   T1."EBENE7" as c7,
	   T1."EBENE8" as c8,
	   T1."EBENE9" as c9,
	   T1."EBENE10" as c10,
	   (substring((CASE WHEN ((od_left(T1."EBENE2",1)) BETWEEN '0' AND '9') THEN (T1."EBENE2") WHEN ((od_left(T1."EBENE3",1)) BETWEEN '0' AND '9') THEN (T1."EBENE3") WHEN ((od_left(T1."EBENE4",1)) BETWEEN '0' AND '9') THEN (T1."EBENE4") WHEN ((od_left(T1."EBENE5",1)) BETWEEN '0' AND '9') THEN (T1."EBENE5") WHEN ((od_left(T1."EBENE6",1)) BETWEEN '0' AND '9') THEN (T1."EBENE6") ELSE null END) from 1 for 4)) as c11,
	   (substring((CASE WHEN ((od_left(T1."EBENE2",1)) BETWEEN '0' AND '9') THEN (T1."EBENE2") WHEN ((od_left(T1."EBENE3",1)) BETWEEN '0' AND '9') THEN (T1."EBENE3") WHEN ((od_left(T1."EBENE4",1)) BETWEEN '0' AND '9') THEN (T1."EBENE4") WHEN ((od_left(T1."EBENE5",1)) BETWEEN '0' AND '9') THEN (T1."EBENE5") WHEN ((od_left(T1."EBENE6",1)) BETWEEN '0' AND '9') THEN (T1."EBENE6") ELSE null END) from 8 for 250)) as c12,
	   CASE WHEN ((od_left(T1."EBENE2",1)) BETWEEN '0' AND '9') THEN (T1."EBENE2") WHEN ((od_left(T1."EBENE3",1)) BETWEEN '0' AND '9') THEN (T1."EBENE3") WHEN ((od_left(T1."EBENE4",1)) BETWEEN '0' AND '9') THEN (T1."EBENE4") WHEN ((od_left(T1."EBENE5",1)) BETWEEN '0' AND '9') THEN (T1."EBENE5") WHEN ((od_left(T1."EBENE6",1)) BETWEEN '0' AND '9') THEN (T1."EBENE6") ELSE null END as c13,
	   CASE WHEN (T1."EBENE1" IN ('Einkommens- und Gewerbesteuer','Einsatzwerte','Kontenklasse 5 Internes','Kosten','Neutrales Ergebnis','Umsatzerlöse')) THEN ('0') ELSE ('1') END as c14,
	   (substring(((substring((CASE WHEN ((od_left(T1."EBENE2",1)) BETWEEN '0' AND '9') THEN (T1."EBENE2") WHEN ((od_left(T1."EBENE3",1)) BETWEEN '0' AND '9') THEN (T1."EBENE3") WHEN ((od_left(T1."EBENE4",1)) BETWEEN '0' AND '9') THEN (T1."EBENE4") WHEN ((od_left(T1."EBENE5",1)) BETWEEN '0' AND '9') THEN (T1."EBENE5") WHEN ((od_left(T1."EBENE6",1)) BETWEEN '0' AND '9') THEN (T1."EBENE6") ELSE null END) from 1 for 4))) from 1 for 1)) as c15,
	   'Bilanzkonten' as c16
from "SKR51.csv" T1
where ((not T1."EBENE1" IN ('Einkommens- und Gewerbesteuer','Einsatzwerte','Kosten','Neutrales Ergebnis','Umsatzerlöse')) and (((substring((CASE WHEN ((od_left(T1."EBENE2",1)) BETWEEN '0' AND '9') THEN (T1."EBENE2") WHEN ((od_left(T1."EBENE3",1)) BETWEEN '0' AND '9') THEN (T1."EBENE3") WHEN ((od_left(T1."EBENE4",1)) BETWEEN '0' AND '9') THEN (T1."EBENE4") WHEN ((od_left(T1."EBENE5",1)) BETWEEN '0' AND '9') THEN (T1."EBENE5") WHEN ((od_left(T1."EBENE6",1)) BETWEEN '0' AND '9') THEN (T1."EBENE6") ELSE null END) from 1 for 4))) IS NOT NULL))

END SQL
COLUMN,0,Ebene1_ori
COLUMN,1,Ebene2
COLUMN,2,Ebene3
COLUMN,3,Ebene4
COLUMN,4,Ebene5
COLUMN,5,Ebene6
COLUMN,6,Ebene7
COLUMN,7,Ebene8
COLUMN,8,Ebene9
COLUMN,9,Ebene10
COLUMN,10,Acct Nr
COLUMN,11,Konto Bezeichnung
COLUMN,12,Konto
COLUMN,13,GuV_Bilanz
COLUMN,14,Susa
COLUMN,15,Ebene1