abap_source_code

CLASS zbc_currency_conversion_hana DEFINITION
  PUBLIC
  FINAL
  CREATE PUBLIC .
  PUBLIC SECTION.
  INTERFACEs if_amdp_marker_hdb.

   types: lt_amount type standard TABLE OF BAPICURR.
   types: ls_amount type line of lt_amount.

    METHODS convert
      IMPORTING
        value(demo_prices) TYPE lt_amount
        value(numRows) type integer
      EXPORTING
      value(et_amount) type lt_amount.

  PROTECTED SECTION.
  PRIVATE SECTION.
ENDCLASS.

CLASS zbc_currency_conversion_hana IMPLEMENTATION.
  METHOD convert BY DATABASE PROCEDURE FOR HDB
	                          LANGUAGE SQLSCRIPT.
    PRICES = select * from demo_prices;
    CE_CONVERSION (
      :PRICES,
      [ family             = 'currency',
        method             = 'ERP',
        steps              = 'shift,convert,shift_back',
        target_unit        = 'EUR',
        client             = '900',
        source_unit_column = 'BAPICURR',
        reference_date     = '01.07.2014',
        output_unit_column = 'BAPICURR',
        error_handling     = 'keep unconverted' ],
      [ amount AS amount ] );
   et_amount = select * from :prices;
ENDMETHOD.
ENDCLASS.