Hallo, das Feld ist char, habe es auch als 273 gecastet bringt aber auch nichts.

Anbei mal das create view

CREATE VIEW PLANZ AS SELECT ALL T01.STMOAN AS JM, T01.STKTO AS VKL,
T01.STTENR AS KND, DEC(1, 2, 0) AS FIRMA, DEC(0, 2, 0) AS ABKZ, CAST
(SUM(CASE WHEN STPLIS = 1 THEN STWT02 ELSE 0 END) AS DEC(10, 3)) PL
AN, CAST(SUM(CASE WHEN STPLIS = 2 THEN STWT02 ELSE 0 END) AS DEC(10,
3)) IST, CAST( (SUBSTR(DIGITS(T01.STMOAN), 1, 4) || SUBSTR(DIGITS(T
01.STMOAN), 5, 2) || '01') AS CHAR(8) CCSID 273) AS DATUM, SUBSTR(DI
GITS(T01.STMOAN), 1, 4) AS JAHR, SUBSTR(DIGITS(T01.STMOAN), 5, 2) AS
MONAT FROM STA01PF T01, ADR01PF T02 WHERE STFA = 1 AND
STFAKT = 1 AND STMOAN > 201300 AND STVDST = 88 AND STSAAR <> '1' AND
ADABKZ = 0 AND ADKTO = STTENR AND ADSTS = 0 AND ADFA = 1 GROUP BY S
TMOAN, STKTO, STTENR


Hatte das | auch durch concat ersetzt, bringt aber nichts.
GG