C11/System/ARI/IQD/Plan/Kosten_Planung.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Kalender_2
DATASOURCENAME,C:\GAPS_BMW\Portal\System\IQD\Plan\Kosten_Planung.imr
TITLE,Kosten_Planung.imr
BEGIN SQL
select T1."Zeile" as c1,
	   T1."Bezeichnung" as c2,
	   T1."Einheiten" as c3,
	   T1."Erlöse EUR" as c4,
	   T1."VAK  EUR" as c5,
	   T1."DB I  EUR" as c6,
	   T1."DB I %" as c7,
	   T1."Rechtseinheit" as c8,
	   T1."Betrieb" as c9,
	   T1."Kostenstelle" as c10,
	   CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END as c11,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0459) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0537) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0536) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0551) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c12,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0660) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0772) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0771) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0793) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c13,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0979) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0946) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0817) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0857) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c14,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0974) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0981) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0865) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0933) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c15,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0916) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0964) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0855) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0910) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c16,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.1057) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0965) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0909) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0962) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c17,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0900) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0846) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0808) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0837) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c18,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0696) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0847) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0763) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0833) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c19,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0656) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0734) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0770) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0776) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c20,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0916) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0928) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0909) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0868) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c21,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0968) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0860) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.1165) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0940) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c22,
	   CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0819) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0620) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0832) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0740) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END as c23,
	   (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0459) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0537) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0536) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0551) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0660) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0772) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0771) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0793) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0979) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0946) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0817) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0857) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0974) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0981) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0865) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0933) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0916) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0964) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0855) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0910) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.1057) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0965) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0909) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0962) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0900) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0846) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0808) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0837) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0696) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0847) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0763) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0833) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0656) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0734) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0770) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0776) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0916) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0928) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0909) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0868) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0968) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0860) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.1165) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0940) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) + (CASE WHEN ((T1."Kostenstelle" = '1') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0819) WHEN ((T1."Kostenstelle" = '2') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0620) WHEN ((T1."Kostenstelle" = '3') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0832) WHEN ((T1."Kostenstelle" = '4') and (T2."Ebene1" = 'Verkaufsabh. Kosten')) THEN ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) * 0.0740) ELSE ((CASE WHEN (T2."Ebene1" <> 'Finanz-/A.O. Ergebnis') THEN ((cast_float(T1."DB I  EUR")) * -1) ELSE ((cast_float(T1."DB I  EUR"))) END) / 12) END) as c24,
	   2011 as c25,
	   T2."Ebene1" as c26,
	   T2."Ebene2" as c27,
	   T2."Ebene3" as c28,
	   T2."Ebene4" as c29,
	   T2."Ebene5" as c30,
	   '' as c31
from "Planung_gesamt" T1,
	"Struktur_FB" T2
where (T1."Zeile" = (od_left(T2."Ebene2",4)))

END SQL
COLUMN,0,Zeile
COLUMN,1,Bezeichnung
COLUMN,2,Einheiten
COLUMN,3,Erlöse Eur
COLUMN,4,Vak Eur
COLUMN,5,Db I Eur
COLUMN,6,Db I %
COLUMN,7,Rechtseinheit
COLUMN,8,Betrieb
COLUMN,9,Kostenstelle
COLUMN,10,Wert gesamt
COLUMN,11,Wert1
COLUMN,12,Wert2
COLUMN,13,Wert3
COLUMN,14,Wert4
COLUMN,15,Wert5
COLUMN,16,Wert6
COLUMN,17,Wert7
COLUMN,18,Wert8
COLUMN,19,Wert9
COLUMN,20,Wert10
COLUMN,21,Wert11
COLUMN,22,Wert12
COLUMN,23,Kontrolle
COLUMN,24,Bookkeep Date
COLUMN,25,Ebene1
COLUMN,26,Ebene2
COLUMN,27,Ebene3
COLUMN,28,Ebene4
COLUMN,29,Ebene5
COLUMN,30,Ebene12