GAPS/Portal/System/IQD/Belege/Kontenrahmen/Kontenrahmen_kombiniert.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\Kontenrahmen\Kontenrahmen_kombiniert.imr
TITLE,Kontenrahmen_kombiniert.imr
BEGIN SQL
select distinct (rtrim(T1."ACCT_NR")) as c1,
	   CASE WHEN (((ucase((rtrim(T2."STRATEGIC_AREA"))))) = 'AUTO') THEN ('ZZ') WHEN (((ucase((rtrim(T2."STRATEGIC_AREA"))))) = 'BAIC') THEN ('1B') WHEN (((ucase((rtrim(T2."STRATEGIC_AREA"))))) = 'ISUZU') THEN ('IZ') WHEN ((((ucase((rtrim(T2."STRATEGIC_AREA"))))) IS NOT NULL) and (((ucase((rtrim(T2."STRATEGIC_AREA"))))) <> '')) THEN ((od_left(((ucase((rtrim(T2."STRATEGIC_AREA"))))),2))) ELSE ('00') END as c2,
	   CASE WHEN ((((rtrim(T2."SITE"))) IS NOT NULL) and (((rtrim(T2."SITE"))) <> '')) THEN (((rtrim(T2."SITE")))) ELSE ('00') END as c3,
	   CASE WHEN ((((rtrim(T2."DEPARTMENT"))) IS NOT NULL) and (((rtrim(T2."DEPARTMENT"))) <> '')) THEN (((rtrim(T2."DEPARTMENT")))) ELSE ('00') END as c4,
	   CASE WHEN (((T2."PRICE_CODE" = '99') and ((rtrim(T2."DESTINATION")) = ' ')) or ((rtrim(T2."DESTINATION")) = '00')) THEN ('99') WHEN ((((rtrim(T2."DESTINATION"))) IS NOT NULL) and (((rtrim(T2."DESTINATION"))) <> '')) THEN (((rtrim(T2."DESTINATION")))) ELSE ('00') END as c5,
	   CASE WHEN ((((rtrim(T2."MODEL_LINE"))) IS NOT NULL) and (((rtrim(T2."MODEL_LINE"))) <> '')) THEN (((rtrim(T2."MODEL_LINE")))) WHEN ((((cast_numberToString(cast_integer(T3."SKR51_PRODUCT_GROUP")))) IS NOT NULL) and (((cast_numberToString(cast_integer(T3."SKR51_PRODUCT_GROUP")))) <> '')) THEN (((cast_numberToString(cast_integer(T3."SKR51_PRODUCT_GROUP"))))) WHEN ((((rtrim(T2."REPAIR_GROUP"))) IS NOT NULL) and (((rtrim(T2."REPAIR_GROUP"))) <> '')) THEN (((rtrim(T2."REPAIR_GROUP")))) ELSE ('00') END as c6,
	   CASE WHEN ((((rtrim(T2."MODEL_LINE"))) IS NOT NULL) and (((rtrim(T2."MODEL_LINE"))) <> '')) THEN ('NW') WHEN ((((cast_numberToString(cast_integer(T3."SKR51_PRODUCT_GROUP")))) IS NOT NULL) and (((cast_numberToString(cast_integer(T3."SKR51_PRODUCT_GROUP")))) <> '')) THEN ('TZ') WHEN ((((rtrim(T2."REPAIR_GROUP"))) IS NOT NULL) and (((rtrim(T2."REPAIR_GROUP"))) <> '')) THEN ('SC') ELSE ('') END as c7
from "deop01"."dbo"."ACCOUNT_INFO" T1,
	("deop01"."dbo"."ACCT_DOC_KEY" T2 left outer join "deop01"."dbo"."vPP65" T3 on T2."PRODUCT_GROUP" = T3."PRODUCT_GROUP")
where (T1."ACCT_NR" = T2."ACCT_NO")
and ((T1."TYPE_ACCTT" IN ('1','2')) and (T2."BOOKKEEP_PERIOD" >= 202001))

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