COGNOS QUERY STRUCTURE,1,1 DATABASE,O21_SKR51 DATASOURCENAME,D:\Gaps\Portal\System\IQD\Belege\GuV_8_O21_SKR.imr TITLE,GuV_8_O21_SKR.imr BEGIN SQL select T1."ACCT_NR" as c1, T1."LEDGER_ACCTS_NAME" as c2, T1."LEDGER_ACCTS_NAME2" as c3, T1."HANDLER" as c4, T1."DEPT_SPLIT" as c5, T1."TYPE_ACCTT" as c6, T2."ACCT_NO" as c7, T2."BOOKKEEP_DATE" as c8, T2."BOOKKEEP_PERIOD" as c9, (intdiv(T2."DOCUMENT_NO",1)) as c10, T2."ORIGIN" as c11, T2."STATUS" as c12, T2."DEBIT_AMOUNT" as c13, T2."CREDIT_AMOUNT" as c14, T2."DEBIT_QUANTITY" as c15, T2."CREDIT_QUANTITY" as c16, T2."AA_TRTYPE" as c17, T2."DEPARTMENT" as c18, T2."STOCK" as c19, T2."MAKE_FAMILY" as c20, CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END as c21, T2."VEHICLE_TYPE" as c22, T2."MODEL_LINE" as c23, T2."FACTORY_MODEL" as c24, T2."WORKSHOP_MODEL" as c25, T2."PRODUCT_GROUP" as c26, T2."REPAIR_GROUP" as c27, T2."KIT_GROUP" as c28, T2."TIME_CODE" as c29, T2."INT_VOUCHER_NO" as c30, T2."BALANCING_MARK" as c31, T2."USED_VEH_DEST_CODE" as c32, T2."USE_OF_VEHICLE" as c33, T2."ACCT_NO_NEXT_CHART" as c34, T3."REFERENCE_IDENT" as c35, T3."TRANSACT_DATE" as c36, T3."HANDLER" as c37, T3."PROGRAM" as c38, T3."FUNCTION_CODE" as c39, T3."MODUL" as c40, T3."DOCUMENT_KEY" as c41, T3."COMMENT" as c42, T4."DEPARTMENT_TYPE_ID" as c43, T4."DESCRIPTION" as c44, T4."DEPARTMENT_GROUP" as c45, T5."AA_TRTYPE_ID" as c46, T5."DESCRIPTION" as c47, T5."OWN_DESCRIPTION" as c48, '1' as c49, CASE WHEN (T2."SITE" = ' ') THEN ('01') ELSE ((od_left(T2."SITE",2))) END as c50, CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END as c51, T2."DEBIT_AMOUNT" + T2."CREDIT_AMOUNT" as c52, (database()) as c53, CASE WHEN ((T1."ACCT_NR" IN ('8000','8010','8020','8100','8110','8410','8510')) or ((CASE WHEN ((od_left(T1."ACCT_NR",1)) IN ('4','5','7','8')) THEN ((rtrim(T1."ACCT_NR")) || '_' || (substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 1))) ELSE ((rtrim(T1."ACCT_NR"))) END) IN ('5701_4'))) THEN (T2."DEBIT_QUANTITY" + T2."CREDIT_QUANTITY") ELSE (0) END as c54, CASE WHEN ((extract(DAY FROM (now()) - T2."BOOKKEEP_DATE")) <= 30) THEN ((substring((ascii(((intdiv(T2."DOCUMENT_NO",1))))) from 1 for 7)) || ' - ' || T3."COMMENT") ELSE null END as c55, T6."ORDER_NUMBER" as c56, T6."LINE_NUMBER" as c57, T6."INV_TIME" as c58, T6."INV_TIME_INT" as c59, T6."MAKE_TIME_UNIT" as c60, T2."SITE" as c61, CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END as c62, T7."MODEL_LINE" as c63, T7."MOD_LIN_SPECIFY" as c64, CASE WHEN (T7."MODEL_LINE" IS NOT NULL) THEN (T7."MODEL_LINE" || ' - ' || T7."MOD_LIN_SPECIFY") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN (T2."PRODUCT_GROUP") WHEN (T2."REPAIR_GROUP" IS NOT NULL) THEN (T2."REPAIR_GROUP") ELSE ('00 - ohne') END as c65, CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END as c66, T9."CUSTOMER_NUMBER" as c67, T10."CUSTOMER_GROUP" as c68, CASE WHEN ((T2."DESTINATION" IS NULL) or ((rtrim(T2."DESTINATION")) = '')) THEN ('00') ELSE ((rtrim(T2."DESTINATION"))) END as c69, T1."TYPE_ACCTT" as c70, (od_left(T1."ACCT_NR",1)) as c71, CASE WHEN (((substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 1)) = '1') and (not (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END) IN ('00'))) THEN ('Neuwagen') WHEN (((substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 1)) = '2') and (not (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END) IN ('00'))) THEN ('Gebrauchtwagen') WHEN (((substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 1)) = '3') and (not (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END) IN ('00'))) THEN ('Teile & Zubehör') WHEN (((substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 1)) = '4') and (not (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END) IN ('00'))) THEN ('Service') ELSE ('Ohne Kostenträger') END as c72, (CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) as c73, CASE WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('MA')) THEN (((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END)) || (CASE WHEN (T7."MODEL_LINE" IS NOT NULL) THEN (T7."MODEL_LINE" || ' - ' || T7."MOD_LIN_SPECIFY") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN (T2."PRODUCT_GROUP") WHEN (T2."REPAIR_GROUP" IS NOT NULL) THEN (T2."REPAIR_GROUP") ELSE ('00 - ohne') END)) WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('KI')) THEN (((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END)) || (CASE WHEN (T7."MODEL_LINE" IS NOT NULL) THEN (T7."MODEL_LINE" || ' - ' || T7."MOD_LIN_SPECIFY") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN (T2."PRODUCT_GROUP") WHEN (T2."REPAIR_GROUP" IS NOT NULL) THEN (T2."REPAIR_GROUP") ELSE ('00 - ohne') END)) WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('VO')) THEN (((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END)) || (CASE WHEN (T7."MODEL_LINE" IS NOT NULL) THEN (T7."MODEL_LINE" || ' - ' || T7."MOD_LIN_SPECIFY") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN (T2."PRODUCT_GROUP") WHEN (T2."REPAIR_GROUP" IS NOT NULL) THEN (T2."REPAIR_GROUP") ELSE ('00 - ohne') END)) WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('FO')) THEN (((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END)) || (CASE WHEN (T7."MODEL_LINE" IS NOT NULL) THEN (T7."MODEL_LINE" || ' - ' || T7."MOD_LIN_SPECIFY") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN (T2."PRODUCT_GROUP") WHEN (T2."REPAIR_GROUP" IS NOT NULL) THEN (T2."REPAIR_GROUP") ELSE ('00 - ohne') END)) ELSE ((CASE WHEN (T7."MODEL_LINE" IS NOT NULL) THEN (T7."MODEL_LINE" || ' - ' || T7."MOD_LIN_SPECIFY") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN (T2."PRODUCT_GROUP") WHEN (T2."REPAIR_GROUP" IS NOT NULL) THEN (T2."REPAIR_GROUP") ELSE ('00 - ohne') END)) END as c74, (od_left(T1."ACCT_NR",4)) || '-' || (CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) || (od_left(T2."SITE",2)) || (substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 2)) || (CASE WHEN ((T2."DESTINATION" IS NULL) or ((rtrim(T2."DESTINATION")) = '')) THEN ('00') ELSE ((rtrim(T2."DESTINATION"))) END) || (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END) as c75, CASE WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) = '00') THEN ('ohne Marke') ELSE ('mit Marke') END as c76, CASE WHEN ((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) = '00') THEN ('ohne KST') ELSE ('mit KST') END as c77, CASE WHEN ((CASE WHEN ((T2."DESTINATION" IS NULL) or ((rtrim(T2."DESTINATION")) = '')) THEN ('00') ELSE ((rtrim(T2."DESTINATION"))) END) = '00') THEN (('ohne Absatzkanal')) ELSE ('mit Absatzkanal') END as c78, T2."DESTINATION" as c79, CASE WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('00')) THEN ('00 - ohne Marke') WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('OP')) THEN ('OP - Opel') WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('MI')) THEN ('MI - Mitsubishi') WHEN ((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IN ('VW')) THEN ('VW - Volkswagen') WHEN ((CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) IN ('99')) THEN ('99 - Fremd') ELSE null END as c80, CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((char_length((CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END))) = 1)) THEN ('X' || (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END)) ELSE ((CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END)) END as c81, CASE WHEN ((od_left(T1."ACCT_NR",1)) IN ('4','5','7','8')) THEN ((rtrim(T1."ACCT_NR")) || '_' || (substring((CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) from 1 for 1))) ELSE ((rtrim(T1."ACCT_NR"))) END as c82, (CASE WHEN (((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) IS NULL) or ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END))) = '')) THEN ('00') ELSE ((truncate((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END)))) END) || '-' || (CASE WHEN (T2."SITE" = ' ') THEN ('01') ELSE ((od_left(T2."SITE",2))) END) || '-' || ((rtrim(T1."ACCT_NR"))) || '-' || (CASE WHEN ((rtrim(T2."DEPARTMENT")) = '') THEN ('00') ELSE ((rtrim(T2."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T2."DESTINATION" IS NULL) or ((rtrim(T2."DESTINATION")) = '')) THEN ('00') ELSE ((rtrim(T2."DESTINATION"))) END) || '-' || (CASE WHEN ((T7."MODEL_LINE" IS NOT NULL) and ((rtrim(T7."MODEL_LINE")) <> '')) THEN ((rtrim(T7."MODEL_LINE"))) WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and ((rtrim(T2."PRODUCT_GROUP")) <> '')) THEN ((rtrim(((cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))))))) WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and ((rtrim(T2."REPAIR_GROUP")) <> '')) THEN ((rtrim(T2."REPAIR_GROUP"))) ELSE ('00') END) as c83, T2."MAKE" as c84, (ucase(T2."STRATEGIC_AREA")) as c85, CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END as c86, CASE WHEN ((CASE WHEN ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END) IS NULL) THEN ('ZZ') ELSE ((CASE WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'OPEL ') THEN ('OP') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'MITSU ') THEN ('MI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'CITROEN ') THEN ('CI') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'PEUGEOT ') THEN ('PE') WHEN (((ucase(T2."STRATEGIC_AREA"))) = 'AUTO ') THEN ('ZZ') ELSE null END)) END) = '') THEN ('Marke fehlt') ELSE (T2."MAKE") END as c87, (rtrim(T1."ACCT_NR")) as c88, T8."SKR51_PRODUCT_GROUP" as c89, (cast_numberToString(cast_integer(T8."SKR51_PRODUCT_GROUP"))) as c90, T3."SUB_ACCT_NO" as c91, (od_left(T3."SUB_ACCT_NO",1)) as c92 from "deop01"."dbo"."ACCOUNT_INFO" T1, (((("deop01"."dbo"."ACCT_DOC_KEY" T2 left outer join "deop01"."dbo"."DEPARTMENT_TYPE" T4 on T2."DEPARTMENT" = T4."DEPARTMENT_TYPE_ID") left outer join "deop01"."dbo"."AA_TRTYPE" T5 on T2."AA_TRTYPE" = T5."AA_TRTYPE_ID") left outer join "deop01"."dbo"."vPP5Q" T7 on (T2."MODEL_LINE" = T7."MODEL_LINE") and (T2."MAKE" = T7."MAKE_CD")) left outer join "deop01"."dbo"."vPP65" T8 on T8."PRODUCT_GROUP" = T2."PRODUCT_GROUP"), ((("deop01"."dbo"."ACCT_DOC_DATA" T3 left outer join "deop01"."dbo"."ACCT_DOC_SALESCLAS" T9 on T3."REFERENCE_IDENT" = T9."REFERENCE_IDENT") left outer join "deop01"."dbo"."ORDER_LINE" T6 on (T6."ORDER_NUMBER" = T9."ORDER_NUMBER") and (T6."LINE_NUMBER" = T9."ORDER_LINE_NUMBER")) left outer join "deop01"."dbo"."CUSTOMER" T10 on T10."CUSTOMER_NUMBER" = T9."CUSTOMER_NUMBER") where (T1."ACCT_NR" = T2."ACCT_NO") and (T2."UNIQUE_IDENT" = T3."REFERENCE_IDENT") and ((T1."TYPE_ACCTT" = '2') and (T2."BOOKKEEP_DATE" >= TIMESTAMP '2021-01-01 00:00:00.000')) END SQL COLUMN,0,Acct Nr COLUMN,1,Ledger Accts Name COLUMN,2,Ledger Accts Name2 COLUMN,3,Handler COLUMN,4,Dept Split COLUMN,5,Type Acctt COLUMN,6,Acct No COLUMN,7,Bookkeep Date COLUMN,8,Bookkeep Period COLUMN,9,Document No COLUMN,10,Origin COLUMN,11,Status COLUMN,12,Debit Amount COLUMN,13,Credit Amount COLUMN,14,Debit Quantity COLUMN,15,Credit Quantity COLUMN,16,Aa Trtype COLUMN,17,Department COLUMN,18,Stock COLUMN,19,Make Family COLUMN,20,Make COLUMN,21,Vehicle Type COLUMN,22,Model Line COLUMN,23,Factory Model COLUMN,24,Workshop Model COLUMN,25,Product Group COLUMN,26,Repair Group COLUMN,27,Kit Group COLUMN,28,Time Code COLUMN,29,Int Voucher No COLUMN,30,Balancing Mark COLUMN,31,Used Veh Dest Code COLUMN,32,Use Of Vehicle COLUMN,33,Acct No Next Chart COLUMN,34,Reference Ident COLUMN,35,Transact Date COLUMN,36,Handler COLUMN,37,Program COLUMN,38,Function Code COLUMN,39,Modul COLUMN,40,Document Key COLUMN,41,Comment COLUMN,42,Department Type Id COLUMN,43,Description COLUMN,44,Department Group COLUMN,45,Aa Trtype Id COLUMN,46,Description COLUMN,47,Own Description COLUMN,48,Rechtseinheit COLUMN,49,Betrieb COLUMN,50,Marke COLUMN,51,Betrag COLUMN,52,Mandant COLUMN,53,Menge COLUMN,54,Text COLUMN,55,Order Number COLUMN,56,Line Number COLUMN,57,Inv Time COLUMN,58,Inv Time Int COLUMN,59,Make Time Unit COLUMN,60,Site COLUMN,61,KST COLUMN,62,Model Line_vpp5q COLUMN,63,Mod Lin Specify_vpp5q COLUMN,64,Kostenträger_mit_Bez_ COLUMN,65,Kostenträger COLUMN,66,Customer Number COLUMN,67,Customer Group COLUMN,68,Absatzkanal COLUMN,69,GuV_Bilanz COLUMN,70,Susa COLUMN,71,Ebene31 COLUMN,72,Marke für Kostenträger COLUMN,73,Kostenträger_mit_Bez COLUMN,74,ACCT_Detail COLUMN,75,Buchungen ohne Marke COLUMN,76,Buchungen ohne KST COLUMN,77,Buchungen ohne Absatzkanal COLUMN,78,Destination COLUMN,79,Marke_mit_Bez COLUMN,80,Kostenträger_Korrektur COLUMN,81,Konto_mit_KST COLUMN,82,Konto_Nr_Händler COLUMN,83,Make_ COLUMN,84,Strategic Area COLUMN,85,Strategic_Area_2 COLUMN,86,Make fehlt COLUMN,87,Konto_ COLUMN,88,Skr51 Product Group COLUMN,89,Skr51 Product Group_ZK COLUMN,90,Sub Acct No COLUMN,91,Sub_Acct_No_1