C11/System/ARIntelligence/IQD/Belege/Controlling_DKS_Navision.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,DKS
DATASOURCENAME,C:\GAPS_BMW\Portal\System\IQD\Belege\Controlling_DKS_Navision.imr
TITLE,Controlling_DKS_Navision.imr
BEGIN SQL
select T1."B200_FIRMENKURZNAME" as c1,
	   T1."B200_LOESCH_KZ" as c2,
	   T1."B200_KTOART" as c3,
	   T1."B200_KTONR" as c4,
	   T1."B200_GESCHAEFTJAHR" as c5,
	   T1."B200_BELEGBLNR" as c6,
	   T1."B200_BELEGNR1" as c7,
	   T1."B200_BELEGLAUFNR" as c8,
	   T1."B200_BELEGDAT1" as c9,
	   T1."B200_BELEGBLID" as c10,
	   T1."B200_BUCHGDAT" as c11,
	   T1."B200_BUCHGTEXT" as c12,
	   T1."B200_NTOPER" as c13,
	   T1."B200_PERNR" as c14,
	   T1."B200_SHKENNZ" as c15,
	   T1."B200_HW1BUCHGBETR" as c16,
	   T1."B200_BUCHGLFN" as c17,
	   T1."B200_HW2BUCHGBETR" as c18,
	   T1."B200_HW2STEUBASIS_1" as c19,
	   (substring(T2."K400_KTONR" from 5 for 6)) as c20,
	   (cdate(T1."B200_BUCHGDAT")) as c21,
	   CASE WHEN (T1."B200_SHKENNZ" = 'S') THEN (T1."B200_HW1BUCHGBETR" * -1) ELSE (T1."B200_HW1BUCHGBETR") END as c22,
	   CASE WHEN (((substring(T2."K400_KTONR" from 5 for 6))) IN ('0','5','7')) THEN ('1') ELSE (((substring(T2."K400_KTONR" from 5 for 6)))) END as c23,
	   CASE WHEN (T1."B200_GESCHAEFTJAHR" = 'a') THEN ('2008') WHEN (T1."B200_GESCHAEFTJAHR" = 'b') THEN ('2009') WHEN (T1."B200_GESCHAEFTJAHR" = 'c') THEN ('2010') WHEN (T1."B200_GESCHAEFTJAHR" = 'd') THEN ('2011') ELSE null END as c24,
	   (nconvert((CASE WHEN (T1."B200_GESCHAEFTJAHR" = 'a') THEN ('2008') WHEN (T1."B200_GESCHAEFTJAHR" = 'b') THEN ('2009') WHEN (T1."B200_GESCHAEFTJAHR" = 'c') THEN ('2010') WHEN (T1."B200_GESCHAEFTJAHR" = 'd') THEN ('2011') ELSE null END))) as c25,
	   CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END as c26,
	   CASE WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '01') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '02') THEN ('28') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '03') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '04') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '05') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '06') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '07') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '08') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '09') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '10') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '11') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '12') THEN ('31') ELSE null END as c27,
	   (CASE WHEN (T1."B200_GESCHAEFTJAHR" = 'a') THEN ('2008') WHEN (T1."B200_GESCHAEFTJAHR" = 'b') THEN ('2009') WHEN (T1."B200_GESCHAEFTJAHR" = 'c') THEN ('2010') WHEN (T1."B200_GESCHAEFTJAHR" = 'd') THEN ('2011') ELSE null END) || (CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) || (CASE WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '01') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '02') THEN ('28') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '03') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '04') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '05') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '06') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '07') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '08') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '09') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '10') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '11') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '12') THEN ('31') ELSE null END) as c28,
	   (nconvert(((CASE WHEN (T1."B200_GESCHAEFTJAHR" = 'a') THEN ('2008') WHEN (T1."B200_GESCHAEFTJAHR" = 'b') THEN ('2009') WHEN (T1."B200_GESCHAEFTJAHR" = 'c') THEN ('2010') WHEN (T1."B200_GESCHAEFTJAHR" = 'd') THEN ('2011') ELSE null END) || (CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) || (CASE WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '01') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '02') THEN ('28') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '03') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '04') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '05') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '06') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '07') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '08') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '09') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '10') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '11') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '12') THEN ('31') ELSE null END)))) as c29,
	   (cdate(((nconvert(((CASE WHEN (T1."B200_GESCHAEFTJAHR" = 'a') THEN ('2008') WHEN (T1."B200_GESCHAEFTJAHR" = 'b') THEN ('2009') WHEN (T1."B200_GESCHAEFTJAHR" = 'c') THEN ('2010') WHEN (T1."B200_GESCHAEFTJAHR" = 'd') THEN ('2011') ELSE null END) || (CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) || (CASE WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '01') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '02') THEN ('28') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '03') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '04') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '05') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '06') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '07') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '08') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '09') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '10') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '11') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '12') THEN ('31') ELSE null END))))))) as c30,
	   T2."K400_BILANZ_KZ" as c31,
	   (cdate(T1."B200_BELEGDAT1")) as c32,
	   CASE WHEN (T1."B200_KTONR" = '20200') THEN ('20201') WHEN (T1."B200_KTONR" = '20700') THEN ('20701') ELSE (T1."B200_KTONR") END as c33,
	   (now()) as c34,
	   (cdatetime(((cdate(T1."B200_BUCHGDAT"))))) as c35,
	   (extract(DAY FROM ((now())) - ((cdatetime(((cdate(T1."B200_BUCHGDAT")))))))) as c36,
	   CASE WHEN (((extract(DAY FROM ((now())) - ((cdatetime(((cdate(T1."B200_BUCHGDAT"))))))))) <= 100) THEN (T1."B200_BELEGNR1" || ' - ' || T1."B200_BUCHGTEXT") ELSE null END as c37,
	   '1' as c38,
	   '10' as c39
from ("S653FC9D"."F20"."B2" T1 left outer join "S653FC9D"."F20"."K4" T2 on T1."B200_KTONR" = T2."K400_KTONR")
where (((((T1."B200_KTOART" IN ('3')) and (T2."K400_KTOART" IN ('3'))) and (T2."K400_BILANZ_KZ" = 'G')) and ((((((T2."K400_KTONR" LIKE '2%') or (T2."K400_KTONR" LIKE '4%')) or (T2."K400_KTONR" LIKE '7%')) or (T2."K400_KTONR" LIKE '8%')) or (T2."K400_KTONR" LIKE '5%')) or (T2."K400_KTONR" LIKE '6%'))) and (((cdate(((nconvert(((CASE WHEN (T1."B200_GESCHAEFTJAHR" = 'a') THEN ('2008') WHEN (T1."B200_GESCHAEFTJAHR" = 'b') THEN ('2009') WHEN (T1."B200_GESCHAEFTJAHR" = 'c') THEN ('2010') WHEN (T1."B200_GESCHAEFTJAHR" = 'd') THEN ('2011') ELSE null END) || (CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) || (CASE WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '01') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '02') THEN ('28') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '03') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '04') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '05') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '06') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '07') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '08') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '09') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '10') THEN ('31') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '11') THEN ('30') WHEN ((CASE WHEN (T1."B200_PERNR" = 1) THEN ('01') WHEN (T1."B200_PERNR" = 2) THEN ('02') WHEN (T1."B200_PERNR" = 3) THEN ('03') WHEN (T1."B200_PERNR" = 4) THEN ('04') WHEN (T1."B200_PERNR" = 5) THEN ('05') WHEN (T1."B200_PERNR" = 6) THEN ('06') WHEN (T1."B200_PERNR" = 7) THEN ('07') WHEN (T1."B200_PERNR" = 8) THEN ('08') WHEN (T1."B200_PERNR" = 9) THEN ('09') WHEN (T1."B200_PERNR" = 10) THEN ('10') WHEN (T1."B200_PERNR" = 11) THEN ('11') WHEN (T1."B200_PERNR" = 12) THEN ('12') ELSE null END) = '12') THEN ('31') ELSE null END)))))))) <= DATE '2010-12-31'))

END SQL
COLUMN,0,B200 Firmenkurzname
COLUMN,1,B200 Loesch Kz
COLUMN,2,B200 Ktoart
COLUMN,3,B200 Ktonr
COLUMN,4,B200 Geschaeftjahr
COLUMN,5,B200 Belegblnr
COLUMN,6,B200 Belegnr1
COLUMN,7,B200 Beleglaufnr
COLUMN,8,B200 Belegdat1
COLUMN,9,B200 Belegblid
COLUMN,10,B200 Buchgdat
COLUMN,11,B200 Buchgtext
COLUMN,12,B200 Ntoper
COLUMN,13,B200 Pernr
COLUMN,14,B200 Shkennz
COLUMN,15,B200 Hw1buchgbetr
COLUMN,16,B200 Buchglfn
COLUMN,17,B200 Hw2buchgbetr
COLUMN,18,B200 Hw2steubasis 1
COLUMN,19,Betrieb_nr_ori
COLUMN,20,Buchungsdatum_ori
COLUMN,21,Betrag
COLUMN,22,Betrieb_nr
COLUMN,23,Geschäftsjahr
COLUMN,24,GJahr
COLUMN,25,Monat
COLUMN,26,Tag
COLUMN,27,BDatum
COLUMN,28,BDatum Zahl
COLUMN,29,Buchungsdatum
COLUMN,30,K400 Bilanz Kz
COLUMN,31,Belegdatum
COLUMN,32,Konto Nr
COLUMN,33,Heute
COLUMN,34,B_Datum_1
COLUMN,35,Tage
COLUMN,36,Text
COLUMN,37,Rechtseinheit
COLUMN,38,Betrieb