RFIMPNBS SAP ABAP Report - Upload Exchange Rates from ECB
RFIMPNBS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Companies that are required to use the exchange rates published by the European Central Bank (ECB) for currency translation can use this report for the following purposes: By setting up an RFC connection between the Web site of the ECB and the SAP system, the report connects directly to the Web site and imports the exchange rates of a given date into the Customizing activity
If you would like to execute this report or see the full code listing simply enter RFIMPNBS into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
RFIMPECB - Import of ECB Exchange Rates
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT RFIMPNBS. "Basic submit
SUBMIT RFIMPNBS AND RETURN. "Return to original report after report execution complete
SUBMIT RFIMPNBS VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: GP_DATE = Date in Data Source
Selection Text: GP_DEST = D .
Selection Text: GP_DEV = D .
Selection Text: GP_FILAS = D .
Selection Text: GP_FILPC = D .
Selection Text: GP_KURST = D .
Selection Text: GP_MOVDT = D .
Selection Text: GP_TCURR = D .
Selection Text: GP_TEST = D .
Selection Text: GSO_FCUR = D .
Selection Text: RB_AS = Application Server
Selection Text: RB_PC = Local Workstation
Selection Text: RB_WWW = RFC Destination
Title: Upload Exchange Rates from ECB
Text Symbol: RB3 = Local Workstation
Text Symbol: RB2 = Application Server
Text Symbol: RB1 = RFC Destination
Text Symbol: E17 = Missing exchange rate for ISO code
Text Symbol: E16 = Missing ISO code in table TCURC
Text Symbol: E14 = Invalid notation
Text Symbol: E13 = Missing records in table TCURN
Text Symbol: E12 = - element does not exist in data source
Text Symbol: 001 = TEST RUN
Text Symbol: 002 = Date in data source:
Text Symbol: 003 = Exchange rate type:
Text Symbol: 004 = To currency:
Text Symbol: 005 = UPDATE RUN
Text Symbol: 006 = Valid for next day:
Text Symbol: 008 = Variance in percent:
Text Symbol: 009 = Data source:
Text Symbol: 010 = Exchange Rates from ECB
Text Symbol: 011 = Number of exchange rates:
Text Symbol: 012 = (see spool request)
Text Symbol: B01 = General Data
Text Symbol: B03 = Data Source
Text Symbol: E03 = Fill required field
Text Symbol: E04 = In data source there are no valid data for date
Text Symbol: E05 = Connection error:
Text Symbol: E06 = Communication error:
Text Symbol: E07 = Message:
Text Symbol: E08 = Different number of valid digits:
Text Symbol: E09 = parse errors have occured:
Text Symbol: E10 = Line:
Text Symbol: E11 = Column:
INCLUDES used within this REPORT RFIMPNBS
INCLUDE EMSG.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = gc_filename parameter_1 = sy-cprog CHANGING physical_filename = p_file EXCEPTIONS logical_filename_not_found = 1 validation_failed = 2 OTHERS = 3.
VIEW_AUTHORITY_CHECK CALL FUNCTION 'VIEW_AUTHORITY_CHECK' EXPORTING view_name = 'V_TCURR' EXCEPTIONS invalid_action = 1 no_authority = 2 no_clientindependent_authority = 3 table_not_found = 4 no_linedependent_authority = 5 OTHERS = 6.
BAPI_EXCHRATE_CREATEMULTIPLE CALL FUNCTION 'BAPI_EXCHRATE_CREATEMULTIPLE' EXPORTING upd_allow = space chg_fixed = space dev_allow = p_dev TABLES exchrate_list = pt_exch_rate return = lt_return.
READ_NOTATION CALL FUNCTION 'READ_NOTATION' EXPORTING foreign_currency = ls_fcurr-waers local_currency = p_tcurr date = l_date IMPORTING notation = l_notation EXCEPTIONS empty_foreign_currency = 1 empty_local_currency = 2 OTHERS = 3.
BAPI_EXCHANGERATE_GETFACTORS CALL FUNCTION 'BAPI_EXCHANGERATE_GETFACTORS' EXPORTING rate_type = p_kurst from_curr = l_curr1 to_currncy = l_curr2 date = l_date IMPORTING from_factor = l_ffact to_factor = l_tfact return = ls_return.
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_callback_program = syst-repid i_structure_name = 'BAPI1093_0' i_save = 'A' is_layout = ls_layout is_variant = ls_variant it_events = lt_events[] is_print = ls_print TABLES t_outtab = pt_exch_rate.
BAL_LOG_CREATE CALL FUNCTION 'BAL_LOG_CREATE' EXPORTING i_s_log = ls_log EXCEPTIONS OTHERS = 1.
BAL_DSP_PROFILE_SINGLE_LOG_GET CALL FUNCTION 'BAL_DSP_PROFILE_SINGLE_LOG_GET' IMPORTING e_s_display_profile = ls_display_profile EXCEPTIONS OTHERS = 1.
BAL_DSP_LOG_DISPLAY CALL FUNCTION 'BAL_DSP_LOG_DISPLAY' EXPORTING i_s_display_profile = ls_display_profile EXCEPTIONS OTHERS = 1.
BAL_LOG_MSG_ADD_FREE_TEXT CALL FUNCTION 'BAL_LOG_MSG_ADD_FREE_TEXT' EXPORTING i_msgty = p_msgtype i_text = p_text EXCEPTIONS log_not_found = 0 OTHERS = 1.
BAL_DB_SAVE CALL FUNCTION 'BAL_DB_SAVE' EXPORTING i_save_all = abap_true EXCEPTIONS log_not_found = 1 save_not_allowed = 2 numbering_error = 3 OTHERS = 4.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RFIMPNBS or its description.