1.发生
- Open Sql开发中对金额类型字段进行算术运算会报错
-
The maximum possible number of places in the expression starting with DMBTR is 34 places with 2 decimal places. There can be, however, no more than 31 places and 14 decimal places.
SELECT A~BUKRS,A~BELNR,A~GJAHR,A~BLART,A~BLDAT,A~BUDAT, A~WAERS,A~USNAM,A~PPNAM,A~XBLNR_ALT,B~BUZEI, CASE WHEN T~WAERS = 'VND' THEN B~DMBTR * 100 ELSE B~DMBTR END AS DMBTR, CASE WHEN A~WAERS = 'VND' THEN B~DMBTR * 100 ELSE B~WRBTR END AS WRBTR, B~MWSKZ,B~UMSKZ,B~BSCHL, B~HKONT,T~WAERS AS WAERS_BB, B~SHKZG,B~KOART,B~KUNNR,B~LIFNR,B~ANLN1,B~ANLN2, CASE B~SGTXT WHEN ' ' THEN A~BKTXT ELSE B~SGTXT END AS SGTXT, T~BUTXT AS BUKRS_X, S~TXT50 AS HKONT_X, V~TXT50 AS LOKKT_X, B~LOKKT, U~LTEXT FROM BKPF AS A INNER JOIN BSEG AS B ON A~BELNR EQ B~BELNR AND A~BUKRS = B~BUKRS AND A~GJAHR = B~GJAHR INNER JOIN ACDOCA AS D ON D~RBUKRS = A~BUKRS AND D~BELNR = A~BELNR AND SUBSTRING( D~DOCLN,4,3 ) = B~BUZEI AND D~GJAHR = B~GJAHR AND A~GJAHR EQ B~GJAHR AND A~BUKRS EQ B~BUKRS LEFT JOIN SKAT AS S ON S~SAKNR = B~HKONT AND S~SPRAS EQ '1' LEFT JOIN SKAT AS V ON V~SAKNR = B~LOKKT AND V~SPRAS EQ '쁩' LEFT JOIN T001 AS T ON T~BUKRS = A~BUKRS AND T~SP
-