COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\serv_teile\Service_offene_Vorgaenge_ims.imr
TITLE,Service_offene_Vorgaenge_ims.imr
BEGIN SQL
select T1."Vorgangsart" as c1,
	   T1."Vorgangsnummer" as c2,
	   T1."SplitNr" as c3
from "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."VORGANG" T1
where ((T1."Status" IN ('Arbeitskarte   ','Lieferschein   ','S-Lieferschein ','Vorgang        ')) and ((T1."Vorgangsart" IN ('Barverkauf          ','Garantie            ','Service             ','Interne Rechnun')) or (T1."Vorgangsart" = 'Verkauf        ')))
order by c3 asc

END SQL
COLUMN,0,Vorgangsart_Vorgang
COLUMN,1,Vorgangsnummer
COLUMN,2,Splitnr_Vorgang