GAPS/Portal/System/IQD/Belege/Dept.Typ.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\Dept.Typ.imr
TITLE,Dept.Typ.imr
BEGIN SQL
select T1."DEPARTMENT_TYPE_ID" as c1,
	   T1."DESCRIPTION" as c2,
	   T1."DEPARTMENT_GROUP" as c3,
	   (database()) as c4
from "deop01"."dbo"."DEPARTMENT_TYPE" T1

END SQL
COLUMN,0,Department Type Id
COLUMN,1,Description
COLUMN,2,Department Group
COLUMN,3,Mandant