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

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

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