C11/System/WERWISO/IQD/Zeit/Reaubuch_Rechnungsdatum_ben_Zeit.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\zeit\Reaubuch_Rechnungsdatum_ben_Zeit.imr
TITLE,Reaubuch_Rechnungsdatum_ben_Zeit.imr
BEGIN SQL
select c1 as c1,
	   c2 as c2,
	   c3 as c3,
	   c4 as c4,
	   c5 as c5
from 
(select c13 as c1,
	   c12 as c2,
	   c11 as c3,
	   c10 as c4,
	   c9 as c5,
	   XMAX(c12 for c9) as c6
from 
(select T2."SplitNr" as c9,
	   T1."Vorgangsnummer" as c10,
	   T1."Rechnungsdatum" as c11,
	   T1."Rechnungsnummer" as c12,
	   T1."Filial_ID" as c13
from ("\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."VORGANG" T2 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."REAUBUCH" T1 on (T2."Filial_ID" = T1."Filial_ID") and (T2."Vorgangsnummer" = T1."Vorgangsnummer"))
where (T1."Rechnungsnummer" IS NOT NULL)
) D2
) D1
where (c2 = c6)
order by c5 asc

END SQL
COLUMN,0,Filial Id
COLUMN,1,Rechnungsnummer
COLUMN,2,Rechnungsdatum
COLUMN,3,Vorgangsnummer
COLUMN,4,Splitnr