SAP Reports / Programs | Financials | Financial Supply Chain Management | Basic Functions(FIN-FSCM-CLM-CM-CM) SAP FIN
RFEBJP00 SAP ABAP Report - Import Bank Statement: ZENGINKYO (Japan)
RFEBJP00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program RFEBJP00 imports bank statements into the SAP system,and then generates batch input sessions for posting in G/L and subledger accounting...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 RFEBJP00 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 RFEBJP00. "Basic submit
SUBMIT RFEBJP00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFEBJP00 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: BATCH = Execute as background job
Selection Text: BNKBUCH = Bank posting session(s)
Selection Text: CRLFFILE = Upload with line break
Selection Text: EINLESEN = Import data
Selection Text: FORMAT = Elect. bank statement format
Selection Text: INFILE = Input file
Selection Text: JPFORMAT = ZENGINKYOU Format
Selection Text: MREGEL = Rule for naming sessions
Selection Text: NEBBUCH = Subledger session(s)
Selection Text: PCUPLOAD = Workstation upload
Selection Text: P_BUPRO = Print posting log
Selection Text: P_KOAUSZ = Print bank statement
Selection Text: P_STATIK = Print statistics
Selection Text: SELFD = Selection field
Selection Text: SELFDLEN = Selection field length
Selection Text: SPOOL = Printout to the spool
Selection Text: S_FILTER = BELNR number interval
Selection Text: TESTL = Test run: no postings
Selection Text: T_FILTER = XBLNR number interval
Selection Text: USEREXIT = User exit
Selection Text: VALUT_ON = Assign value date to account
Selection Text: WAREKI = Wareki
Selection Text: JPINVSUM = D .
Title: Import Bank Statement: ZENGINKYO (Japan)
Text Symbol: 508 = PostDate Bill/exch Debit Credit Ordering party/Payer
Text Symbol: 509 = Ref. no. ValDte Trans. Check no. (Third bank incom) (Third bank outgo) Bank name Branch name Usage
Text Symbol: 510 = Cash
Text Symbol: 511 = Remit ;;
Text Symbol: 512 = Other BK
Text Symbol: 513 = Pay/cash
Text Symbol: 514 = Transfer
Text Symbol: 518 = Others
Text Symbol: 519 = Reversal
Text Symbol: 520 = Total amt of data
Text Symbol: 521 = Total
Text Symbol: 522 = from;;
Text Symbol: 523 = to
Text Symbol: 524 = Check ;; Kogitte
Text Symbol: 525 = Bill/Ex ;; Yakusokutegata
Text Symbol: 526 = Bill/Ex ;; Kawasetegata
Text Symbol: 531 = Remit ;;
Text Symbol: 539 = Reverse ;;
Text Symbol: 541 = Layout
Text Symbol: 542 = Output List
Text Symbol: 543 = Layout
Text Symbol: 544 = Bnk Statmnt
Text Symbol: 545 = Configure
Text Symbol: AL1 = Reference No
Text Symbol: AL2 = Payer
Text Symbol: 507 = Account type:
Text Symbol: 119 = ID:
Text Symbol: 118 = No line items exist for this bank statement
Text Symbol: 117 = Currency
Text Symbol: 116 = Account name:
Text Symbol: 115 = Statement number:
Text Symbol: 114 = Statement date:
Text Symbol: 113 = Account number:
Text Symbol: 112 = BNo:
Text Symbol: 111 = Account holder:
Text Symbol: 031 = TranTyp. External transaction +/- sign
Text Symbol: 030 = Following entries missing in table T028G:
Text Symbol: 020 = field.
Text Symbol: 019 = Therefore, enter a blank space in the "X - Import data"
Text Symbol: 018 = Bank statement is already in SAP System and need not be imported again
Text Symbol: 017 = Afterwards, start the processing again.
Text Symbol: 016 = Refer to the manual for more notes.
Text Symbol: 015 = Enter the transactions in table T028G.
Text Symbol: 014 = table T028G.
Text Symbol: 013 = text keys, or posting texts) were in
Text Symbol: 012 = that not all external transactions (business transaction code,
Text Symbol: 011 = While importing electronic bank statement, the system determined
Text Symbol: 010 = **************************************************************************
Text Symbol: 002 = EL BANK STATEMENT
Text Symbol: 001 = Electronic bank statement
Text Symbol: 120 = INo ValDt PstDt Note to payee Posting text BTC Journal Amount
Text Symbol: 503 = Svngs;; Chochiku
Text Symbol: 502 = Curr ;; Toza
Text Symbol: 501 = Ordi ;; Futsu
Text Symbol: 500 = ***** Reserved for Japanese version *****
Text Symbol: 171 = Only bank pstgs
Text Symbol: 168 = Do not post
Text Symbol: 167 = Output control
Text Symbol: 166 = Algorithms
Text Symbol: 165 = File specifications
Text Symbol: 164 = Session names
Text Symbol: 163 = Generate batch input
Text Symbol: 161 = Post immediately
Text Symbol: 160 = Posting parameters
Text Symbol: 151 = Table FEBVW already has an entry with key & & &
Text Symbol: 150 = Table FEBKO already has an entry with key & & & &
Text Symbol: 136 = Partner acct
Text Symbol: 135 = Ptnr bk no.
Text Symbol: 134 = ------------------------------
Text Symbol: 133 = Total Credit
Text Symbol: 132 = Total Debit
Text Symbol: 131 = Clos. Bal.
Text Symbol: 130 = Opening Balance
Text Symbol: 122 = House bank :
Text Symbol: 121 = House bank:
INCLUDES used within this REPORT RFEBJP00
INCLUDE RFEBKA03.
INCLUDE RFEBJP03.
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:
KD_GET_FILENAME_ON_F4 CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING mask = ',Multicash,*.txt'
INITIALIZE_STRUCTURE * CALL FUNCTION 'INITIALIZE_STRUCTURE' * EXPORTING * I_N_FILL = 0 * I_i_FILL = 0 * CHANGING * C_WORKAREA = gs_output_value_layout1 * EXCEPTIONS * INVALID_TYPE = 1 * OTHERS = 2.
WRITE_LIST * CALL FUNCTION 'WRITE_LIST' "note 849481 * EXPORTING "note 849481 * write_only = 'X' "note 849481 * TABLES "note 849481 * listobject = gt_rfebbu00_output. "note 849481
LIST_FROM_MEMORY * CALL FUNCTION 'LIST_FROM_MEMORY' "note 849481 * TABLES "note 849481 * listobject = gt_rfebbu00_output "note 849481 * EXCEPTIONS "note 849481 * not_found = 1 "note 849481 * OTHERS = 2. "note 849481
GET_PRINT_PARAMETERS CALL FUNCTION 'GET_PRINT_PARAMETERS' EXPORTING no_dialog = 'X' list_name = list_name mode = 'CURRENT' * LAYOUT = 'X_65_132' IMPORTING out_archive_parameters = p_arc_param out_parameters = p_pri_param.
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_callback_program = g_repid it_fieldcat = lt_fieldcat it_events = lt_eventtab is_layout = ls_layout is_print = ls_print it_sort = lt_sorttab i_callback_pf_status_set = slis_ev_pf_status_set is_variant = ls_variant i_save = gc_save TABLES t_outtab = xt_table EXCEPTIONS program_error = 1 OTHERS = 2.
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_structure_name = i_strname CHANGING ct_fieldcat = xt_fieldcat EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.
REUSE_ALV_EVENTS_GET CALL FUNCTION 'REUSE_ALV_EVENTS_GET' EXPORTING i_list_type = 0 IMPORTING et_events = xt_eventtab EXCEPTIONS list_type_wrong = 1 OTHERS = 2.
REUSE_ALV_LIST_LAYOUT_INFO_GET CALL FUNCTION 'REUSE_ALV_LIST_LAYOUT_INFO_GET' IMPORTING e_width = lv_width.
FAGL_BATCH_HEADING_PERFORM CALL FUNCTION 'FAGL_BATCH_HEADING_PERFORM' EXPORTING is_bhdgd = bhdgd.
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = gt_top_of_page.
REUSE_ALV_COMMENTARY_WRITE * CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' * EXPORTING * it_list_commentary = gt_end_of_page.
WRITE_LIST * CALL FUNCTION 'WRITE_LIST' "note 849481 * EXPORTING "note 849481 * write_only = 'X' "note 849481 * TABLES "note 849481 * listobject = gt_rfebbu00_output. "note 849481
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = gt_end_of_page.
REUSE_ALV_VARIANT_F4 CALL FUNCTION 'REUSE_ALV_VARIANT_F4' EXPORTING is_variant = ls_variant i_save = gc_save IMPORTING e_exit = l_exit es_variant = l_variant_help EXCEPTIONS not_found = 1 program_error = 2 OTHERS = 3.
REUSE_ALV_VARIANT_EXISTENCE CALL FUNCTION 'REUSE_ALV_VARIANT_EXISTENCE' EXPORTING i_save = gc_save CHANGING cs_variant = ls_variant EXCEPTIONS wrong_input = 1 not_found = 2 program_error = 3 OTHERS = 4.
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_callback_program = g_repid it_fieldcat = lt_fieldcat is_variant = ls_variant i_save = gc_save TABLES t_outtab = xt_table EXCEPTIONS program_error = 1 OTHERS = 2.
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 RFEBJP00 or its description.
RFEBJP00 - Import Bank Statement: ZENGINKYO (Japan) RFEBJP00 - Import Bank Statement: ZENGINKYO (Japan) RFEBITI0 - Define Record Layout for Norwegian Electronic Bank Statement Globally RFEBIT00 - Bank Statement:Italy CBI - Convert to Multicash RFEBIT00 - Bank Statement:Italy CBI - Convert to Multicash RFEBGB20 - Import GB Bank Statement into Bank Data Buffer