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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GCStruct_Modell
DATASOURCENAME,C:\GlobalCube\System\OPTIMA\IQD\belege\SKR51_Uebersetzung_mit_Konto_Gesamt.imr
TITLE,SKR51_Uebersetzung_mit_Konto_Gesamt.imr
BEGIN SQL
select T1."KONTO" as c1,
	   T1."ACCT_NR" as c2,
	   T1."KONTO_BEZEICHNUNG" as c3,
	   T1."GUV_BILANZ" as c4,
	   T1."KONTO_KST" as c5,
	   T1."KONTO_STK" as c6,
	   T1."KONTO_1" as c7,
	   T1."KONTO_2" as c8,
	   T1."KONTO_3" as c9,
	   T1."KONTO_4" as c10,
	   T1."KONTO_5" as c11,
	   T1."EBENE1" as c12,
	   T1."EBENE2" as c13,
	   T1."EBENE3" as c14,
	   T1."EBENE4" as c15,
	   T1."EBENE5" as c16,
	   T1."EBENE6" as c17,
	   T1."EBENE7" as c18,
	   T1."EBENE8" as c19,
	   T1."EBENE9" as c20,
	   T1."EBENE10" as c21,
	   T1."EBENE71" as c22,
	   T1."EBENE72" as c23,
	   T1."EBENE73" as c24,
	   T1."EBENE74" as c25,
	   T1."EBENE75" as c26,
	   T1."EBENE76" as c27,
	   T1."EBENE77" as c28,
	   T1."EBENE78" as c29,
	   T1."EBENE79" as c30,
	   T1."EBENE80" as c31,
	   T1."EBENE81" as c32,
	   T1."EBENE82" as c33,
	   T1."EBENE83" as c34,
	   T1."EBENE84" as c35,
	   T1."EBENE85" as c36,
	   T1."EBENE86" as c37,
	   T1."EBENE87" as c38,
	   T1."EBENE88" as c39,
	   T1."EBENE89" as c40,
	   T1."EBENE90" as c41,
	   T1."KONTO_GRUPPE" as c42,
	   T1."SUSA" as c43,
	   CASE WHEN (T1."GUV_BILANZ" = '2') THEN ((CASE WHEN (((locate('_',T1."KONTO_GRUPPE",1))) = 5) THEN ((od_left(((od_left(T1."KONTO_GRUPPE",((locate('_',T1."KONTO_GRUPPE",1)))))),4))) WHEN (((locate('_',T1."KONTO_GRUPPE",1))) = 6) THEN ((od_left(((od_left(T1."KONTO_GRUPPE",((locate('_',T1."KONTO_GRUPPE",1)))))),5))) ELSE null END) || ' - ' || T1."KONTO_BEZEICHNUNG") ELSE (T1."KONTO_GRUPPE") END as c44,
	   (locate('_',T1."KONTO_GRUPPE",1)) as c45,
	   (od_left(T1."KONTO_GRUPPE",((locate('_',T1."KONTO_GRUPPE",1))))) as c46,
	   CASE WHEN (((locate('_',T1."KONTO_GRUPPE",1))) = 5) THEN ((od_left(((od_left(T1."KONTO_GRUPPE",((locate('_',T1."KONTO_GRUPPE",1)))))),4))) WHEN (((locate('_',T1."KONTO_GRUPPE",1))) = 6) THEN ((od_left(((od_left(T1."KONTO_GRUPPE",((locate('_',T1."KONTO_GRUPPE",1)))))),5))) ELSE null END as c47
from "SKR51_Uebersetzung.csv" T1

END SQL
COLUMN,0,Konto
COLUMN,1,Acct Nr
COLUMN,2,Konto Bezeichnung
COLUMN,3,Guv Bilanz
COLUMN,4,Konto Kst
COLUMN,5,Konto Stk
COLUMN,6,Konto 1
COLUMN,7,Konto 2
COLUMN,8,Konto 3
COLUMN,9,Konto 4
COLUMN,10,Konto 5
COLUMN,11,Ebene1
COLUMN,12,Ebene2
COLUMN,13,Ebene3
COLUMN,14,Ebene4
COLUMN,15,Ebene5
COLUMN,16,Ebene6
COLUMN,17,Ebene7
COLUMN,18,Ebene8
COLUMN,19,Ebene9
COLUMN,20,Ebene10
COLUMN,21,Ebene71
COLUMN,22,Ebene72
COLUMN,23,Ebene73
COLUMN,24,Ebene74
COLUMN,25,Ebene75
COLUMN,26,Ebene76
COLUMN,27,Ebene77
COLUMN,28,Ebene78
COLUMN,29,Ebene79
COLUMN,30,Ebene80
COLUMN,31,Ebene81
COLUMN,32,Ebene82
COLUMN,33,Ebene83
COLUMN,34,Ebene84
COLUMN,35,Ebene85
COLUMN,36,Ebene86
COLUMN,37,Ebene87
COLUMN,38,Ebene88
COLUMN,39,Ebene89
COLUMN,40,Ebene90
COLUMN,41,Konto Gruppe
COLUMN,42,Susa
COLUMN,43,Konto Gesamt
COLUMN,44,_Stelle
COLUMN,45,LINKS (  Konto Gruppe ; _Stelle)
COLUMN,46,Kontonummer