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%') )