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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\Herkunft_KST.imr
TITLE,Herkunft_KST.imr
BEGIN SQL
select T1."EBENE11" as c1,
	   T1."KOSTENSTELLE" as c2,
	   T1."KOSTENSTELLE_BEZEICHNUNG" as c3,
	   T1."EBENE13" as c4,
	   T1."EBENE14" as c5,
	   T1."EBENE15" as c6,
	   T1."EBENE16" as c7,
	   T1."EBENE17" as c8,
	   T1."EBENE18" as c9,
	   T1."EBENE19" as c10,
	   T1."EBENE20" as c11,
	   (od_left(T1."KOSTENSTELLE",2)) as c12
from "Herkunft_KST.csv" T1
where (((od_left(T1."KOSTENSTELLE",2))) BETWEEN '00' AND '99')

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