SAP Reports / Programs | Financials | Financial Supply Chain Management | Basic Functions(FIN-FSCM-CLM-CM-CM) SAP FIN

RFEBNO00 SAP ABAP Report - Convert Norwegian Bank Statement to MultiCash Format







RFEBNO00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program &REPORT& converts Norwegian bank statements to Multicash format...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter RFEBNO00 into the relevant SAP transactions such as SE38 or SE80


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 RFEBNO00. "Basic submit
SUBMIT RFEBNO00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFEBNO00 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: PAR_VARI = Variant for Multicash program
Selection Text: PAR_SUBM = Start automatically
Selection Text: PAR_STOP = Key for stopped invoices
Selection Text: PAR_PCUP = Read from PC
Selection Text: PAR_PCDW = Save on PC
Selection Text: PAR_FMT = Format
Selection Text: PAR_FIL3 = Multicash line item file
Selection Text: PAR_FIL2 = Multicash statement file
Selection Text: PAR_FIL1 = Input file
Selection Text: PAR_BVAL = Key for normal invoices
Selection Text: PAR_BLCK = Payment block
Selection Text: PAR_BANK = Bank key (four characters)
Title: Convert Norwegian Bank Statement to MultiCash Format
Text Symbol: 074 = STOPPED
Text Symbol: 073 = STOP ERR
Text Symbol: 072 = STOP OK
Text Symbol: 071 = Customer
Text Symbol: 070 = Vendor
Text Symbol: 060 = Multiple records with same reference but without error code found
Text Symbol: 059 = Bank acc.
Text Symbol: 058 = Warning
Text Symbol: 057 = Result on payment order
Text Symbol: 056 = This file has already been processed, last reference on INDX =
Text Symbol: 055 = Error
Text Symbol: 054 = Payment order not deleted
Text Symbol: 053 = Payment order deleted
Text Symbol: 052 = Deletion mark
Text Symbol: 051 = Check number
Text Symbol: 050 = Partner's account different on bank statement and on payment data
Text Symbol: 049 = Bank number different on bank statement and on payment data
Text Symbol: 101 = Bank selection
Text Symbol: 102 = Input control
Text Symbol: 103 = Output control
Text Symbol: 104 = Access Multicash program
Text Symbol: 105 = Impact on payment
Text Symbol: 110 = File selection
Text Symbol: 155 = Reply record requires 'AH1' and 'TBR' code, file contains
Text Symbol: 200 = The following autogiro statements could not be executed by BBS.





Text Symbol: H01 = Reception of bank statement ( DATA DIALOG format )
Text Symbol: H02 = Processed file :
Text Symbol: H03 = Processed records :
Text Symbol: H04 = Ignored records :
Text Symbol: H05 = Processing terminated
Text Symbol: H06 = Processing aborted
Text Symbol: H07 = Total of records :
Text Symbol: H08 = Result of processing for each business transaction :
Text Symbol: H09 = Simulation: NO UPDATING but payment orders deletion allowed
Text Symbol: 024 = Posting date
Text Symbol: 023 = Value date
Text Symbol: 022 = Service identificator
Text Symbol: 021 = Statement number
Text Symbol: 020 = Currency
Text Symbol: 019 = Account number
Text Symbol: 018 = Bank key
Text Symbol: 017 = Null Amounts on UD20 or no UD20 record
Text Symbol: 015 = Uncorrect service identificator
Text Symbol: 014 = Uncorrect version number
Text Symbol: 013 = Uncorrect type of record for this service identificator
Text Symbol: 012 = Number of records or amount differ from those calculated
Text Symbol: 011 = Uncorrect type of record
Text Symbol: 010 = Error msg
Text Symbol: 009 = Other reference
Text Symbol: 008 = Invoice number
Text Symbol: 007 = Electronic bank statement
Text Symbol: 006 = Rejected ?
Text Symbol: 005 = Record contents
Text Symbol: 004 = Processed ?
Text Symbol: 003 = Aborted
Text Symbol: 002 = Processed
Text Symbol: 001 = Ignored
Text Symbol: 025 = Amount
Text Symbol: 048 = Bank account different on bank statement and on payment data
Text Symbol: 047 = Payment data not found for this transaction
Text Symbol: 046 = Payment order not found
Text Symbol: 045 = Bank reference
Text Symbol: 044 = Payment not stopped
Text Symbol: 043 = Payment stopped





Text Symbol: 042 = Number of transactions with posting
Text Symbol: 041 = Ending balance
Text Symbol: 040 = Credits
Text Symbol: 039 = Debits
Text Symbol: 038 = Beginning balance
Text Symbol: 037 = Message text
Text Symbol: 036 = Message code
Text Symbol: 035 = Message type
Text Symbol: 034 = Datadialog result
Text Symbol: 033 = Statement date
Text Symbol: 032 = Receipt by bank not OK
Text Symbol: 031 = Receipt by bank OK
Text Symbol: 030 = Business transaction code
Text Symbol: 029 = F.year/C.code
Text Symbol: 028 = Document number
Text Symbol: 027 = Payment order
Text Symbol: 026 = Payment reference


INCLUDES used within this REPORT RFEBNO00

INCLUDE RFEBKAT9.
INCLUDE RFEBNOI0.


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 CHANGING physical_filename = par_fil1 EXCEPTIONS OTHERS = 1.

WS_QUERY CALL FUNCTION 'WS_QUERY' EXPORTING filename = par_fil1 query = 'FE' "abbrev. for 'file exists'

FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = gc_filename CHANGING physical_filename = par_fil1 EXCEPTIONS OTHERS = 1.

GUI_UPLOAD CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = uc_string filetype = 'ASC' IMPORTING filelength = ui_filelength TABLES data_tab = up_052 EXCEPTIONS OTHERS.

GUI_UPLOAD CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = uc_string filetype = 'ASC' IMPORTING filelength = ui_filelength TABLES data_tab = up_080 EXCEPTIONS OTHERS.

GUI_UPLOAD CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = uc_string filetype = 'ASC' IMPORTING filelength = ui_filelength TABLES data_tab = up_120 EXCEPTIONS OTHERS.

GUI_UPLOAD CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = uc_string filetype = 'ASC' IMPORTING filelength = ui_filelength TABLES data_tab = up_320 EXCEPTIONS OTHERS.

CURRENCY_CODE_ISO_TO_SAP CALL FUNCTION 'CURRENCY_CODE_ISO_TO_SAP' EXPORTING iso_code = dtatno01-paycu IMPORTING sap_code = hlp_wcode.

CURRENCY_CODE_ISO_TO_SAP CALL FUNCTION 'CURRENCY_CODE_ISO_TO_SAP' EXPORTING iso_code = dtatno01-invcu IMPORTING sap_code = hlp_wcode.




DATUMSAUFBEREITUNG * CALL FUNCTION 'DATUMSAUFBEREITUNG' * EXPORTING * IDATE = sy-datum * IMPORTING * TDAT6 = auszug-azdat.

REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_buffer_active = ' ' i_callback_program = g_repid i_save = g_save is_variant = g_variant it_fieldcat = gt_fieldcat[] it_events = gt_events[] TABLES t_outtab = gt_outtab EXCEPTIONS program_error = 1 OTHERS = 2.

REUSE_ALV_HIERSEQ_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_HIERSEQ_LIST_DISPLAY' EXPORTING i_callback_program = g_repid i_callback_pf_status_set = g_pf_formname i_callback_user_command = 'REACT_ON_USER_COMMAND_LIST' i_save = g_save it_sort = gt_sort[] is_variant = g_variant is_layout = gs_layout it_fieldcat = gt_fieldcat[] it_events = gt_events[] i_tabname_header = g_tabname_header i_tabname_item = g_tabname_item is_keyinfo = gs_keyinfo TABLES t_outtab_header = gt_auszug t_outtab_item = gt_umsatz EXCEPTIONS program_error = 1 OTHERS = 2.

REUSE_ALV_EVENTS_GET CALL FUNCTION 'REUSE_ALV_EVENTS_GET' EXPORTING i_list_type = 0 IMPORTING et_events = lt_events EXCEPTIONS list_type_wrong.

REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = gt_list_top_of_page.

CONVERSION_EXIT_ALPHA_INPUT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT' EXPORTING INPUT = up_ktonr IMPORTING OUTPUT = up_ktonr.

DB_COMMIT CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT CALL FUNCTION 'DB_COMMIT'.

CONVERT_BANK_ACCOUNT_NUMBER CALL FUNCTION 'CONVERT_BANK_ACCOUNT_NUMBER' EXPORTING i_banks = reguh-zbnks i_bankk = reguh-zbnky i_bankn = reguh-zbnkn i_bkont = reguh-zbkon i_bkref = reguh-bkref i_bankl = reguh-zbnkl IMPORTING e_bankn_long = hlp_account.

READ_IBAN_FROM_DB CALL FUNCTION 'READ_IBAN_FROM_DB' EXPORTING i_banks = reguh-zbnks i_bankl = reguh-zbnky i_bankn = reguh-zbnkn i_bkont = reguh-zbkon i_bkref = reguh-bkref IMPORTING e_iban = up_ziban e_iban_valid_from = hlp_date.

GET_BANK_ACCOUNT CALL FUNCTION 'GET_BANK_ACCOUNT' EXPORTING i_bankl = up_bank i_bnkn2 = up_acct_2 IMPORTING e_t012 = t012 e_t012k = t012k EXCEPTIONS bank_account_not_found = 2 multiple_bank_account = 7 OTHERS = 8.

GET_BANK_ACCOUNT CALL FUNCTION 'GET_BANK_ACCOUNT' EXPORTING i_bankl = up_bank i_bnkn2 = up_acct_2 i_waers = up_waer IMPORTING e_t012 = t012 e_t012k = t012k EXCEPTIONS bank_account_not_found = 2 multiple_bank_account = 7 OTHERS = 8.

CURRENCY_CODE_SAP_TO_ISO CALL FUNCTION 'CURRENCY_CODE_SAP_TO_ISO' "ak080998: due to EXPORTING "change in MultiCash sap_code = t012k-waers IMPORTING iso_code = waers.

GET_BANK_ACCOUNT CALL FUNCTION 'GET_BANK_ACCOUNT' EXPORTING i_bankl = up_bank i_bankn = up_acct IMPORTING e_t012 = t012 e_t012k = t012k EXCEPTIONS bank_account_not_found = 2 multiple_bank_account = 7 OTHERS = 8.

GET_BANK_ACCOUNT CALL FUNCTION 'GET_BANK_ACCOUNT' EXPORTING i_bankl = up_bank i_bankn = up_acct IMPORTING e_t012 = t012 e_t012k = t012k EXCEPTIONS multiple_bank_account = 7 OTHERS = 8.

GET_BANK_ACCOUNT CALL FUNCTION 'GET_BANK_ACCOUNT' EXPORTING i_bankl = up_bank i_bankn = up_acct i_waers = up_waer IMPORTING e_t012 = t012 e_t012k = t012k EXCEPTIONS bank_account_not_found = 2 multiple_bank_account = 7 OTHERS = 8.

CURRENCY_CODE_SAP_TO_ISO CALL FUNCTION 'CURRENCY_CODE_SAP_TO_ISO' "ak080998: due to EXPORTING "change in MultiCash sap_code = t012k-waers IMPORTING iso_code = waers.

FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = gc_filename CHANGING physical_filename = par_fil2 EXCEPTIONS OTHERS = 1.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = uc_string * MODE = 'ASC' TABLES data_tab = tab_auszug EXCEPTIONS OTHERS.

FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = gc_filename CHANGING physical_filename = par_fil3 EXCEPTIONS OTHERS = 1.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = uc_string * MODE = 'ASC' TABLES data_tab = tab_umsatz EXCEPTIONS OTHERS.

WS_FILENAME_GET CALL FUNCTION 'WS_FILENAME_GET' EXPORTING def_filename = ' ' def_path = ' ' mask = ',*.*,*.*.'

WS_FILENAME_GET CALL FUNCTION 'WS_FILENAME_GET' EXPORTING def_filename = ' ' def_path = ' ' mask = ',*.*,*.*.'

DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING dyname = 'RFEBNO00' dynumb = '1000' translate_to_upper = ' ' TABLES dynpfields = up_tab EXCEPTIONS OTHERS.

CONVERSION_EXIT_ALPHA_INPUT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT' EXPORTING INPUT = pyord IMPORTING OUTPUT = l_pyord.



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 RFEBNO00 or its description.