C11/System/NAVISION/IQD/Belege/SKR51/SKR_Kostenträger.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51_Struktur
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\SKR_Kostenträger.imr
TITLE,SKR_Kostenträger.imr
BEGIN SQL
select T1."EBENE31" as c1,
	   T1."KOSTENTRÄGER" as c2,
	   T1."EBENE33" as c3,
	   T1."EBENE34" as c4,
	   T1."EBENE35" as c5,
	   T1."EBENE36" as c6,
	   T1."EBENE37" as c7,
	   T1."EBENE38" as c8,
	   T1."EBENE39" as c9,
	   T1."EBENE40" as c10,
	   CASE WHEN ((CASE WHEN (T1."EBENE31" IN ('Neuwagen')) THEN (T1."KOSTENTRÄGER") ELSE null END) IS NOT NULL) THEN (T1."EBENE33") ELSE (T1."KOSTENTRÄGER") END as c11,
	   ((od_left(T1."KOSTENTRÄGER",2))) as c12,
	   CASE WHEN (T1."EBENE31" IN ('Neuwagen')) THEN (T1."KOSTENTRÄGER") ELSE null END as c13
from "Kostentraeger.csv" T1
where (((T1."KOSTENTRÄGER" <> '100 - Bilanz') and (T1."EBENE31" <> 'Zuordnung')) and (not (CASE WHEN ((CASE WHEN (T1."EBENE31" IN ('Neuwagen')) THEN (T1."KOSTENTRÄGER") ELSE null END) IS NOT NULL) THEN (T1."EBENE33") ELSE (T1."KOSTENTRÄGER") END) IN ('00 - Bilanz','00 - NW Fremdmarke')))

END SQL
COLUMN,0,Ebene31
COLUMN,1,Ebene32
COLUMN,2,Ebene33
COLUMN,3,Ebene34
COLUMN,4,Ebene35
COLUMN,5,Ebene36
COLUMN,6,Ebene37
COLUMN,7,Ebene38
COLUMN,8,Ebene39
COLUMN,9,Ebene40
COLUMN,10,Kostenträger_mit_Bez
COLUMN,11,Kostenträger
COLUMN,12,Ebene_Marke