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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GCStruct_SKR
DATASOURCENAME,C:\GlobalCube\SYSTEM\OPTIMA\IQD\belege\Kontenrahmen_Stk_GC_Struct_SKR.imr
TITLE,Kontenrahmen_Stk_GC_Struct_SKR.imr
BEGIN SQL
select T1."KONTO_NR" as c1,
	   T1."KONTO_BEZEICHNUNG" as c2,
	   T1."KONTO_ART" as c3,
	   T1."KOSTENSTELLE" as c4,
	   T1."STK" as c5,
	   T1."KONTO_1" as c6,
	   T1."KONTO_2" as c7,
	   T1."KONTO_3" as c8,
	   T1."KONTO_4" as c9,
	   T1."KONTO_5" as c10,
	   T1."EBENE1" as c11,
	   T1."EBENE2" as c12,
	   T1."EBENE3" as c13,
	   T1."EBENE4" as c14,
	   T1."EBENE5" as c15,
	   T1."EBENE6" as c16,
	   T1."EBENE7" as c17,
	   T1."EBENE8" as c18,
	   T1."EBENE9" as c19,
	   T1."EBENE10" as c20,
	   T1."EBENE11" as c21,
	   T1."EBENE12" as c22,
	   T1."EBENE13" as c23,
	   T1."EBENE14" as c24,
	   T1."EBENE15" as c25,
	   T1."EBENE16" as c26,
	   T1."EBENE17" as c27,
	   T1."EBENE18" as c28,
	   T1."EBENE19" as c29,
	   T1."EBENE20" as c30,
	   T1."EBENE21" as c31,
	   T1."EBENE22" as c32,
	   T1."EBENE23" as c33,
	   T1."EBENE24" as c34,
	   T1."EBENE25" as c35,
	   T1."EBENE26" as c36,
	   T1."EBENE27" as c37,
	   T1."EBENE28" as c38,
	   T1."EBENE29" as c39,
	   T1."EBENE30" as c40,
	   T1."EBENE31" as c41,
	   T1."EBENE32" as c42,
	   T1."EBENE33" as c43,
	   T1."EBENE34" as c44,
	   T1."EBENE35" as c45,
	   T1."EBENE36" as c46,
	   T1."EBENE37" as c47,
	   T1."EBENE38" as c48,
	   T1."EBENE39" as c49,
	   T1."EBENE40" as c50,
	   T1."EBENE41" as c51,
	   T1."EBENE42" as c52,
	   T1."EBENE43" as c53,
	   T1."EBENE44" as c54,
	   T1."EBENE45" as c55,
	   T1."EBENE46" as c56,
	   T1."EBENE47" as c57,
	   T1."EBENE48" as c58,
	   T1."EBENE49" as c59,
	   T1."EBENE50" as c60,
	   T1."EBENE51" as c61,
	   T1."EBENE52" as c62,
	   T1."EBENE53" as c63,
	   T1."EBENE54" as c64,
	   T1."EBENE55" as c65,
	   T1."EBENE56" as c66,
	   T1."EBENE57" as c67,
	   T1."EBENE58" as c68,
	   T1."EBENE59" as c69,
	   T1."EBENE60" as c70,
	   T1."EBENE61" as c71,
	   T1."EBENE62" as c72,
	   T1."EBENE63" as c73,
	   T1."EBENE64" as c74,
	   T1."EBENE65" as c75,
	   T1."EBENE66" as c76,
	   T1."EBENE67" as c77,
	   T1."EBENE68" as c78,
	   T1."EBENE69" as c79,
	   T1."EBENE70" as c80,
	   T1."EBENE71" as c81,
	   T1."EBENE72" as c82,
	   T1."EBENE73" as c83,
	   T1."EBENE74" as c84,
	   T1."EBENE75" as c85,
	   T1."EBENE76" as c86,
	   T1."EBENE77" as c87,
	   T1."EBENE78" as c88,
	   T1."EBENE79" as c89,
	   T1."EBENE80" as c90,
	   (length(T1."KONTO_NR" || 'Z') - 1) as c91,
	   T1."KONTO_ART" as c92,
	   T1."KONTO_ART" as c93,
	   T1."KONTO_NR" || '_STK' as c94,
	   T1."KONTO_NR" || ' - ' || T1."KONTO_BEZEICHNUNG" as c95,
	   (od_left(T1."KONTO_NR",1)) as c96,
	   'verkaufte Stückzahlen' as c97,
	   CASE WHEN ((od_left(T1."KONTO_NR",4)) IN ('8000','8010')) THEN ('Neuwagen') WHEN ((od_left(T1."KONTO_NR",4)) IN ('8410')) THEN ('Service') ELSE ('Gebrauchtwagen') END as c98,
	   T1."EBENE81" as c99,
	   T1."EBENE82" as c100,
	   T1."EBENE83" as c101,
	   T1."EBENE84" as c102,
	   T1."EBENE85" as c103,
	   T1."EBENE86" as c104,
	   T1."EBENE87" as c105,
	   T1."EBENE88" as c106,
	   T1."EBENE89" as c107,
	   T1."EBENE90" as c108
from "Kontenrahmen.csv" T1
where ((od_left(T1."KONTO_NR",4)) IN ('8000','8010','8100','8110','8510','8410'))

END SQL
COLUMN,0,Konto Nr
COLUMN,1,Konto Bezeichnung
COLUMN,2,Konto Art_ori
COLUMN,3,Kostenstelle
COLUMN,4,Stk
COLUMN,5,Konto 1
COLUMN,6,Konto 2
COLUMN,7,Konto 3
COLUMN,8,Konto 4
COLUMN,9,Konto 5
COLUMN,10,Ebene1_ori
COLUMN,11,Ebene2_ori
COLUMN,12,Ebene3
COLUMN,13,Ebene4
COLUMN,14,Ebene5
COLUMN,15,Ebene6
COLUMN,16,Ebene7
COLUMN,17,Ebene8
COLUMN,18,Ebene9
COLUMN,19,Ebene10
COLUMN,20,Ebene11
COLUMN,21,Ebene12
COLUMN,22,Ebene13
COLUMN,23,Ebene14
COLUMN,24,Ebene15
COLUMN,25,Ebene16
COLUMN,26,Ebene17
COLUMN,27,Ebene18
COLUMN,28,Ebene19
COLUMN,29,Ebene20
COLUMN,30,Ebene21
COLUMN,31,Ebene22
COLUMN,32,Ebene23
COLUMN,33,Ebene24
COLUMN,34,Ebene25
COLUMN,35,Ebene26
COLUMN,36,Ebene27
COLUMN,37,Ebene28
COLUMN,38,Ebene29
COLUMN,39,Ebene30
COLUMN,40,Ebene31
COLUMN,41,Ebene32
COLUMN,42,Ebene33
COLUMN,43,Ebene34
COLUMN,44,Ebene35
COLUMN,45,Ebene36
COLUMN,46,Ebene37
COLUMN,47,Ebene38
COLUMN,48,Ebene39
COLUMN,49,Ebene40
COLUMN,50,Ebene41
COLUMN,51,Ebene42
COLUMN,52,Ebene43
COLUMN,53,Ebene44
COLUMN,54,Ebene45
COLUMN,55,Ebene46
COLUMN,56,Ebene47
COLUMN,57,Ebene48
COLUMN,58,Ebene49
COLUMN,59,Ebene50
COLUMN,60,Ebene51
COLUMN,61,Ebene52
COLUMN,62,Ebene53
COLUMN,63,Ebene54
COLUMN,64,Ebene55
COLUMN,65,Ebene56
COLUMN,66,Ebene57
COLUMN,67,Ebene58
COLUMN,68,Ebene59
COLUMN,69,Ebene60
COLUMN,70,Ebene61
COLUMN,71,Ebene62
COLUMN,72,Ebene63
COLUMN,73,Ebene64
COLUMN,74,Ebene65
COLUMN,75,Ebene66
COLUMN,76,Ebene67
COLUMN,77,Ebene68
COLUMN,78,Ebene69
COLUMN,79,Ebene70
COLUMN,80,Ebene71
COLUMN,81,Ebene72
COLUMN,82,Ebene73
COLUMN,83,Ebene74
COLUMN,84,Ebene75
COLUMN,85,Ebene76
COLUMN,86,Ebene77
COLUMN,87,Ebene78
COLUMN,88,Ebene79
COLUMN,89,Ebene80
COLUMN,90,Anzahl Stellen_Konto_Nr
COLUMN,91,Konto Art
COLUMN,92,GuV_Bilanz
COLUMN,93,Acct Nr
COLUMN,94,Konto
COLUMN,95,Susa
COLUMN,96,Ebene1
COLUMN,97,Ebene2
COLUMN,98,Ebene81
COLUMN,99,Ebene82
COLUMN,100,Ebene83
COLUMN,101,Ebene84
COLUMN,102,Ebene85
COLUMN,103,Ebene86
COLUMN,104,Ebene87
COLUMN,105,Ebene88
COLUMN,106,Ebene89
COLUMN,107,Ebene90