GAPS/Portal/System/IQD/Belege/Komplett/Umsatz_Einsatz_STK.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz_STK.imr
TITLE,Umsatz_Einsatz_STK
BEGIN SQL
select T1."Art" as c1,
	   T1."Acct Nr_ori" as c2,
	   T1."Ledger Accts Name" as c3,
	   T1."Marke_1" as c4,
	   T1."Modell" as c5,
	   T1."Abnehmergruppe" as c6,
	   'verkaufte Stückzahlen' as c7,
	   T1."Ebene2" as c8,
	   '' as c9,
	   '' as c10,
	   '' as c11,
	   '' as c12,
	   T1."Jahr" as c13,
	   T1."Mandant" as c14,
	   T1."Kürzel" as c15,
	   T1."KST" as c16,
	   T1."Marke" as c17,
	   T1."Stück" as c18,
	   T1."Stück" as c19,
	   T1."Stück" / 12 as c20,
	   T1."Stück" / 12 as c21,
	   T1."Stück" / 12 as c22,
	   T1."Stück" / 12 as c23,
	   T1."Stück" / 12 as c24,
	   T1."Stück" / 12 as c25,
	   T1."Stück" / 12 as c26,
	   T1."Stück" / 12 as c27,
	   T1."Stück" / 12 as c28,
	   T1."Stück" / 12 as c29,
	   T1."Stück" / 12 as c30,
	   T1."Stück" / 12 as c31,
	   T1."Stück" / 12 as c32,
	   T1."Stück" / 12 as c33,
	   T1."Stück" / 12 as c34,
	   T1."Stück" / 12 as c35,
	   T1."Stück" / 12 as c36,
	   T1."Stück" / 12 as c37,
	   T1."Stück" / 12 as c38,
	   T1."Stück" / 12 as c39,
	   T1."Stück" / 12 as c40,
	   T1."Stück" / 12 as c41,
	   T1."Stück" / 12 as c42,
	   T1."Stück" / 12 as c43,
	   CASE WHEN (T1."Ebene2" = 'VE Neuwagen') THEN ('Neuwagen') WHEN (T1."Ebene2" = 'VE Gebrauchtwagen') THEN ('Gebrauchtwagen') ELSE null END as c44
from "Imp_UE_EW_komplett" T1
where ((T1."Art" <> 'Summenzeile') and (T1."Stück" <> 0))

END SQL
COLUMN,0,Art
COLUMN,1,Acct Nr Ori
COLUMN,2,Ledger Accts Name
COLUMN,3,Marke 1
COLUMN,4,Modell
COLUMN,5,Abnehmergruppe
COLUMN,6,Ebene1
COLUMN,7,Ebene2_ori
COLUMN,8,Ebene3
COLUMN,9,Ebene4
COLUMN,10,Ebene5
COLUMN,11,Ebene6
COLUMN,12,Jahr
COLUMN,13,Mandant
COLUMN,14,Kürzel
COLUMN,15,Kst
COLUMN,16,Marke
COLUMN,17,Plan
COLUMN,18,Stück_ori
COLUMN,19,Wert1
COLUMN,20,Wert2
COLUMN,21,Wert3
COLUMN,22,Wert4
COLUMN,23,Wert5
COLUMN,24,Wert6
COLUMN,25,Wert7
COLUMN,26,Wert8
COLUMN,27,Wert9
COLUMN,28,Wert10
COLUMN,29,Wert11
COLUMN,30,Wert12
COLUMN,31,Stk1_ori
COLUMN,32,Stk2
COLUMN,33,Stk3
COLUMN,34,Stk4
COLUMN,35,Stk5
COLUMN,36,Stk6
COLUMN,37,Stk7
COLUMN,38,Stk8
COLUMN,39,Stk9
COLUMN,40,Stk10
COLUMN,41,Stk11
COLUMN,42,Stk12
COLUMN,43,Ebene2