COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GlobalCube\SYSTEM\OPTIMA\IQD\belege\GuV_8_O21_SKR_Umsatz_Belege.imr
TITLE,GuV_8_O21_SKR_Umsatz_Belege.imr
BEGIN SQL
select (CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END))) as c1,
	   T2."LEDGER_ACCTS_NAME" as c2,
	   T2."LEDGER_ACCTS_NAME2" as c3,
	   T1."BOOKKEEP_DATE" as c4,
	   '1' as c5,
	   CASE WHEN ((((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_left(T1."SITE",2))) END as c6,
	   CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END as c7,
	   T1."DEBIT_AMOUNT" + T1."CREDIT_AMOUNT" as c8,
	   T1."SITE" as c9,
	   CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END as c10,
	   T3."MODEL_LINE" as c11,
	   T3."MOD_LIN_SPECIFY" as c12,
	   CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END as c13,
	   (substring((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END) from 1 for 2)) as c14,
	   T4."CUSTOMER_NUMBER" as c15,
	   T5."CUSTOMER_GROUP" as c16,
	   CASE WHEN (T1."DESTINATION" IS NULL) THEN ('00') ELSE (T1."DESTINATION") END as c17,
	   T2."TYPE_ACCTT" as c18,
	   (od_left(T1."ACCT_NO",1)) as c19,
	   CASE WHEN (((substring((CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END) from 1 for 1)) = '1') and (not ((substring((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END) from 1 for 2))) IN ('00'))) THEN ('Neuwagen') WHEN (((substring((CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END) from 1 for 1)) = '2') and (not ((substring((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END) from 1 for 2))) IN ('00'))) THEN ('Gebrauchtwagen') WHEN (((substring((CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END) from 1 for 1)) = '3') and (not ((substring((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END) from 1 for 2))) IN ('00'))) THEN ('Teile & Zubehör') WHEN (((substring((CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END) from 1 for 1)) = '4') and (not ((substring((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END) from 1 for 2))) IN ('00'))) THEN ('Service') ELSE ('Ohne Kostenträger') END as c20,
	   CASE WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('OP')) THEN ('OP') WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('VW')) THEN ('VW') ELSE null END as c21,
	   CASE WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('OP')) THEN ((CASE WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('OP')) THEN ('OP') WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('VW')) THEN ('VW') ELSE null END) || (CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END)) WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('VW')) THEN ((CASE WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('OP')) THEN ('OP') WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('VW')) THEN ('VW') ELSE null END) || (CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END)) ELSE ((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END)) END as c22,
	   (substring(((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) from 1 for 4)) || '-' || (CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) || (od_left(T1."SITE",2)) || (substring((CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END) from 1 for 2)) || (CASE WHEN (T1."DESTINATION" IS NULL) THEN ('00') ELSE (T1."DESTINATION") END) || ((substring((CASE WHEN (T3."MODEL_LINE" IS NOT NULL) THEN (T3."MODEL_LINE" || ' - ' || T3."MOD_LIN_SPECIFY") WHEN (T1."PRODUCT_GROUP" IS NOT NULL) THEN (T1."PRODUCT_GROUP") WHEN (T1."REPAIR_GROUP" IS NOT NULL) THEN (T1."REPAIR_GROUP") ELSE ('00 - ohne') END) from 1 for 2))) as c23,
	   CASE WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) = '00') THEN ('ohne Marke') ELSE ('mit Marke') END as c24,
	   CASE WHEN ((CASE WHEN (T1."DEPARTMENT" = '    ') THEN ('00') ELSE (T1."DEPARTMENT") END) = '00') THEN ('ohne KST') ELSE ('mit KST') END as c25,
	   CASE WHEN ((CASE WHEN (T1."DESTINATION" IS NULL) THEN ('00') ELSE (T1."DESTINATION") END) = '00') THEN (('ohne Absatzkanal')) ELSE ('mit Absatzkanal') END as c26,
	   T1."DESTINATION" as c27,
	   CASE WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('00')) THEN ('00 - ohne Marke') WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('OP')) THEN ('OP - Opel') WHEN ((CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) IN ('99')) THEN ('99 - Fremd') ELSE null END as c28,
	   T1."STRATEGIC_AREA" as c29,
	   CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END as c30,
	   (T1."DEBIT_AMOUNT" + T1."CREDIT_AMOUNT") * -1 as c31,
	   T6."Hauptbetrieb_ID" as c32,
	   T6."Hauptbetrieb_Name" as c33,
	   T6."Standort_ID" as c34,
	   T6."Standort_Name" as c35,
	   (CASE WHEN ((T1."MAKE" IS NULL) or ((T1."MAKE" = '  ') and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%'))) THEN ('00') WHEN ((T1."MAKE" IN ('OP')) and (not ((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%')) THEN (T1."MAKE") WHEN (((CASE WHEN ((T1."MAKE" IS NULL) or ((rtrim(T1."MAKE")) = '')) THEN ('00') ELSE ((rtrim(T1."MAKE"))) END) || '-' || (CASE WHEN ((((rtrim(T2."ACCT_NR"))) LIKE '2%') and (T1."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T1."SITE",2)),2))) END) || '-' || ((rtrim(T2."ACCT_NR"))) || '-' || (CASE WHEN ((T1."DEPARTMENT" IS NULL) or ((rtrim(T1."DEPARTMENT")) = '')) THEN ('00') ELSE ((rtrim(T1."DEPARTMENT"))) END) || '-' || (CASE WHEN ((T1."DESTINATION" IS NULL) or ((rtrim(T1."DESTINATION")) = '')) THEN ('00') ELSE ((od_right('00' || (rtrim(T1."DESTINATION")),2))) END) || '-' || ((truncate(CASE WHEN ((T3."MODEL_LINE" IS NOT NULL) and (T3."MODEL_LINE" <> '')) THEN (T3."MODEL_LINE") WHEN ((T1."PRODUCT_GROUP" IS NOT NULL) and (T1."PRODUCT_GROUP" <> '')) THEN (T1."PRODUCT_GROUP") WHEN ((T1."REPAIR_GROUP" IS NOT NULL) and (T1."REPAIR_GROUP" <> '')) THEN (T1."REPAIR_GROUP") ELSE ('00') END)))) LIKE '4%') THEN ((CASE WHEN (T1."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') ELSE ('00') END)) ELSE ('99') END) as c36
from "OPTIMA"."import"."ACCOUNT_INFO" T2,
	(("OPTIMA"."import"."ACCT_DOC_KEY" T1 left outer join "OPTIMA"."import"."vPP5Q" T3 on (T1."MODEL_LINE" = T3."MODEL_LINE") and (T1."MAKE" = T3."MAKE_CD")) left outer join "OPTIMA"."data"."GC_Department" T6 on (T1."CLIENT_DB" = T6."Hauptbetrieb") and (T1."SITE" = T6."Site")),
	(("OPTIMA"."import"."ACCT_DOC_DATA" T7 left outer join "OPTIMA"."import"."ACCT_DOC_SALESCLAS" T4 on T7."REFERENCE_IDENT" = T4."REFERENCE_IDENT") left outer join "OPTIMA"."import"."CUSTOMER" T5 on T5."CUSTOMER_NUMBER" = T4."CUSTOMER_NUMBER")
where (T2."ACCT_NR" = T1."ACCT_NO") and (T1."UNIQUE_IDENT" = T7."REFERENCE_IDENT")
and ((T2."TYPE_ACCTT" = '2') and (T1."ACCT_NO" LIKE '8%'))

END SQL
COLUMN,0,Acct Nr
COLUMN,1,Ledger Accts Name
COLUMN,2,Ledger Accts Name2
COLUMN,3,Bookkeep Date
COLUMN,4,Rechtseinheit
COLUMN,5,Betrieb
COLUMN,6,Marke
COLUMN,7,Betrag
COLUMN,8,Site
COLUMN,9,KST
COLUMN,10,Model Line_vpp5q
COLUMN,11,Mod Lin Specify_vpp5q
COLUMN,12,Kostenträger_mit_Bez_
COLUMN,13,Kostenträger
COLUMN,14,Customer Number
COLUMN,15,Customer Group
COLUMN,16,Absatzkanal
COLUMN,17,GuV_Bilanz
COLUMN,18,Susa
COLUMN,19,Ebene31
COLUMN,20,Marke für Kostenträger
COLUMN,21,Kostenträger_mit_Bez
COLUMN,22,ACCT_Detail
COLUMN,23,Buchungen ohne Marke
COLUMN,24,Buchungen ohne KST
COLUMN,25,Buchungen ohne Absatzkanal
COLUMN,26,Destination
COLUMN,27,Marke_mit_Bez
COLUMN,28,Strategic Area
COLUMN,29,Marke_Strategic_Area
COLUMN,30,Umsatz_FIBU_gesamt
COLUMN,31,Hauptbetrieb Id
COLUMN,32,Hauptbetrieb Name
COLUMN,33,Standort Id
COLUMN,34,Standort Name
COLUMN,35,Fabrikat