ABAP SQL现在支持新的货币转换函数currency_conversion。 示例, DATAcurrencyTYPEc LENGTH5VALUE'USD'. ...SELECTFROMdemo_pricesFIELDSid, currency_conversion( amount=amount, source_currency=currency, target_currency=@currency, exchange_rate_date= @sy-datlo, round='X', on_error=@sql_currency_conversion=...
DATA currency TYPE c LENGTH 5 VALUE 'USD'. ...SELECT FROM demo_prices FIELDS id, currency_conversion( amount = amount, source_currency = currency, target_currency = @currency, exchange_rate_date = @sy-datlo, round = 'X', on_error = @sql_currency_conversion=>c_on_error-fail ) AS ...
with parameters to_currency:abap.cuky(5), exc_date:abap.dats as select from demo_prices { id, currency_conversion( amount => amount, source_currency => currency, round => 'X', target_currency => :to_currency, exchange_rate_date => :exc_date, error_handling => 'SET_TO...
| |--CX_SY_UNKNOWN_CURRENCY //此处不允许使用 ISO 货币码 | | | |--CX_SY_WRITE_INVALID_STYLE //当前上下文中不允许输出样式 '&STYLE&' | | | |--CX_SY_WRITE_SRC_LINE_TOO_LONG //源代码行编号 '&LINE&' 的行长度 '&LENGTH&' 无效。 | | | |--CX_TRANSFORMATION_ERROR //命令 CALL ...
Solved: Hi All, I am passing the value of wrbtr to an output screen field d_debit which is of type currency. while passing the value to d_debit gives me a runtime error
CE_CONVERSION ( :PRICES, [ family = 'currency', method = 'ERP', steps = 'shift,convert,shift_back', target_unit = :TO_CURRENCY, client = :MANDT, source_unit_column = "CURRENCY", reference_date = :DATE, output_unit_column = "CURRENCY", error_handling = 'keep unconve...
机构VTWEG: 分销渠道VSTEL: 装运点/接收点LIFNR: 供应商帐号KUNNR: 客户的帐户编号AGR_TCODES:将角色分配到事务代码(角色与事务关系表)AGR_USERS:分配角色到用户(角色与用户关系表)CDHDR: 更改凭证抬头CDPOS: 更改凭证项目14.小币种处理(小币种转换)CALL FUNCTION CURRENCY_CONVERTING_FACTOR EXPORTING currency = ...
currency_conversion( amount => amount, source_currency => currency, round => 'X', target_currency => :to_currency, exchange_rate_date => :exc_date, error_handling => 'SET_TO_NULL' ) as amount, :to_currency as currency } Parameter views ...
CX_CONVERSION_NO_DURATION - - C1 X X Released CX_CORR_DYN_ERROR - - C1 X X Released CX_CREATE_MEM_DUMP_ERROR - - C1 X Released CX_CRL_RUNTIME_EXCEPTION - - C1 X Released CX_DHAPE_EXIT - - C1 X Released CX_DYNAMIC_CHECK - - C1 X X Released CX_EXCHANGE_RATES - -...
客户的帐户编号 AGR_TCODES:将角色分配到事务代码(角色与事务关系表) AGR_USERS:分配角色到用户(角色与用户关系表) CDHDR: 更改凭证抬头 CDPOS: 更改凭证项目 14.小币种处理(小币种转换) CALL FUNCTION CURRENCY_CONVERTING_FACTOR EXPORTING currency = IMPORTING FACTOR = EXCEPTIONS TOO_MANY_DECIMALS = 1 OTHERS...