RFIBANMD SAP ABAP Report - Master data download/upload for external generation of IBAN
RFIBANMD is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program enables the mass generation of the IBAN by exporting a dataset from the SAP system, adding the IBAN by using an external tool, and then re-importing the data to the system...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 RFIBANMD 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
IBANMD - Generate IBAN
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 RFIBANMD. "Basic submit
SUBMIT RFIBANMD AND RETURN. "Return to original report after report execution complete
SUBMIT RFIBANMD 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: P_CHDOC = Create Change Documents
Selection Text: P_DOWN = Download
Selection Text: P_FNAME = File Name and Path
Selection Text: P_FNAMEU = File Name and Path
Selection Text: P_LIST = Detail List
Selection Text: P_LIST0 = No list
Selection Text: P_LISTE = Incorrect Records Only
Selection Text: P_MAXL = Max. Number of Data Records
Selection Text: P_RECCNT = Data Records per File
Selection Text: P_TESTU = Test run
Selection Text: P_UP = Upload
Selection Text: SO_LAND1 = Bank Country
Title: Master data download/upload for external generation of IBAN
Text Symbol: S12 = No bank key found
Text Symbol: S11 = IBAN corrected
Text Symbol: S10 = IBAN checked
Text Symbol: S05 = Account number not valid
Text Symbol: S04 = Account number not found
Text Symbol: S03 = IBAN does not begin with 'DE'
Text Symbol: S02 = Invalid character found
Text Symbol: S01 = No bank ID found
Text Symbol: S00 = Download successful
Text Symbol: P05 = Miscellaneous (Dynamic)
Text Symbol: P04 = Human Resources
Text Symbol: P03 = Business Partner
Text Symbol: P02 = Vendor Master Record
Text Symbol: P01 = Customer Master Record
Text Symbol: P00 = Check Existing IBAN
Text Symbol: M14 = Upload ended incompletely
Text Symbol: M13 = Upload ended successfully
Text Symbol: M12 = No valid data found in file
Text Symbol: S13 = Error during generation
Text Symbol: S14 = IBAN duplicated (&SEQNR)
Text Symbol: S15 = BIC is not correct or missing
Text Symbol: S16 = Master data not found
Text Symbol: S20 = IBAN added
Text Symbol: SD1 = Selecting data
Text Symbol: SD2 = Data is being prepared for output
Text Symbol: SD3 = Data is being written to output file
Text Symbol: SD4 = List is being created
Text Symbol: SU1 = File is being read
Text Symbol: SU2 = Data is being processed
Text Symbol: SU3 = Data is being written to the database
Text Symbol: T01 = (TEST RUN)
Text Symbol: V01 = SIC IBAN-Tool (CH, LI)
Text Symbol: V02 = Miscellaneous
Text Symbol: V03 = IBAN-in-IBAN-out (DE)
Text Symbol: V04 = ISABEL6 (BE)
Text Symbol: V06 = Nordea (FI)
Text Symbol: V07 = IBAN BIC Service (NL)
Text Symbol: L14 = Number of Corrected IBANs
Text Symbol: L13 = Number of IBANs Added
Text Symbol: L12 = Number of IBANs Checked Successfully
Text Symbol: L11 = Number of Records Exported From File
Text Symbol: L04 = No. of Files
Text Symbol: L03 = Number of Incorrect Records
Text Symbol: L02 = Number of Records Written to File
Text Symbol: L01 = Number of Records Selected for Download
Text Symbol: L00 = Operation Overview for Country &LAND
Text Symbol: FI3 = Temporary Contact Person
Text Symbol: FI2 = Service Code
Text Symbol: FI1 = Name of company
Text Symbol: F08 = Field for Validity End
Text Symbol: F07 = Field for IBAN
Text Symbol: F06 = Field for Control Key
Text Symbol: F05 = Field for Account Number
Text Symbol: F04 = Field for Bank Key
Text Symbol: F03 = Field for Bank Country
Text Symbol: F02 = Table Key
Text Symbol: F01 = Database Table
Text Symbol: E01 = Enter a Number Above Zero
Text Symbol: B03 = Output List
Text Symbol: B02 = Process Data
Text Symbol: B01 = Specify Work Area
Text Symbol: B00 = External Procedure
Text Symbol: M04 = Download ended incompletely
Text Symbol: M03 = Download completed successfully
Text Symbol: M02 = No data found for download
Text Symbol: M01 = Enter path and file name
Text Symbol: M00 = Error during access to file
Text Symbol: L99 = New BIC
Text Symbol: L98 = Old BIC
Text Symbol: L97 = Indicator
Text Symbol: L96 = File
Text Symbol: L95 = Line
Text Symbol: L94 = IBAN
Text Symbol: L93 = Old IBAN
Text Symbol: L92 = New IBAN
Text Symbol: L91 = SIC
Text Symbol: L90 = Status
Text Symbol: L89 = Use
Text Symbol: L30 = Activate
Text Symbol: L25 = Table &TABL
Text Symbol: L24 = Generate IBAN for &AREA
Text Symbol: L23 = Check IBAN
Text Symbol: L22 = Upload
Text Symbol: L21 = Download
Text Symbol: L20 = Operation: &CHKG - &ACTN
Text Symbol: L16 = Banks with Missing or Incorrect BIC (SWIFT)
Text Symbol: L15 = Number of Duplicate Records
INCLUDES used within this REPORT RFIBANMD
No INCLUDES are used within this REPORT code!
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 = g_lfilename_down CHANGING physical_filename = p_fname EXCEPTIONS OTHERS = 1.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = g_lfilename_up CHANGING physical_filename = p_fnameu EXCEPTIONS OTHERS = 1.
DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING dyname = sy-cprog dynumb = sy-dynnr TABLES dynpfields = dynp_fields.
KD_GET_FILENAME_ON_F4 CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING static = 'X' fileoperation = 'W' path = g_path_down CHANGING location_flag = p_floca file_name = p_fname.
DYNP_VALUES_UPDATE CALL FUNCTION 'DYNP_VALUES_UPDATE' EXPORTING dyname = sy-cprog dynumb = sy-dynnr TABLES dynpfields = dynp_fields.
DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING dyname = sy-cprog dynumb = sy-dynnr TABLES dynpfields = dynp_fields.
CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING static = 'X' path = g_path_up CHANGING location_flag = p_flocau file_name = p_fnameu.
DYNP_VALUES_UPDATE CALL FUNCTION 'DYNP_VALUES_UPDATE' EXPORTING dyname = sy-cprog dynumb = sy-dynnr TABLES dynpfields = dynp_fields.
FUNCTION_EXISTS CALL FUNCTION 'FUNCTION_EXISTS' EXPORTING funcname = g_tech_accno_check EXCEPTIONS OTHERS = 2.
FUNCTION_EXISTS CALL FUNCTION 'FUNCTION_EXISTS' EXPORTING funcname = g_bupa_update EXCEPTIONS OTHERS = 2.
VRM_SET_VALUES CALL FUNCTION 'VRM_SET_VALUES' EXPORTING id = g_id values = gt_value.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = g_lfilename_up including_dir = 'X' IMPORTING file_name = g_fname_a_up EXCEPTIONS file_not_found = 1 OTHERS = 2.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = g_lfilename_down including_dir = 'X' IMPORTING file_name = g_fname_a_down EXCEPTIONS file_not_found = 1 OTHERS = 2.
CONVERT_BANK_ACCOUNT_NUMBER CALL FUNCTION 'CONVERT_BANK_ACCOUNT_NUMBER' EXPORTING i_banks = wa_master_data-banks i_bankk = wa_master_data-bankl i_bankn = l_bankn18 i_bkont = wa_master_data-bkont i_bkref = '' i_bankl = wa_master_data-bnklz IMPORTING e_bankn_long = gs_swift-bankn.
GUI_UPLOAD CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = l_filename "#EC * filetype = 'ASC' codepage = l_cpage TABLES data_tab = lt_file EXCEPTIONS OTHERS = 22.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = g_lfilename_up CHANGING physical_filename = l_filename EXCEPTIONS OTHERS = 1.
DDIF_NAMETAB_GET CALL FUNCTION 'DDIF_NAMETAB_GET' EXPORTING tabname = l_tabname EXCEPTIONS not_found = 1 OTHERS = 2.
DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = l_tabname langu = sy-langu lfieldname = l_fname all_types = 'X' IMPORTING dfies_wa = dfies_wa EXCEPTIONS OTHERS = 4.
VRM_SET_VALUES CALL FUNCTION 'VRM_SET_VALUES' EXPORTING id = l_id values = lt_value.
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_callback_program = sy-repid "#EC * is_layout = ls_layout it_fieldcat = lt_fieldcat[] it_events = lt_events[] i_save = ' ' TABLES t_outtab =
EXCEPTIONS program_error = 1 OTHERS = 2.
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = lt_list_commentary.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING percentage = i_percentage text = i_text EXCEPTIONS OTHERS = 0.
DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = l_tabname langu = sy-langu lfieldname = l_fname all_types = 'X' IMPORTING dfies_wa = dfies_wa EXCEPTIONS OTHERS = 4.
POST_IBAN CALL FUNCTION 'POST_IBAN' IN UPDATE TASK TABLES itiban = t_iban_new.
SWE_REQUESTER_TO_UPDATE CALL FUNCTION 'SWE_REQUESTER_TO_UPDATE'.
IBAN_WRITE_DOCUMENT CALL FUNCTION 'IBAN_WRITE_DOCUMENT ' IN UPDATE TASK EXPORTING objectid = l_cdhdr-objectid tcode = l_cdhdr-tcode utime = l_cdhdr-utime udate = l_cdhdr-udate username = l_cdhdr-username planned_change_number = l_cdhdr-planchngnr object_change_indicator = l_cdhdr-change_ind o_tiban = l_iold n_tiban = l_inew upd_tiban = l_upd_flg.
SWE_REQUESTER_TO_UPDATE CALL FUNCTION 'SWE_REQUESTER_TO_UPDATE'.
BUPA_BUP_WRITE_DOCUMENT CALL FUNCTION 'BUPA_BUP_WRITE_DOCUMENT' IN UPDATE TASK EXPORTING objectid = l_cdhdr-objectid tcode = l_cdhdr-tcode utime = l_cdhdr-utime udate = l_cdhdr-udate username = l_cdhdr-username planned_change_number = l_cdhdr-planchngnr object_change_indicator = l_cdhdr-change_ind planned_or_real_changes = ' ' no_change_pointers = 'X' o_ybut000 = l_ybut000 n_but000 = l_but000 upd_but000 = upd_but000 o_ybut001 = l_ybut001 n_but001 = l_but001 upd_but001 = upd_but001 upd_but0bk = l_cdhdr-change_ind upd_but0cc = upd_but0cc upd_but0id = upd_but0id upd_but0is = upd_but0is upd_but100 = upd_but100 upd_icdtxt_bupa_bup = upd_icdtxt TABLES icdtxt_bupa_bup = l_icdtxt xbut000_td = l_xbut000_td ybut000_td = l_ybut000_td xbut0bk = lt_new ybut0bk = lt_old xbut0cc = l_xbut0cc ybut0cc = l_ybut0cc xbut0id = l_xbut0id ybut0id = l_ybut0id xbut0is = l_xbut0is ybut0is = l_ybut0is xbut100 = l_xbut100 ybut100 = l_ybut100.
DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = l_tabname langu = sy-langu all_types = 'X' TABLES dfies_tab = lt_dfies EXCEPTIONS not_found = 1 internal_error = 2 OTHERS = 3.
GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = p_fname "#EC * filetype = 'ASC' write_lf = 'X' codepage = l_cpage confirm_overwrite = 'X' trunc_trailing_blanks_eol = l_trunc_flg TABLES data_tab = p_file EXCEPTIONS OTHERS = 22.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = g_lfilename_down CHANGING physical_filename = l_fname EXCEPTIONS OTHERS = 1.
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 RFIBANMD or its description.