C11/System/OPTIMA/IQD/Belege/GuV_8_O21_SKR_Umsatz_Belege.sql

SELECT (
		CASE 
			WHEN (
					(T1."MAKE" IS NULL)
					OR ((rtrim(T1."MAKE")) = '')
					)
				THEN ('00')
			ELSE ((rtrim(T1."MAKE")))
			END
		) + '-' + (
		CASE 
			WHEN (
					(((rtrim(T2."ACCT_NR"))) LIKE '2%')
					AND (T1."SITE" IS NULL)
					)
				THEN ('01')
			ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
			END
		) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
		CASE 
			WHEN (
					(T1."DEPARTMENT" IS NULL)
					OR ((rtrim(T1."DEPARTMENT")) = '')
					)
				THEN ('00')
			ELSE ((rtrim(T1."DEPARTMENT")))
			END
		) + '-' + (
		CASE 
			WHEN (
					(T1."DESTINATION" IS NULL)
					OR ((rtrim(T1."DESTINATION")) = '')
					)
				THEN ('00')
			ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
			END
		) + '-' + (
		(
			rtrim(CASE 
					WHEN (
							(T3."MODEL_LINE" IS NOT NULL)
							AND (T3."MODEL_LINE" <> '')
							)
						THEN (T3."MODEL_LINE")
					WHEN (
							(T1."PRODUCT_GROUP" IS NOT NULL)
							AND (T1."PRODUCT_GROUP" <> '')
							)
						THEN (T1."PRODUCT_GROUP")
					WHEN (
							(T1."REPAIR_GROUP" IS NOT NULL)
							AND (T1."REPAIR_GROUP" <> '')
							)
						THEN (T1."REPAIR_GROUP")
					ELSE ('00')
					END)
			)
		) AS "Acct Nr",
	T2."LEDGER_ACCTS_NAME" AS "Ledger Accts Name",
	T2."LEDGER_ACCTS_NAME2" AS "Ledger Accts Name2",
	T1."BOOKKEEP_DATE" AS "Bookkeep Date",
	'1' AS "Rechtseinheit",
	CASE 
		WHEN (
				(
					(
						(
							CASE 
								WHEN (
										(T1."MAKE" IS NULL)
										OR ((rtrim(T1."MAKE")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."MAKE")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(((rtrim(T2."ACCT_NR"))) LIKE '2%')
										AND (T1."SITE" IS NULL)
										)
									THEN ('01')
								ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
								END
							) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
							CASE 
								WHEN (
										(T1."DEPARTMENT" IS NULL)
										OR ((rtrim(T1."DEPARTMENT")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."DEPARTMENT")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(T1."DESTINATION" IS NULL)
										OR ((rtrim(T1."DESTINATION")) = '')
										)
									THEN ('00')
								ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
								END
							) + '-' + (
							(
								rtrim(CASE 
										WHEN (
												(T3."MODEL_LINE" IS NOT NULL)
												AND (T3."MODEL_LINE" <> '')
												)
											THEN (T3."MODEL_LINE")
										WHEN (
												(T1."PRODUCT_GROUP" IS NOT NULL)
												AND (T1."PRODUCT_GROUP" <> '')
												)
											THEN (T1."PRODUCT_GROUP")
										WHEN (
												(T1."REPAIR_GROUP" IS NOT NULL)
												AND (T1."REPAIR_GROUP" <> '')
												)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00')
										END)
								)
							)
						) LIKE '2%'
					)
				AND (T1."SITE" IS NULL)
				)
			THEN ('01')
		ELSE ((left(T1."SITE", 2)))
		END AS "Betrieb",
	CASE 
		WHEN (
				(T1."MAKE" IS NULL)
				OR (
					(T1."MAKE" = '  ')
					AND (
						NOT (
							(
								CASE 
									WHEN (
											(T1."MAKE" IS NULL)
											OR ((rtrim(T1."MAKE")) = '')
											)
										THEN ('00')
									ELSE ((rtrim(T1."MAKE")))
									END
								) + '-' + (
								CASE 
									WHEN (
											(((rtrim(T2."ACCT_NR"))) LIKE '2%')
											AND (T1."SITE" IS NULL)
											)
										THEN ('01')
									ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
									END
								) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
								CASE 
									WHEN (
											(T1."DEPARTMENT" IS NULL)
											OR ((rtrim(T1."DEPARTMENT")) = '')
											)
										THEN ('00')
									ELSE ((rtrim(T1."DEPARTMENT")))
									END
								) + '-' + (
								CASE 
									WHEN (
											(T1."DESTINATION" IS NULL)
											OR ((rtrim(T1."DESTINATION")) = '')
											)
										THEN ('00')
									ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
									END
								) + '-' + (
								(
									rtrim(CASE 
											WHEN (
													(T3."MODEL_LINE" IS NOT NULL)
													AND (T3."MODEL_LINE" <> '')
													)
												THEN (T3."MODEL_LINE")
											WHEN (
													(T1."PRODUCT_GROUP" IS NOT NULL)
													AND (T1."PRODUCT_GROUP" <> '')
													)
												THEN (T1."PRODUCT_GROUP")
											WHEN (
													(T1."REPAIR_GROUP" IS NOT NULL)
													AND (T1."REPAIR_GROUP" <> '')
													)
												THEN (T1."REPAIR_GROUP")
											ELSE ('00')
											END)
									)
								)
							) LIKE '4%'
						)
					)
				)
			THEN ('00')
		WHEN (
				(T1."MAKE" IN ('OP'))
				AND (
					NOT (
						(
							CASE 
								WHEN (
										(T1."MAKE" IS NULL)
										OR ((rtrim(T1."MAKE")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."MAKE")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(((rtrim(T2."ACCT_NR"))) LIKE '2%')
										AND (T1."SITE" IS NULL)
										)
									THEN ('01')
								ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
								END
							) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
							CASE 
								WHEN (
										(T1."DEPARTMENT" IS NULL)
										OR ((rtrim(T1."DEPARTMENT")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."DEPARTMENT")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(T1."DESTINATION" IS NULL)
										OR ((rtrim(T1."DESTINATION")) = '')
										)
									THEN ('00')
								ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
								END
							) + '-' + (
							(
								rtrim(CASE 
										WHEN (
												(T3."MODEL_LINE" IS NOT NULL)
												AND (T3."MODEL_LINE" <> '')
												)
											THEN (T3."MODEL_LINE")
										WHEN (
												(T1."PRODUCT_GROUP" IS NOT NULL)
												AND (T1."PRODUCT_GROUP" <> '')
												)
											THEN (T1."PRODUCT_GROUP")
										WHEN (
												(T1."REPAIR_GROUP" IS NOT NULL)
												AND (T1."REPAIR_GROUP" <> '')
												)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00')
										END)
								)
							)
						) LIKE '4%'
					)
				)
			THEN (T1."MAKE")
		WHEN (
				(
					(
						CASE 
							WHEN (
									(T1."MAKE" IS NULL)
									OR ((rtrim(T1."MAKE")) = '')
									)
								THEN ('00')
							ELSE ((rtrim(T1."MAKE")))
							END
						) + '-' + (
						CASE 
							WHEN (
									(((rtrim(T2."ACCT_NR"))) LIKE '2%')
									AND (T1."SITE" IS NULL)
									)
								THEN ('01')
							ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
							END
						) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
						CASE 
							WHEN (
									(T1."DEPARTMENT" IS NULL)
									OR ((rtrim(T1."DEPARTMENT")) = '')
									)
								THEN ('00')
							ELSE ((rtrim(T1."DEPARTMENT")))
							END
						) + '-' + (
						CASE 
							WHEN (
									(T1."DESTINATION" IS NULL)
									OR ((rtrim(T1."DESTINATION")) = '')
									)
								THEN ('00')
							ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
							END
						) + '-' + (
						(
							rtrim(CASE 
									WHEN (
											(T3."MODEL_LINE" IS NOT NULL)
											AND (T3."MODEL_LINE" <> '')
											)
										THEN (T3."MODEL_LINE")
									WHEN (
											(T1."PRODUCT_GROUP" IS NOT NULL)
											AND (T1."PRODUCT_GROUP" <> '')
											)
										THEN (T1."PRODUCT_GROUP")
									WHEN (
											(T1."REPAIR_GROUP" IS NOT NULL)
											AND (T1."REPAIR_GROUP" <> '')
											)
										THEN (T1."REPAIR_GROUP")
									ELSE ('00')
									END)
							)
						)
					) LIKE '4%'
				)
			THEN (
					(
						CASE 
							WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
								THEN ('OP')
							ELSE ('00')
							END
						)
					)
		ELSE ('99')
		END AS "Marke",
	T1."DEBIT_AMOUNT" + T1."CREDIT_AMOUNT" AS "Betrag",
	T1."SITE" AS "Site",
	CASE 
		WHEN (T1."DEPARTMENT" = '    ')
			THEN ('00')
		ELSE (T1."DEPARTMENT")
		END AS "KST",
	T3."MODEL_LINE" AS "Model Line_vpp5q",
	T3."MOD_LIN_SPECIFY" AS "Mod Lin Specify_vpp5q",
	CASE 
		WHEN (T3."MODEL_LINE" IS NOT NULL)
			THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
		WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
			THEN (T1."PRODUCT_GROUP")
		WHEN (T1."REPAIR_GROUP" IS NOT NULL)
			THEN (T1."REPAIR_GROUP")
		ELSE ('00 - ohne')
		END AS "Kostentr�ger_mit_Bez_",
	(
		substring((
				CASE 
					WHEN (T3."MODEL_LINE" IS NOT NULL)
						THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
					WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
						THEN (T1."PRODUCT_GROUP")
					WHEN (T1."REPAIR_GROUP" IS NOT NULL)
						THEN (T1."REPAIR_GROUP")
					ELSE ('00 - ohne')
					END
				), 1, 2)
		) AS "Kostentr�ger",
	T4."CUSTOMER_NUMBER" AS "Customer Number",
	T5."CUSTOMER_GROUP" AS "Customer Group",
	CASE 
		WHEN (T1."DESTINATION" IS NULL)
			THEN ('00')
		ELSE (T1."DESTINATION")
		END AS "Absatzkanal",
	T2."TYPE_ACCTT" AS "GuV_Bilanz",
	(left(T1."ACCT_NO", 1)) AS "Susa",
	CASE 
		WHEN (
				(
					(
						substring((
								CASE 
									WHEN (T1."DEPARTMENT" = '    ')
										THEN ('00')
									ELSE (T1."DEPARTMENT")
									END
								), 1, 1)
						) = '1'
					)
				AND (
					NOT (
						(
							substring((
									CASE 
										WHEN (T3."MODEL_LINE" IS NOT NULL)
											THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
										WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
											THEN (T1."PRODUCT_GROUP")
										WHEN (T1."REPAIR_GROUP" IS NOT NULL)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00 - ohne')
										END
									), 1, 2)
							)
						) IN ('00')
					)
				)
			THEN ('Neuwagen')
		WHEN (
				(
					(
						substring((
								CASE 
									WHEN (T1."DEPARTMENT" = '    ')
										THEN ('00')
									ELSE (T1."DEPARTMENT")
									END
								), 1, 1)
						) = '2'
					)
				AND (
					NOT (
						(
							substring((
									CASE 
										WHEN (T3."MODEL_LINE" IS NOT NULL)
											THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
										WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
											THEN (T1."PRODUCT_GROUP")
										WHEN (T1."REPAIR_GROUP" IS NOT NULL)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00 - ohne')
										END
									), 1, 2)
							)
						) IN ('00')
					)
				)
			THEN ('Gebrauchtwagen')
		WHEN (
				(
					(
						substring((
								CASE 
									WHEN (T1."DEPARTMENT" = '    ')
										THEN ('00')
									ELSE (T1."DEPARTMENT")
									END
								), 1, 1)
						) = '3'
					)
				AND (
					NOT (
						(
							substring((
									CASE 
										WHEN (T3."MODEL_LINE" IS NOT NULL)
											THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
										WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
											THEN (T1."PRODUCT_GROUP")
										WHEN (T1."REPAIR_GROUP" IS NOT NULL)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00 - ohne')
										END
									), 1, 2)
							)
						) IN ('00')
					)
				)
			THEN ('Teile & Zubeh�r')
		WHEN (
				(
					(
						substring((
								CASE 
									WHEN (T1."DEPARTMENT" = '    ')
										THEN ('00')
									ELSE (T1."DEPARTMENT")
									END
								), 1, 1)
						) = '4'
					)
				AND (
					NOT (
						(
							substring((
									CASE 
										WHEN (T3."MODEL_LINE" IS NOT NULL)
											THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
										WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
											THEN (T1."PRODUCT_GROUP")
										WHEN (T1."REPAIR_GROUP" IS NOT NULL)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00 - ohne')
										END
									), 1, 2)
							)
						) IN ('00')
					)
				)
			THEN ('Service')
		ELSE ('Ohne Kostentr�ger')
		END AS "Ebene31",
	CASE 
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('OP')
				)
			THEN ('OP')
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('VW')
				)
			THEN ('VW')
		ELSE NULL
		END AS "Marke f�r Kostentr�ger",
	CASE 
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('OP')
				)
			THEN (
					(
						CASE 
							WHEN (
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR (
														(T1."MAKE" = '  ')
														AND (
															NOT (
																(
																	CASE 
																		WHEN (
																				(T1."MAKE" IS NULL)
																				OR ((rtrim(T1."MAKE")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."MAKE")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																				AND (T1."SITE" IS NULL)
																				)
																			THEN ('01')
																		ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																		END
																	) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DEPARTMENT" IS NULL)
																				OR ((rtrim(T1."DEPARTMENT")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."DEPARTMENT")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DESTINATION" IS NULL)
																				OR ((rtrim(T1."DESTINATION")) = '')
																				)
																			THEN ('00')
																		ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																		END
																	) + '-' + (
																	(
																		rtrim(CASE 
																				WHEN (
																						(T3."MODEL_LINE" IS NOT NULL)
																						AND (T3."MODEL_LINE" <> '')
																						)
																					THEN (T3."MODEL_LINE")
																				WHEN (
																						(T1."PRODUCT_GROUP" IS NOT NULL)
																						AND (T1."PRODUCT_GROUP" <> '')
																						)
																					THEN (T1."PRODUCT_GROUP")
																				WHEN (
																						(T1."REPAIR_GROUP" IS NOT NULL)
																						AND (T1."REPAIR_GROUP" <> '')
																						)
																					THEN (T1."REPAIR_GROUP")
																				ELSE ('00')
																				END)
																		)
																	)
																) LIKE '4%'
															)
														)
													)
												THEN ('00')
											WHEN (
													(T1."MAKE" IN ('OP'))
													AND (
														NOT (
															(
																CASE 
																	WHEN (
																			(T1."MAKE" IS NULL)
																			OR ((rtrim(T1."MAKE")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."MAKE")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																			AND (T1."SITE" IS NULL)
																			)
																		THEN ('01')
																	ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																	END
																) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																CASE 
																	WHEN (
																			(T1."DEPARTMENT" IS NULL)
																			OR ((rtrim(T1."DEPARTMENT")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."DEPARTMENT")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(T1."DESTINATION" IS NULL)
																			OR ((rtrim(T1."DESTINATION")) = '')
																			)
																		THEN ('00')
																	ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																	END
																) + '-' + (
																(
																	rtrim(CASE 
																			WHEN (
																					(T3."MODEL_LINE" IS NOT NULL)
																					AND (T3."MODEL_LINE" <> '')
																					)
																				THEN (T3."MODEL_LINE")
																			WHEN (
																					(T1."PRODUCT_GROUP" IS NOT NULL)
																					AND (T1."PRODUCT_GROUP" <> '')
																					)
																				THEN (T1."PRODUCT_GROUP")
																			WHEN (
																					(T1."REPAIR_GROUP" IS NOT NULL)
																					AND (T1."REPAIR_GROUP" <> '')
																					)
																				THEN (T1."REPAIR_GROUP")
																			ELSE ('00')
																			END)
																	)
																)
															) LIKE '4%'
														)
													)
												THEN (T1."MAKE")
											WHEN (
													(
														(
															CASE 
																WHEN (
																		(T1."MAKE" IS NULL)
																		OR ((rtrim(T1."MAKE")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."MAKE")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																		AND (T1."SITE" IS NULL)
																		)
																	THEN ('01')
																ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																END
															) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
															CASE 
																WHEN (
																		(T1."DEPARTMENT" IS NULL)
																		OR ((rtrim(T1."DEPARTMENT")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."DEPARTMENT")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(T1."DESTINATION" IS NULL)
																		OR ((rtrim(T1."DESTINATION")) = '')
																		)
																	THEN ('00')
																ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																END
															) + '-' + (
															(
																rtrim(CASE 
																		WHEN (
																				(T3."MODEL_LINE" IS NOT NULL)
																				AND (T3."MODEL_LINE" <> '')
																				)
																			THEN (T3."MODEL_LINE")
																		WHEN (
																				(T1."PRODUCT_GROUP" IS NOT NULL)
																				AND (T1."PRODUCT_GROUP" <> '')
																				)
																			THEN (T1."PRODUCT_GROUP")
																		WHEN (
																				(T1."REPAIR_GROUP" IS NOT NULL)
																				AND (T1."REPAIR_GROUP" <> '')
																				)
																			THEN (T1."REPAIR_GROUP")
																		ELSE ('00')
																		END)
																)
															)
														) LIKE '4%'
													)
												THEN (
														(
															CASE 
																WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
																	THEN ('OP')
																ELSE ('00')
																END
															)
														)
											ELSE ('99')
											END
										) IN ('OP')
									)
								THEN ('OP')
							WHEN (
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR (
														(T1."MAKE" = '  ')
														AND (
															NOT (
																(
																	CASE 
																		WHEN (
																				(T1."MAKE" IS NULL)
																				OR ((rtrim(T1."MAKE")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."MAKE")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																				AND (T1."SITE" IS NULL)
																				)
																			THEN ('01')
																		ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																		END
																	) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DEPARTMENT" IS NULL)
																				OR ((rtrim(T1."DEPARTMENT")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."DEPARTMENT")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DESTINATION" IS NULL)
																				OR ((rtrim(T1."DESTINATION")) = '')
																				)
																			THEN ('00')
																		ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																		END
																	) + '-' + (
																	(
																		rtrim(CASE 
																				WHEN (
																						(T3."MODEL_LINE" IS NOT NULL)
																						AND (T3."MODEL_LINE" <> '')
																						)
																					THEN (T3."MODEL_LINE")
																				WHEN (
																						(T1."PRODUCT_GROUP" IS NOT NULL)
																						AND (T1."PRODUCT_GROUP" <> '')
																						)
																					THEN (T1."PRODUCT_GROUP")
																				WHEN (
																						(T1."REPAIR_GROUP" IS NOT NULL)
																						AND (T1."REPAIR_GROUP" <> '')
																						)
																					THEN (T1."REPAIR_GROUP")
																				ELSE ('00')
																				END)
																		)
																	)
																) LIKE '4%'
															)
														)
													)
												THEN ('00')
											WHEN (
													(T1."MAKE" IN ('OP'))
													AND (
														NOT (
															(
																CASE 
																	WHEN (
																			(T1."MAKE" IS NULL)
																			OR ((rtrim(T1."MAKE")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."MAKE")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																			AND (T1."SITE" IS NULL)
																			)
																		THEN ('01')
																	ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																	END
																) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																CASE 
																	WHEN (
																			(T1."DEPARTMENT" IS NULL)
																			OR ((rtrim(T1."DEPARTMENT")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."DEPARTMENT")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(T1."DESTINATION" IS NULL)
																			OR ((rtrim(T1."DESTINATION")) = '')
																			)
																		THEN ('00')
																	ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																	END
																) + '-' + (
																(
																	rtrim(CASE 
																			WHEN (
																					(T3."MODEL_LINE" IS NOT NULL)
																					AND (T3."MODEL_LINE" <> '')
																					)
																				THEN (T3."MODEL_LINE")
																			WHEN (
																					(T1."PRODUCT_GROUP" IS NOT NULL)
																					AND (T1."PRODUCT_GROUP" <> '')
																					)
																				THEN (T1."PRODUCT_GROUP")
																			WHEN (
																					(T1."REPAIR_GROUP" IS NOT NULL)
																					AND (T1."REPAIR_GROUP" <> '')
																					)
																				THEN (T1."REPAIR_GROUP")
																			ELSE ('00')
																			END)
																	)
																)
															) LIKE '4%'
														)
													)
												THEN (T1."MAKE")
											WHEN (
													(
														(
															CASE 
																WHEN (
																		(T1."MAKE" IS NULL)
																		OR ((rtrim(T1."MAKE")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."MAKE")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																		AND (T1."SITE" IS NULL)
																		)
																	THEN ('01')
																ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																END
															) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
															CASE 
																WHEN (
																		(T1."DEPARTMENT" IS NULL)
																		OR ((rtrim(T1."DEPARTMENT")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."DEPARTMENT")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(T1."DESTINATION" IS NULL)
																		OR ((rtrim(T1."DESTINATION")) = '')
																		)
																	THEN ('00')
																ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																END
															) + '-' + (
															(
																rtrim(CASE 
																		WHEN (
																				(T3."MODEL_LINE" IS NOT NULL)
																				AND (T3."MODEL_LINE" <> '')
																				)
																			THEN (T3."MODEL_LINE")
																		WHEN (
																				(T1."PRODUCT_GROUP" IS NOT NULL)
																				AND (T1."PRODUCT_GROUP" <> '')
																				)
																			THEN (T1."PRODUCT_GROUP")
																		WHEN (
																				(T1."REPAIR_GROUP" IS NOT NULL)
																				AND (T1."REPAIR_GROUP" <> '')
																				)
																			THEN (T1."REPAIR_GROUP")
																		ELSE ('00')
																		END)
																)
															)
														) LIKE '4%'
													)
												THEN (
														(
															CASE 
																WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
																	THEN ('OP')
																ELSE ('00')
																END
															)
														)
											ELSE ('99')
											END
										) IN ('VW')
									)
								THEN ('VW')
							ELSE NULL
							END
						) + (
						CASE 
							WHEN (T3."MODEL_LINE" IS NOT NULL)
								THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
							WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
								THEN (T1."PRODUCT_GROUP")
							WHEN (T1."REPAIR_GROUP" IS NOT NULL)
								THEN (T1."REPAIR_GROUP")
							ELSE ('00 - ohne')
							END
						)
					)
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('VW')
				)
			THEN (
					(
						CASE 
							WHEN (
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR (
														(T1."MAKE" = '  ')
														AND (
															NOT (
																(
																	CASE 
																		WHEN (
																				(T1."MAKE" IS NULL)
																				OR ((rtrim(T1."MAKE")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."MAKE")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																				AND (T1."SITE" IS NULL)
																				)
																			THEN ('01')
																		ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																		END
																	) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DEPARTMENT" IS NULL)
																				OR ((rtrim(T1."DEPARTMENT")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."DEPARTMENT")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DESTINATION" IS NULL)
																				OR ((rtrim(T1."DESTINATION")) = '')
																				)
																			THEN ('00')
																		ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																		END
																	) + '-' + (
																	(
																		rtrim(CASE 
																				WHEN (
																						(T3."MODEL_LINE" IS NOT NULL)
																						AND (T3."MODEL_LINE" <> '')
																						)
																					THEN (T3."MODEL_LINE")
																				WHEN (
																						(T1."PRODUCT_GROUP" IS NOT NULL)
																						AND (T1."PRODUCT_GROUP" <> '')
																						)
																					THEN (T1."PRODUCT_GROUP")
																				WHEN (
																						(T1."REPAIR_GROUP" IS NOT NULL)
																						AND (T1."REPAIR_GROUP" <> '')
																						)
																					THEN (T1."REPAIR_GROUP")
																				ELSE ('00')
																				END)
																		)
																	)
																) LIKE '4%'
															)
														)
													)
												THEN ('00')
											WHEN (
													(T1."MAKE" IN ('OP'))
													AND (
														NOT (
															(
																CASE 
																	WHEN (
																			(T1."MAKE" IS NULL)
																			OR ((rtrim(T1."MAKE")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."MAKE")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																			AND (T1."SITE" IS NULL)
																			)
																		THEN ('01')
																	ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																	END
																) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																CASE 
																	WHEN (
																			(T1."DEPARTMENT" IS NULL)
																			OR ((rtrim(T1."DEPARTMENT")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."DEPARTMENT")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(T1."DESTINATION" IS NULL)
																			OR ((rtrim(T1."DESTINATION")) = '')
																			)
																		THEN ('00')
																	ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																	END
																) + '-' + (
																(
																	rtrim(CASE 
																			WHEN (
																					(T3."MODEL_LINE" IS NOT NULL)
																					AND (T3."MODEL_LINE" <> '')
																					)
																				THEN (T3."MODEL_LINE")
																			WHEN (
																					(T1."PRODUCT_GROUP" IS NOT NULL)
																					AND (T1."PRODUCT_GROUP" <> '')
																					)
																				THEN (T1."PRODUCT_GROUP")
																			WHEN (
																					(T1."REPAIR_GROUP" IS NOT NULL)
																					AND (T1."REPAIR_GROUP" <> '')
																					)
																				THEN (T1."REPAIR_GROUP")
																			ELSE ('00')
																			END)
																	)
																)
															) LIKE '4%'
														)
													)
												THEN (T1."MAKE")
											WHEN (
													(
														(
															CASE 
																WHEN (
																		(T1."MAKE" IS NULL)
																		OR ((rtrim(T1."MAKE")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."MAKE")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																		AND (T1."SITE" IS NULL)
																		)
																	THEN ('01')
																ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																END
															) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
															CASE 
																WHEN (
																		(T1."DEPARTMENT" IS NULL)
																		OR ((rtrim(T1."DEPARTMENT")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."DEPARTMENT")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(T1."DESTINATION" IS NULL)
																		OR ((rtrim(T1."DESTINATION")) = '')
																		)
																	THEN ('00')
																ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																END
															) + '-' + (
															(
																rtrim(CASE 
																		WHEN (
																				(T3."MODEL_LINE" IS NOT NULL)
																				AND (T3."MODEL_LINE" <> '')
																				)
																			THEN (T3."MODEL_LINE")
																		WHEN (
																				(T1."PRODUCT_GROUP" IS NOT NULL)
																				AND (T1."PRODUCT_GROUP" <> '')
																				)
																			THEN (T1."PRODUCT_GROUP")
																		WHEN (
																				(T1."REPAIR_GROUP" IS NOT NULL)
																				AND (T1."REPAIR_GROUP" <> '')
																				)
																			THEN (T1."REPAIR_GROUP")
																		ELSE ('00')
																		END)
																)
															)
														) LIKE '4%'
													)
												THEN (
														(
															CASE 
																WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
																	THEN ('OP')
																ELSE ('00')
																END
															)
														)
											ELSE ('99')
											END
										) IN ('OP')
									)
								THEN ('OP')
							WHEN (
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR (
														(T1."MAKE" = '  ')
														AND (
															NOT (
																(
																	CASE 
																		WHEN (
																				(T1."MAKE" IS NULL)
																				OR ((rtrim(T1."MAKE")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."MAKE")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																				AND (T1."SITE" IS NULL)
																				)
																			THEN ('01')
																		ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																		END
																	) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DEPARTMENT" IS NULL)
																				OR ((rtrim(T1."DEPARTMENT")) = '')
																				)
																			THEN ('00')
																		ELSE ((rtrim(T1."DEPARTMENT")))
																		END
																	) + '-' + (
																	CASE 
																		WHEN (
																				(T1."DESTINATION" IS NULL)
																				OR ((rtrim(T1."DESTINATION")) = '')
																				)
																			THEN ('00')
																		ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																		END
																	) + '-' + (
																	(
																		rtrim(CASE 
																				WHEN (
																						(T3."MODEL_LINE" IS NOT NULL)
																						AND (T3."MODEL_LINE" <> '')
																						)
																					THEN (T3."MODEL_LINE")
																				WHEN (
																						(T1."PRODUCT_GROUP" IS NOT NULL)
																						AND (T1."PRODUCT_GROUP" <> '')
																						)
																					THEN (T1."PRODUCT_GROUP")
																				WHEN (
																						(T1."REPAIR_GROUP" IS NOT NULL)
																						AND (T1."REPAIR_GROUP" <> '')
																						)
																					THEN (T1."REPAIR_GROUP")
																				ELSE ('00')
																				END)
																		)
																	)
																) LIKE '4%'
															)
														)
													)
												THEN ('00')
											WHEN (
													(T1."MAKE" IN ('OP'))
													AND (
														NOT (
															(
																CASE 
																	WHEN (
																			(T1."MAKE" IS NULL)
																			OR ((rtrim(T1."MAKE")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."MAKE")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																			AND (T1."SITE" IS NULL)
																			)
																		THEN ('01')
																	ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																	END
																) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
																CASE 
																	WHEN (
																			(T1."DEPARTMENT" IS NULL)
																			OR ((rtrim(T1."DEPARTMENT")) = '')
																			)
																		THEN ('00')
																	ELSE ((rtrim(T1."DEPARTMENT")))
																	END
																) + '-' + (
																CASE 
																	WHEN (
																			(T1."DESTINATION" IS NULL)
																			OR ((rtrim(T1."DESTINATION")) = '')
																			)
																		THEN ('00')
																	ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																	END
																) + '-' + (
																(
																	rtrim(CASE 
																			WHEN (
																					(T3."MODEL_LINE" IS NOT NULL)
																					AND (T3."MODEL_LINE" <> '')
																					)
																				THEN (T3."MODEL_LINE")
																			WHEN (
																					(T1."PRODUCT_GROUP" IS NOT NULL)
																					AND (T1."PRODUCT_GROUP" <> '')
																					)
																				THEN (T1."PRODUCT_GROUP")
																			WHEN (
																					(T1."REPAIR_GROUP" IS NOT NULL)
																					AND (T1."REPAIR_GROUP" <> '')
																					)
																				THEN (T1."REPAIR_GROUP")
																			ELSE ('00')
																			END)
																	)
																)
															) LIKE '4%'
														)
													)
												THEN (T1."MAKE")
											WHEN (
													(
														(
															CASE 
																WHEN (
																		(T1."MAKE" IS NULL)
																		OR ((rtrim(T1."MAKE")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."MAKE")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(((rtrim(T2."ACCT_NR"))) LIKE '2%')
																		AND (T1."SITE" IS NULL)
																		)
																	THEN ('01')
																ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
																END
															) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
															CASE 
																WHEN (
																		(T1."DEPARTMENT" IS NULL)
																		OR ((rtrim(T1."DEPARTMENT")) = '')
																		)
																	THEN ('00')
																ELSE ((rtrim(T1."DEPARTMENT")))
																END
															) + '-' + (
															CASE 
																WHEN (
																		(T1."DESTINATION" IS NULL)
																		OR ((rtrim(T1."DESTINATION")) = '')
																		)
																	THEN ('00')
																ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
																END
															) + '-' + (
															(
																rtrim(CASE 
																		WHEN (
																				(T3."MODEL_LINE" IS NOT NULL)
																				AND (T3."MODEL_LINE" <> '')
																				)
																			THEN (T3."MODEL_LINE")
																		WHEN (
																				(T1."PRODUCT_GROUP" IS NOT NULL)
																				AND (T1."PRODUCT_GROUP" <> '')
																				)
																			THEN (T1."PRODUCT_GROUP")
																		WHEN (
																				(T1."REPAIR_GROUP" IS NOT NULL)
																				AND (T1."REPAIR_GROUP" <> '')
																				)
																			THEN (T1."REPAIR_GROUP")
																		ELSE ('00')
																		END)
																)
															)
														) LIKE '4%'
													)
												THEN (
														(
															CASE 
																WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
																	THEN ('OP')
																ELSE ('00')
																END
															)
														)
											ELSE ('99')
											END
										) IN ('VW')
									)
								THEN ('VW')
							ELSE NULL
							END
						) + (
						CASE 
							WHEN (T3."MODEL_LINE" IS NOT NULL)
								THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
							WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
								THEN (T1."PRODUCT_GROUP")
							WHEN (T1."REPAIR_GROUP" IS NOT NULL)
								THEN (T1."REPAIR_GROUP")
							ELSE ('00 - ohne')
							END
						)
					)
		ELSE (
				(
					CASE 
						WHEN (T3."MODEL_LINE" IS NOT NULL)
							THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
						WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
							THEN (T1."PRODUCT_GROUP")
						WHEN (T1."REPAIR_GROUP" IS NOT NULL)
							THEN (T1."REPAIR_GROUP")
						ELSE ('00 - ohne')
						END
					)
				)
		END AS "Kostentr�ger_mit_Bez",
	(
		substring((
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR ((rtrim(T1."MAKE")) = '')
								)
							THEN ('00')
						ELSE ((rtrim(T1."MAKE")))
						END
					) + '-' + (
					CASE 
						WHEN (
								(((rtrim(T2."ACCT_NR"))) LIKE '2%')
								AND (T1."SITE" IS NULL)
								)
							THEN ('01')
						ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
						END
					) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
					CASE 
						WHEN (
								(T1."DEPARTMENT" IS NULL)
								OR ((rtrim(T1."DEPARTMENT")) = '')
								)
							THEN ('00')
						ELSE ((rtrim(T1."DEPARTMENT")))
						END
					) + '-' + (
					CASE 
						WHEN (
								(T1."DESTINATION" IS NULL)
								OR ((rtrim(T1."DESTINATION")) = '')
								)
							THEN ('00')
						ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
						END
					) + '-' + (
					(
						rtrim(CASE 
								WHEN (
										(T3."MODEL_LINE" IS NOT NULL)
										AND (T3."MODEL_LINE" <> '')
										)
									THEN (T3."MODEL_LINE")
								WHEN (
										(T1."PRODUCT_GROUP" IS NOT NULL)
										AND (T1."PRODUCT_GROUP" <> '')
										)
									THEN (T1."PRODUCT_GROUP")
								WHEN (
										(T1."REPAIR_GROUP" IS NOT NULL)
										AND (T1."REPAIR_GROUP" <> '')
										)
									THEN (T1."REPAIR_GROUP")
								ELSE ('00')
								END)
						)
					)
				), 1, 4)
		) + '-' + (
		CASE 
			WHEN (
					(T1."MAKE" IS NULL)
					OR (
						(T1."MAKE" = '  ')
						AND (
							NOT (
								(
									CASE 
										WHEN (
												(T1."MAKE" IS NULL)
												OR ((rtrim(T1."MAKE")) = '')
												)
											THEN ('00')
										ELSE ((rtrim(T1."MAKE")))
										END
									) + '-' + (
									CASE 
										WHEN (
												(((rtrim(T2."ACCT_NR"))) LIKE '2%')
												AND (T1."SITE" IS NULL)
												)
											THEN ('01')
										ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
										END
									) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
									CASE 
										WHEN (
												(T1."DEPARTMENT" IS NULL)
												OR ((rtrim(T1."DEPARTMENT")) = '')
												)
											THEN ('00')
										ELSE ((rtrim(T1."DEPARTMENT")))
										END
									) + '-' + (
									CASE 
										WHEN (
												(T1."DESTINATION" IS NULL)
												OR ((rtrim(T1."DESTINATION")) = '')
												)
											THEN ('00')
										ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
										END
									) + '-' + (
									(
										rtrim(CASE 
												WHEN (
														(T3."MODEL_LINE" IS NOT NULL)
														AND (T3."MODEL_LINE" <> '')
														)
													THEN (T3."MODEL_LINE")
												WHEN (
														(T1."PRODUCT_GROUP" IS NOT NULL)
														AND (T1."PRODUCT_GROUP" <> '')
														)
													THEN (T1."PRODUCT_GROUP")
												WHEN (
														(T1."REPAIR_GROUP" IS NOT NULL)
														AND (T1."REPAIR_GROUP" <> '')
														)
													THEN (T1."REPAIR_GROUP")
												ELSE ('00')
												END)
										)
									)
								) LIKE '4%'
							)
						)
					)
				THEN ('00')
			WHEN (
					(T1."MAKE" IN ('OP'))
					AND (
						NOT (
							(
								CASE 
									WHEN (
											(T1."MAKE" IS NULL)
											OR ((rtrim(T1."MAKE")) = '')
											)
										THEN ('00')
									ELSE ((rtrim(T1."MAKE")))
									END
								) + '-' + (
								CASE 
									WHEN (
											(((rtrim(T2."ACCT_NR"))) LIKE '2%')
											AND (T1."SITE" IS NULL)
											)
										THEN ('01')
									ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
									END
								) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
								CASE 
									WHEN (
											(T1."DEPARTMENT" IS NULL)
											OR ((rtrim(T1."DEPARTMENT")) = '')
											)
										THEN ('00')
									ELSE ((rtrim(T1."DEPARTMENT")))
									END
								) + '-' + (
								CASE 
									WHEN (
											(T1."DESTINATION" IS NULL)
											OR ((rtrim(T1."DESTINATION")) = '')
											)
										THEN ('00')
									ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
									END
								) + '-' + (
								(
									rtrim(CASE 
											WHEN (
													(T3."MODEL_LINE" IS NOT NULL)
													AND (T3."MODEL_LINE" <> '')
													)
												THEN (T3."MODEL_LINE")
											WHEN (
													(T1."PRODUCT_GROUP" IS NOT NULL)
													AND (T1."PRODUCT_GROUP" <> '')
													)
												THEN (T1."PRODUCT_GROUP")
											WHEN (
													(T1."REPAIR_GROUP" IS NOT NULL)
													AND (T1."REPAIR_GROUP" <> '')
													)
												THEN (T1."REPAIR_GROUP")
											ELSE ('00')
											END)
									)
								)
							) LIKE '4%'
						)
					)
				THEN (T1."MAKE")
			WHEN (
					(
						(
							CASE 
								WHEN (
										(T1."MAKE" IS NULL)
										OR ((rtrim(T1."MAKE")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."MAKE")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(((rtrim(T2."ACCT_NR"))) LIKE '2%')
										AND (T1."SITE" IS NULL)
										)
									THEN ('01')
								ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
								END
							) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
							CASE 
								WHEN (
										(T1."DEPARTMENT" IS NULL)
										OR ((rtrim(T1."DEPARTMENT")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."DEPARTMENT")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(T1."DESTINATION" IS NULL)
										OR ((rtrim(T1."DESTINATION")) = '')
										)
									THEN ('00')
								ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
								END
							) + '-' + (
							(
								rtrim(CASE 
										WHEN (
												(T3."MODEL_LINE" IS NOT NULL)
												AND (T3."MODEL_LINE" <> '')
												)
											THEN (T3."MODEL_LINE")
										WHEN (
												(T1."PRODUCT_GROUP" IS NOT NULL)
												AND (T1."PRODUCT_GROUP" <> '')
												)
											THEN (T1."PRODUCT_GROUP")
										WHEN (
												(T1."REPAIR_GROUP" IS NOT NULL)
												AND (T1."REPAIR_GROUP" <> '')
												)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00')
										END)
								)
							)
						) LIKE '4%'
					)
				THEN (
						(
							CASE 
								WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
									THEN ('OP')
								ELSE ('00')
								END
							)
						)
			ELSE ('99')
			END
		) + (left(T1."SITE", 2)) + (
		substring((
				CASE 
					WHEN (T1."DEPARTMENT" = '    ')
						THEN ('00')
					ELSE (T1."DEPARTMENT")
					END
				), 1, 2)
		) + (
		CASE 
			WHEN (T1."DESTINATION" IS NULL)
				THEN ('00')
			ELSE (T1."DESTINATION")
			END
		) + (
		(
			substring((
					CASE 
						WHEN (T3."MODEL_LINE" IS NOT NULL)
							THEN (T3."MODEL_LINE" + ' - ' + T3."MOD_LIN_SPECIFY")
						WHEN (T1."PRODUCT_GROUP" IS NOT NULL)
							THEN (T1."PRODUCT_GROUP")
						WHEN (T1."REPAIR_GROUP" IS NOT NULL)
							THEN (T1."REPAIR_GROUP")
						ELSE ('00 - ohne')
						END
					), 1, 2)
			)
		) AS "ACCT_Detail",
	CASE 
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) = '00'
				)
			THEN ('ohne Marke')
		ELSE ('mit Marke')
		END AS "Buchungen ohne Marke",
	CASE 
		WHEN (
				(
					CASE 
						WHEN (T1."DEPARTMENT" = '    ')
							THEN ('00')
						ELSE (T1."DEPARTMENT")
						END
					) = '00'
				)
			THEN ('ohne KST')
		ELSE ('mit KST')
		END AS "Buchungen ohne KST",
	CASE 
		WHEN (
				(
					CASE 
						WHEN (T1."DESTINATION" IS NULL)
							THEN ('00')
						ELSE (T1."DESTINATION")
						END
					) = '00'
				)
			THEN (('ohne Absatzkanal'))
		ELSE ('mit Absatzkanal')
		END AS "Buchungen ohne Absatzkanal",
	T1."DESTINATION" AS "Destination",
	CASE 
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('00')
				)
			THEN ('00 - ohne Marke')
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('OP')
				)
			THEN ('OP - Opel')
		WHEN (
				(
					CASE 
						WHEN (
								(T1."MAKE" IS NULL)
								OR (
									(T1."MAKE" = '  ')
									AND (
										NOT (
											(
												CASE 
													WHEN (
															(T1."MAKE" IS NULL)
															OR ((rtrim(T1."MAKE")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."MAKE")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(((rtrim(T2."ACCT_NR"))) LIKE '2%')
															AND (T1."SITE" IS NULL)
															)
														THEN ('01')
													ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
													END
												) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
												CASE 
													WHEN (
															(T1."DEPARTMENT" IS NULL)
															OR ((rtrim(T1."DEPARTMENT")) = '')
															)
														THEN ('00')
													ELSE ((rtrim(T1."DEPARTMENT")))
													END
												) + '-' + (
												CASE 
													WHEN (
															(T1."DESTINATION" IS NULL)
															OR ((rtrim(T1."DESTINATION")) = '')
															)
														THEN ('00')
													ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
													END
												) + '-' + (
												(
													rtrim(CASE 
															WHEN (
																	(T3."MODEL_LINE" IS NOT NULL)
																	AND (T3."MODEL_LINE" <> '')
																	)
																THEN (T3."MODEL_LINE")
															WHEN (
																	(T1."PRODUCT_GROUP" IS NOT NULL)
																	AND (T1."PRODUCT_GROUP" <> '')
																	)
																THEN (T1."PRODUCT_GROUP")
															WHEN (
																	(T1."REPAIR_GROUP" IS NOT NULL)
																	AND (T1."REPAIR_GROUP" <> '')
																	)
																THEN (T1."REPAIR_GROUP")
															ELSE ('00')
															END)
													)
												)
											) LIKE '4%'
										)
									)
								)
							THEN ('00')
						WHEN (
								(T1."MAKE" IN ('OP'))
								AND (
									NOT (
										(
											CASE 
												WHEN (
														(T1."MAKE" IS NULL)
														OR ((rtrim(T1."MAKE")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."MAKE")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(((rtrim(T2."ACCT_NR"))) LIKE '2%')
														AND (T1."SITE" IS NULL)
														)
													THEN ('01')
												ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
												END
											) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
											CASE 
												WHEN (
														(T1."DEPARTMENT" IS NULL)
														OR ((rtrim(T1."DEPARTMENT")) = '')
														)
													THEN ('00')
												ELSE ((rtrim(T1."DEPARTMENT")))
												END
											) + '-' + (
											CASE 
												WHEN (
														(T1."DESTINATION" IS NULL)
														OR ((rtrim(T1."DESTINATION")) = '')
														)
													THEN ('00')
												ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
												END
											) + '-' + (
											(
												rtrim(CASE 
														WHEN (
																(T3."MODEL_LINE" IS NOT NULL)
																AND (T3."MODEL_LINE" <> '')
																)
															THEN (T3."MODEL_LINE")
														WHEN (
																(T1."PRODUCT_GROUP" IS NOT NULL)
																AND (T1."PRODUCT_GROUP" <> '')
																)
															THEN (T1."PRODUCT_GROUP")
														WHEN (
																(T1."REPAIR_GROUP" IS NOT NULL)
																AND (T1."REPAIR_GROUP" <> '')
																)
															THEN (T1."REPAIR_GROUP")
														ELSE ('00')
														END)
												)
											)
										) LIKE '4%'
									)
								)
							THEN (T1."MAKE")
						WHEN (
								(
									(
										CASE 
											WHEN (
													(T1."MAKE" IS NULL)
													OR ((rtrim(T1."MAKE")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."MAKE")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(((rtrim(T2."ACCT_NR"))) LIKE '2%')
													AND (T1."SITE" IS NULL)
													)
												THEN ('01')
											ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
											END
										) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
										CASE 
											WHEN (
													(T1."DEPARTMENT" IS NULL)
													OR ((rtrim(T1."DEPARTMENT")) = '')
													)
												THEN ('00')
											ELSE ((rtrim(T1."DEPARTMENT")))
											END
										) + '-' + (
										CASE 
											WHEN (
													(T1."DESTINATION" IS NULL)
													OR ((rtrim(T1."DESTINATION")) = '')
													)
												THEN ('00')
											ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
											END
										) + '-' + (
										(
											rtrim(CASE 
													WHEN (
															(T3."MODEL_LINE" IS NOT NULL)
															AND (T3."MODEL_LINE" <> '')
															)
														THEN (T3."MODEL_LINE")
													WHEN (
															(T1."PRODUCT_GROUP" IS NOT NULL)
															AND (T1."PRODUCT_GROUP" <> '')
															)
														THEN (T1."PRODUCT_GROUP")
													WHEN (
															(T1."REPAIR_GROUP" IS NOT NULL)
															AND (T1."REPAIR_GROUP" <> '')
															)
														THEN (T1."REPAIR_GROUP")
													ELSE ('00')
													END)
											)
										)
									) LIKE '4%'
								)
							THEN (
									(
										CASE 
											WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
												THEN ('OP')
											ELSE ('00')
											END
										)
									)
						ELSE ('99')
						END
					) IN ('99')
				)
			THEN ('99 - Fremd')
		ELSE NULL
		END AS "Marke_mit_Bez",
	T1."STRATEGIC_AREA" AS "Strategic Area",
	CASE 
		WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
			THEN ('OP')
		ELSE ('00')
		END AS "Marke_Strategic_Area",
	(T1."DEBIT_AMOUNT" + T1."CREDIT_AMOUNT") * - 1 AS "Umsatz_FIBU_gesamt",
	T6."Hauptbetrieb_ID" AS "Hauptbetrieb Id",
	T6."Hauptbetrieb_Name" AS "Hauptbetrieb Name",
	T6."Standort_ID" AS "Standort Id",
	T6."Standort_Name" AS "Standort Name",
	(
		CASE 
			WHEN (
					(T1."MAKE" IS NULL)
					OR (
						(T1."MAKE" = '  ')
						AND (
							NOT (
								(
									CASE 
										WHEN (
												(T1."MAKE" IS NULL)
												OR ((rtrim(T1."MAKE")) = '')
												)
											THEN ('00')
										ELSE ((rtrim(T1."MAKE")))
										END
									) + '-' + (
									CASE 
										WHEN (
												(((rtrim(T2."ACCT_NR"))) LIKE '2%')
												AND (T1."SITE" IS NULL)
												)
											THEN ('01')
										ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
										END
									) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
									CASE 
										WHEN (
												(T1."DEPARTMENT" IS NULL)
												OR ((rtrim(T1."DEPARTMENT")) = '')
												)
											THEN ('00')
										ELSE ((rtrim(T1."DEPARTMENT")))
										END
									) + '-' + (
									CASE 
										WHEN (
												(T1."DESTINATION" IS NULL)
												OR ((rtrim(T1."DESTINATION")) = '')
												)
											THEN ('00')
										ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
										END
									) + '-' + (
									(
										rtrim(CASE 
												WHEN (
														(T3."MODEL_LINE" IS NOT NULL)
														AND (T3."MODEL_LINE" <> '')
														)
													THEN (T3."MODEL_LINE")
												WHEN (
														(T1."PRODUCT_GROUP" IS NOT NULL)
														AND (T1."PRODUCT_GROUP" <> '')
														)
													THEN (T1."PRODUCT_GROUP")
												WHEN (
														(T1."REPAIR_GROUP" IS NOT NULL)
														AND (T1."REPAIR_GROUP" <> '')
														)
													THEN (T1."REPAIR_GROUP")
												ELSE ('00')
												END)
										)
									)
								) LIKE '4%'
							)
						)
					)
				THEN ('00')
			WHEN (
					(T1."MAKE" IN ('OP'))
					AND (
						NOT (
							(
								CASE 
									WHEN (
											(T1."MAKE" IS NULL)
											OR ((rtrim(T1."MAKE")) = '')
											)
										THEN ('00')
									ELSE ((rtrim(T1."MAKE")))
									END
								) + '-' + (
								CASE 
									WHEN (
											(((rtrim(T2."ACCT_NR"))) LIKE '2%')
											AND (T1."SITE" IS NULL)
											)
										THEN ('01')
									ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
									END
								) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
								CASE 
									WHEN (
											(T1."DEPARTMENT" IS NULL)
											OR ((rtrim(T1."DEPARTMENT")) = '')
											)
										THEN ('00')
									ELSE ((rtrim(T1."DEPARTMENT")))
									END
								) + '-' + (
								CASE 
									WHEN (
											(T1."DESTINATION" IS NULL)
											OR ((rtrim(T1."DESTINATION")) = '')
											)
										THEN ('00')
									ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
									END
								) + '-' + (
								(
									rtrim(CASE 
											WHEN (
													(T3."MODEL_LINE" IS NOT NULL)
													AND (T3."MODEL_LINE" <> '')
													)
												THEN (T3."MODEL_LINE")
											WHEN (
													(T1."PRODUCT_GROUP" IS NOT NULL)
													AND (T1."PRODUCT_GROUP" <> '')
													)
												THEN (T1."PRODUCT_GROUP")
											WHEN (
													(T1."REPAIR_GROUP" IS NOT NULL)
													AND (T1."REPAIR_GROUP" <> '')
													)
												THEN (T1."REPAIR_GROUP")
											ELSE ('00')
											END)
									)
								)
							) LIKE '4%'
						)
					)
				THEN (T1."MAKE")
			WHEN (
					(
						(
							CASE 
								WHEN (
										(T1."MAKE" IS NULL)
										OR ((rtrim(T1."MAKE")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."MAKE")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(((rtrim(T2."ACCT_NR"))) LIKE '2%')
										AND (T1."SITE" IS NULL)
										)
									THEN ('01')
								ELSE ((right('00' + (left(T1."SITE", 2)), 2)))
								END
							) + '-' + ((rtrim(T2."ACCT_NR"))) + '-' + (
							CASE 
								WHEN (
										(T1."DEPARTMENT" IS NULL)
										OR ((rtrim(T1."DEPARTMENT")) = '')
										)
									THEN ('00')
								ELSE ((rtrim(T1."DEPARTMENT")))
								END
							) + '-' + (
							CASE 
								WHEN (
										(T1."DESTINATION" IS NULL)
										OR ((rtrim(T1."DESTINATION")) = '')
										)
									THEN ('00')
								ELSE ((right('00' + (rtrim(T1."DESTINATION")), 2)))
								END
							) + '-' + (
							(
								rtrim(CASE 
										WHEN (
												(T3."MODEL_LINE" IS NOT NULL)
												AND (T3."MODEL_LINE" <> '')
												)
											THEN (T3."MODEL_LINE")
										WHEN (
												(T1."PRODUCT_GROUP" IS NOT NULL)
												AND (T1."PRODUCT_GROUP" <> '')
												)
											THEN (T1."PRODUCT_GROUP")
										WHEN (
												(T1."REPAIR_GROUP" IS NOT NULL)
												AND (T1."REPAIR_GROUP" <> '')
												)
											THEN (T1."REPAIR_GROUP")
										ELSE ('00')
										END)
								)
							)
						) LIKE '4%'
					)
				THEN (
						(
							CASE 
								WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ', 'Opel      ', 'OPEL      '))
									THEN ('OP')
								ELSE ('00')
								END
							)
						)
			ELSE ('99')
			END
		) AS "Fabrikat"
FROM "OPTIMA"."import"."ACCOUNT_INFO" T2,
	(
		(
			"OPTIMA"."import"."ACCT_DOC_KEY" T1 LEFT JOIN "OPTIMA"."import"."vPP5Q" T3 ON (T1."MODEL_LINE" = T3."MODEL_LINE")
				AND (T1."MAKE" = T3."MAKE_CD")
			) LEFT JOIN "OPTIMA"."data"."GC_Department" T6 ON (T1."CLIENT_DB" = T6."Hauptbetrieb")
			AND (T1."SITE" = T6."Site")
		),
	(
		(
			"OPTIMA"."import"."ACCT_DOC_DATA" T7 LEFT JOIN "OPTIMA"."import"."ACCT_DOC_SALESCLAS" T4 ON T7."REFERENCE_IDENT" = T4."REFERENCE_IDENT"
			) LEFT JOIN "OPTIMA"."import"."CUSTOMER" T5 ON T5."CUSTOMER_NUMBER" = T4."CUSTOMER_NUMBER"
		)
WHERE (T2."ACCT_NR" = T1."ACCT_NO")
	AND (T1."UNIQUE_IDENT" = T7."REFERENCE_IDENT")
	AND (
		(T2."TYPE_ACCTT" = '2')
		AND (T1."ACCT_NO" LIKE '8%')
		)