C11/System/OPTIMA/IQD/Belege/Kontenrahmen_kombiniert.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GlobalCube\SYSTEM\OPTIMA\IQD\belege\Kontenrahmen_kombiniert.imr
TITLE,Kontenrahmen_kombiniert.imr
BEGIN SQL
select distinct (rtrim(T1."ACCT_NR")) as c1,
	   CASE WHEN (((not T2."MAKE" IN ('OP','PE')) or (T2."MAKE" IS NULL)) or (T2."MAKE" = ' ')) THEN (CASE WHEN (T2."STRATEGIC_AREA" IN ('AUTO      ','Opel      ','OPEL      ')) THEN ('OP') WHEN (T2."STRATEGIC_AREA" IN ('PEUGEOT   ')) THEN ('PE') ELSE ('00') END) ELSE (T2."MAKE") END as c2,
	   CASE WHEN ((((rtrim(T1."ACCT_NR"))) LIKE '2%') and (T2."SITE" IS NULL)) THEN ('01') ELSE ((od_right('00' || (od_left(T2."SITE",2)),2))) END as c3,
	   CASE WHEN ((T2."DEPARTMENT" IS NULL) or ((rtrim(T2."DEPARTMENT")) = '')) THEN ('00') ELSE (T2."DEPARTMENT") END as c4,
	   CASE WHEN ((T2."DESTINATION" = '00') and (T2."PRICE_CODE" <> '')) THEN (T2."PRICE_CODE") WHEN (((T2."DESTINATION" = '00') and (T2."PRICE_CODE" = '')) and (T3."CUSTOMER_GROUP" <> '')) THEN (T3."CUSTOMER_GROUP") WHEN ((rtrim(T2."DESTINATION")) = '') THEN ('00') ELSE (T2."DESTINATION") END as c5,
	   (truncate(CASE WHEN ((T4."MODEL_LINE" IS NOT NULL) and (T4."MODEL_LINE" <> '')) THEN (T4."MODEL_LINE") WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and (T2."PRODUCT_GROUP" <> '')) THEN (T2."PRODUCT_GROUP") WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and (T2."REPAIR_GROUP" <> '')) THEN (T2."REPAIR_GROUP") ELSE ('00') END)) as c6,
	   CASE WHEN ((T4."MODEL_LINE" IS NOT NULL) and (T4."MODEL_LINE" <> '')) THEN ('NW') WHEN ((T2."PRODUCT_GROUP" IS NOT NULL) and (T2."PRODUCT_GROUP" <> '')) THEN ('TZ') WHEN ((T2."REPAIR_GROUP" IS NOT NULL) and (T2."REPAIR_GROUP" <> '')) THEN ('SC') ELSE ('') END as c7
from "OPTIMA"."import"."ACCOUNT_INFO" T1,
	("OPTIMA"."import"."ACCT_DOC_KEY" T2 left outer join "OPTIMA"."import"."vPP5Q" T4 on (T2."MODEL_LINE" = T4."MODEL_LINE") and (T2."MAKE" = T4."MAKE_CD")),
	(("OPTIMA"."import"."ACCT_DOC_DATA" T5 left outer join "OPTIMA"."import"."ACCT_DOC_SALESCLAS" T6 on T5."REFERENCE_IDENT" = T6."REFERENCE_IDENT") left outer join "OPTIMA"."import"."CUSTOMER" T3 on T3."CUSTOMER_NUMBER" = T6."CUSTOMER_NUMBER")
where (T1."ACCT_NR" = T2."ACCT_NO") and (T2."UNIQUE_IDENT" = T5."REFERENCE_IDENT")
and (T2."BOOKKEEP_DATE" >= TIMESTAMP '2020-01-01 00:00:00.000')
order by c1 asc,c3 asc,c4 asc,c2 asc

END SQL
COLUMN,0,Konto_Nr
COLUMN,1,Marke
COLUMN,2,Standort
COLUMN,3,Kostenstelle
COLUMN,4,Absatzkanal
COLUMN,5,Kostenträger
COLUMN,6,Kostenträger_Quelle