GAPS/Portal/System/IQD/Belege/GuV_8_O21_SKR_STK.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21_SKR51
DATASOURCENAME,D:\Gaps\Portal\System\IQD\Belege\GuV_8_O21_SKR_STK.imr
TITLE,GuV_8_O21_SKR_STK.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 ((T1."ACCT_NR" LIKE '2%') and (T2."SITE" IS NULL)) 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 ((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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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) THEN ('00') ELSE (T2."DESTINATION") END as c69,
	   '3' as c70,
	   (od_left(T1."ACCT_NR",1)) as c71,
	   CASE WHEN (((substring((CASE WHEN (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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 ((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 ((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 ((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 ((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 ((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 ((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 ((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 ((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 ((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 ((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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (T2."DEPARTMENT") END) from 1 for 2)) || (CASE WHEN (T2."DESTINATION" IS NULL) THEN ('00') ELSE (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 ((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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (T2."DEPARTMENT") END) = '00') THEN ('ohne KST') ELSE ('mit KST') END as c77,
	   CASE WHEN ((CASE WHEN (T2."DESTINATION" IS NULL) THEN ('00') ELSE (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 ((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 ((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 ((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 ((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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (T2."DEPARTMENT") END) from 1 for 1))) ELSE ((rtrim(T1."ACCT_NR"))) END as c82,
	   (substring('00' || (truncate((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 ((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))) from char_length('00' || (truncate((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 ((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)))) - 2 + 1 for 2)) || '-' || (substring('00' || (truncate((CASE WHEN ((T1."ACCT_NR" LIKE '2%') and (T2."SITE" IS NULL)) THEN ('01') ELSE ((od_left(T2."SITE",2))) END))) from char_length('00' || (truncate((CASE WHEN ((T1."ACCT_NR" LIKE '2%') and (T2."SITE" IS NULL)) THEN ('01') ELSE ((od_left(T2."SITE",2))) END)))) - 2 + 1 for 2)) || '-' || (rtrim(T1."ACCT_NR")) || '-' || (substring('00' || (truncate((CASE WHEN (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (T2."DEPARTMENT") END))) from char_length('00' || (truncate((CASE WHEN (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (T2."DEPARTMENT") END)))) - 2 + 1 for 2)) || '-' || (substring('00' || (truncate((CASE WHEN (T2."DESTINATION" IS NULL) THEN ('00') ELSE (T2."DESTINATION") END))) from char_length('00' || (truncate((CASE WHEN (T2."DESTINATION" IS NULL) THEN ('00') ELSE (T2."DESTINATION") END)))) - 2 + 1 for 2)) || '-' || (substring('00' || (truncate((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))) from char_length('00' || (truncate((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)))) - 2 + 1 for 2)) || '_STK' as c83,
	   (rtrim(T1."ACCT_NR")) || '_STK' as c84,
	   T2."MAKE" as c85,
	   (ucase(T2."STRATEGIC_AREA")) as c86,
	   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 c87,
	   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 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')) and ((od_left(T1."ACCT_NR",1)) IN ('5','8'))) and ((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 (T2."DEPARTMENT" = '    ') THEN ('00') ELSE (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) <> 0))

END SQL
COLUMN,0,Acct Nr_ori
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,Betrag
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,Acct Nr
COLUMN,84,Make_
COLUMN,85,Strategic Area
COLUMN,86,Strategic_Area_2
COLUMN,87,Make fehlt
COLUMN,88,Skr51 Product Group
COLUMN,89,Skr51 Product Group_ZK
COLUMN,90,Sub Acct No
COLUMN,91,Sub_Acct_No_1