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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\SKR_Absatzkanal.imr
TITLE,SKR_Absatzkanal.imr
BEGIN SQL
select T1."EBENE21" as c1,
	   T1."ABSATZKANAL" as c2,
	   T1."ABSATZKANAL_BEZEICHNUNG" as c3,
	   T1."EBENE23" as c4,
	   T1."EBENE24" as c5,
	   T1."EBENE25" as c6,
	   T1."EBENE26" as c7,
	   T1."EBENE27" as c8,
	   T1."EBENE28" as c9,
	   T1."EBENE29" as c10,
	   T1."EBENE30" as c11,
	   (od_left(T1."ABSATZKANAL",2)) as c12
from "Absatzkanal.csv" T1
where (((od_left(T1."ABSATZKANAL",2))) BETWEEN '00' AND '99')

END SQL
COLUMN,0,Ebene21
COLUMN,1,Absatzkanal
COLUMN,2,Absatzkanal Bezeichnung
COLUMN,3,Ebene23
COLUMN,4,Ebene24
COLUMN,5,Ebene25
COLUMN,6,Ebene26
COLUMN,7,Ebene27
COLUMN,8,Ebene28
COLUMN,9,Ebene29
COLUMN,10,Ebene30
COLUMN,11,Absatzkanal_Code