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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz.imr
TITLE,Umsatz_Einsatz
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,
	   T1."Ebene1" as c7,
	   T1."Ebene2" as c8,
	   T1."Ebene3" as c9,
	   T1."Ebene4" as c10,
	   T1."Ebene5" as c11,
	   T1."Ebene6" as c12,
	   T1."Jahr" as c13,
	   T1."Mandant" as c14,
	   T1."Kürzel" as c15,
	   T1."KST" as c16,
	   T1."Marke" as c17,
	   T1."Plan" as c18,
	   T1."Stück" as c19,
	   T1."Plan" / 12 as c20,
	   T1."Plan" / 12 as c21,
	   T1."Plan" / 12 as c22,
	   T1."Plan" / 12 as c23,
	   T1."Plan" / 12 as c24,
	   T1."Plan" / 12 as c25,
	   T1."Plan" / 12 as c26,
	   T1."Plan" / 12 as c27,
	   T1."Plan" / 12 as c28,
	   T1."Plan" / 12 as c29,
	   T1."Plan" / 12 as c30,
	   T1."Plan" / 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
from "Imp_UE_EW_komplett" T1
where (T1."Art" <> 'Summenzeile')

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
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
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
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