C11/System/ARI/IQD/Service/Auftraege_mit_FL.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Service\Auftraege_mit_FL.imr
TITLE,Auftraege_mit_FL.imr
BEGIN SQL
select distinct T1."Service Order No_" as c1,
	   CASE WHEN (T2."Gen_ Prod_ Posting Group" IN ('821_SONST','823_SONST','828_SONST','822_SONST','824_SONST','825_SONST','826_SONST','827_SONST','829_SONST')) THEN ('mit Fremdl.') ELSE ('ohne Fremdl.') END as c2
from "Gottstein7x"."dbo"."AH Gottstein$Sales Invoice Header" T1,
	"Gottstein7x"."dbo"."AH Gottstein$Sales Invoice Line" T2
where (T1."No_" = T2."Document No_")
and (((T1."Service Order No_" <> '') and (T1."Service Order No_" LIKE 'WAU%')) and ((CASE WHEN (T2."Gen_ Prod_ Posting Group" IN ('821_SONST','823_SONST','828_SONST','822_SONST','824_SONST','825_SONST','826_SONST','827_SONST','829_SONST')) THEN ('mit Fremdl.') ELSE ('ohne Fremdl.') END) = 'mit Fremdl.'))
order by c1 asc

END SQL
COLUMN,0,Service Order No
COLUMN,1,Fremdl_ja_nein