SAP CX_SY_DYNAMIC_OSQL_SEMANTICS 错误

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