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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\SKR_Konten.imr
TITLE,SKR_Konten.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
from "SKR51.csv" T1
where (T1."EBENE1" IN ('Einkommens- und Gewerbesteuer','Einsatzwerte','Kosten','Neutrales Ergebnis','Umsatzerlöse'))

END SQL
COLUMN,0,Ebene1
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