SAP Reports / Programs | Financials | Financial Supply Chain Management | Basic Functions(FIN-FSCM-CLM-CM-CM) SAP FIN
RFEBKAT5 SAP ABAP Report - Generate test data for BAI bank statement and create open items
RFEBKAT5 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for BAI format bank statement test tool Program RFEBKAT5 will generate a text file in BAI2 format which can be uploaded into the SAP system via the common statement loading process...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 RFEBKAT5 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 RFEBKAT5. "Basic submit
SUBMIT RFEBKAT5 AND RETURN. "Return to original report after report execution complete
SUBMIT RFEBKAT5 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
BAI Electronic Bank Stmt test data generation tool
Selection Text: UMSFILE = Polling filename
Selection Text: S_REF2 = XBLNR?
Selection Text: S_REF1 = BELNR?
Selection Text: OFFSETAC = Posting Offset Account
Selection Text: HKTID = House Bank Account
Selection Text: HBKID = House Bank
Selection Text: DEB_RANG = Business Partners
Selection Text: BUKRS = Company Code
Selection Text: AZFILE = EOD filename
Title: Generate test data for BAI bank statement and create open items
Text Symbol: 107 = XBLNR
Text Symbol: 106 = BELNR
Text Symbol: 105 = Reference
Text Symbol: 102 = PC Download
Text Symbol: 101 = BAI
Text Symbol: 100 = Multicash
Text Symbol: 065 = KATReceiver
Text Symbol: 063 = With ref.data
Text Symbol: 062 = With bank details
Text Symbol: 061 = Transfer by DME
Text Symbol: 060 = Invoice date
Text Symbol: 059 = Invoice number
Text Symbol: 058 = Electronic account statement test tool
Text Symbol: 054 = External Trans
Text Symbol: 053 = SAP test program RFEBKAT5
Text Symbol: 052 = Generate open items in clearing accounts
Text Symbol: 051 = Do not display posting screens
Text Symbol: 050 = Display all posting screens
Text Symbol: 110 = S/L Posting
Text Symbol: 111 = Default
Text Symbol: 112 = Specific
Text Symbol: 113 = Checks Out
Text Symbol: 114 = Funds Out
Text Symbol: 115 = Funds In
Text Symbol: 120 = Business Partner
Text Symbol: 121 = CreatePAYR
Text Symbol: 125 = ExtrnlTrns
Text Symbol: 126 = Open Item(s)
Text Symbol: 127 = Last w/diff
Text Symbol: 128 = Generate items
Text Symbol: 130 = Summary polling file
Text Symbol: 131 = Polling filename
Text Symbol: 132 = EOD filename
Text Symbol: 133 = EOD
Text Symbol: 135 = Summary Stmt (Polling)
Text Symbol: 159 = Reference Number
Text Symbol: 049 = Document creation posting method
Text Symbol: 024 = Acct number
Text Symbol: 023 = Bank number
Text Symbol: 022 = Stmt date
Text Symbol: 021 = Statement no.
Text Symbol: 020 = Currncy
Text Symbol: 019 = Bank acct
Text Symbol: 018 = House bk
Text Symbol: 017 = Company code
Text Symbol: 016 = No files generated
Text Symbol: 015 = No open items created
Text Symbol: 014 = Lines
Text Symbol: 013 = Error in download of
Text Symbol: 012 = You are not authorized to create
Text Symbol: 011 = LI file
Text Symbol: 010 = Files created
Text Symbol: 009 = Incoming checks
Text Symbol: 008 = Outgoing checks
Text Symbol: 007 = Cash disbursement
Text Symbol: 006 = G/L acct postings
Text Symbol: 005 = Subsidiary ledger
Text Symbol: 003 = Account info
Text Symbol: 002 = Error: (& &)
Text Symbol: 001 = Table KNBK contains no bank details for the customer
Text Symbol: 025 = Statement info
Text Symbol: 048 = Creating open items - Clearing accounts
Text Symbol: 047 = Credit posting key
Text Symbol: 046 = Debit posting key
Text Symbol: 045 = Document type
Text Symbol: 044 = Increase by
Text Symbol: 043 = Amount
Text Symbol: 042 = Last w/ different amount
Text Symbol: 041 = Number of items
Text Symbol: 040 = Creating open items - Customers / Business Partners
Text Symbol: 039 = Invoice date
Text Symbol: 038 = Statement date
Text Symbol: 037 = Statement data
Text Symbol: 036 = Account details
Text Symbol: 035 = File specifications
Text Symbol: 034 = No customer created
Text Symbol: 033 = Unknown customer
Text Symbol: 032 = RFEBKATX generated
Text Symbol: 031 = Stmt file (Detail)
Text Symbol: 030 = Transactions
Text Symbol: 029 = End.bal.
Text Symbol: 028 = Sales creds
Text Symbol: 027 = Sales debs
Text Symbol: 026 = Beg.bal.
INCLUDES used within this REPORT RFEBKAT5
INCLUDE RFEBKAT9.
INCLUDE RFEBKAT8.
INCLUDE: RFEBKATC, RFEBKATM. "HW661400
INCLUDE: RFEBKATC, RFEBKATM. "HW661400
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'
KD_GET_FILENAME_ON_F4 CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING * mask = ',Multicash,*.txt'
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = logFilename parameter_1 = sy-cprog CHANGING physical_filename = UMSFILE EXCEPTIONS OTHERS = 1.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = logFilename parameter_1 = sy-cprog CHANGING physical_filename = AZFILE EXCEPTIONS OTHERS = 1.
POSTING_INTERFACE_DOCUMENT CALL FUNCTION 'POSTING_INTERFACE_DOCUMENT' EXPORTING i_tcode = tcode IMPORTING e_subrc = subrc e_msgid = msgid e_msgty = msgty e_msgno = msgno e_msgv1 = msgv1 e_msgv2 = msgv2 e_msgv3 = msgv3 e_msgv4 = msgv4 TABLES t_ftpost = ftpost t_fttax = fttax t_blntab = blntab.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING i_function = function i_mode = mode i_update = update i_user = sy-uname.
POSTING_INTERFACE_END CALL FUNCTION 'POSTING_INTERFACE_END'.
* CALL FUNCTION 'WS_DOWNLOAD' * EXPORTING * filename = pcfile * TABLES * data_tab = itab * EXCEPTIONS * file_open_error = 1 * file_write_error = 2 * invalid_filesize = 3 * invalid_table_width = 4 * invalid_type = 5 * no_batch = 6 * unknown_error = 7 * OTHERS = 8.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = logFilename parameter_1 = sy-cprog including_dir = 'X' IMPORTING file_name = p_file EXCEPTIONS others = 1.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING * CLIENT = SY-MANDT logical_filename = logFilename * OPERATING_SYSTEM = SY-OPSYS * parameter_1 = i_file_name * USE_PRESENTATION_SERVER = ' ' * WITH_FILE_EXTENSION = ' ' * USE_BUFFER = ' ' * ELEMINATE_BLANKS = 'X' CHANGING * EMERGENCY_FLAG = * FILE_FORMAT = physical_filename = p_file EXCEPTIONS LOGICAL_FILENAME_NOT_FOUND = 1 OTHERS = 2.
AUTHORITY_CHECK_DATASET CALL FUNCTION 'AUTHORITY_CHECK_DATASET' EXPORTING program = 'RFEBKAT5' activity = 'WRITE' filename = unixfile EXCEPTIONS no_authority = 1 activity_unknown = 2 OTHERS = 3.
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 RFEBKAT5 or its description.
RFEBKAT5 - Generate test data for BAI bank statement and create open items RFEBKAT5 - Generate test data for BAI bank statement and create open items RFEBKAT4 - Test Program: IDocs are created from the bank data store RFEBKAT4 - Test Program: IDocs are created from the bank data store RFEBKAT3 - Generate test data (IDoc) RFEBKAT3 - Generate test data (IDoc)