C11/System/LOCOSOFT/IQD/Belege/SKR_Herkunft_KST.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51_Struktur
DATASOURCENAME,C:\GAPS_LOCOSOFT\Portal\System\IQD\Belege\SKR_Herkunft_KST.imr
TITLE,SKR_Herkunft_KST.imr
BEGIN SQL
select T1."EBENE11" as c1,
	   T1."EBENE12" as c2,
	   T1."EBENE13" as c3,
	   T1."EBENE14" as c4,
	   T1."EBENE15" as c5,
	   T1."EBENE16" as c6,
	   T1."EBENE17" as c7,
	   T1."EBENE18" as c8,
	   T1."EBENE19" as c9,
	   T1."EBENE20" as c10,
	   CASE WHEN (T1."EBENE12" = '100 - Bilanz') THEN ('100') ELSE ((od_left(T1."EBENE12",2))) END as c11
from "Herkunft_KST.csv" T1
where (((CASE WHEN (T1."EBENE12" = '100 - Bilanz') THEN ('100') ELSE ((od_left(T1."EBENE12",2))) END) BETWEEN '00' AND '99') and ((CASE WHEN (T1."EBENE12" = '100 - Bilanz') THEN ('100') ELSE ((od_left(T1."EBENE12",2))) END) <> '100'))

END SQL
COLUMN,0,Ebene11
COLUMN,1,KST_mit_Bez
COLUMN,2,Ebene13
COLUMN,3,Ebene14
COLUMN,4,Ebene15
COLUMN,5,Ebene16
COLUMN,6,Ebene17
COLUMN,7,Ebene18
COLUMN,8,Ebene19
COLUMN,9,Ebene20
COLUMN,10,KST