RFEBKATX SAP ABAP Report - Test Tool RFEBKATX: Create Open Items and Bank Statement Files

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

RFEBKATX is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The following is the text of the Release Note on Program RFEBKATX...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 RFEBKATX 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 RFEBKATX. "Basic submit
SUBMIT RFEBKATX AND RETURN. "Return to original report after report execution complete
SUBMIT RFEBKATX 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: ANZAHL = Number of customer invoices
Selection Text: AZFILE = Statement file
Selection Text: AZ_DATUM = Statement date
Selection Text: BSCH1 = Debit posting key
Selection Text: BSCH2 = Credit posting key
Selection Text: BUKRS = Company code
Selection Text: DEBIERR = One statement item defective
Selection Text: DEB_RANG = Customers to be posted to
Selection Text: FORMAT = Format (M-Multicash, O-OFX)
Selection Text: HBKID = House bank (ID)
Selection Text: HKTID = Account (ID)
Selection Text: RE_DATUM = Invoice date
Selection Text: UMSFILE = Line item file
Selection Text: WRBTR = Start amount
Selection Text: XBANK = Bank postings
Selection Text: XPC = Download to PC
Title: Test Tool RFEBKATX: Create Open Items and Bank Statement Files
Text Symbol: 043 = First amount
Text Symbol: 044 = Increase by
Text Symbol: 045 = Document type
Text Symbol: 046 = Debit posting key
Text Symbol: 047 = Credit posting key
Text Symbol: 048 = Creating open items - Clearing accounts -
Text Symbol: 049 = Posting method
Text Symbol: 050 = Display all posting screens
Text Symbol: 051 = Do not display posting screen
Text Symbol: 052 = Generate open items in clearing accounts
Text Symbol: 053 = SAP test program RFEBKATX
Text Symbol: 054 = Check Deposit
Text Symbol: 055 = Check debit
Text Symbol: 056 = Check
Text Symbol: 057 = DME check deposit
Text Symbol: 058 = Electronic bank statement
Text Symbol: 059 = Invoice number
Text Symbol: 060 = Invoice date
Text Symbol: 061 = Transfer by DME
Text Symbol: 062 = With bank details
Text Symbol: 063 = With ref.data

Text Symbol: 077 = Error When Opening File
Text Symbol: 080 = OFX file
Text Symbol: 081 = Incrementing Amount
Text Symbol: 001 = Table KNBK contains no bank details for the customer
Text Symbol: 002 = Error: (& &)
Text Symbol: 003 = Account info
Text Symbol: 005 = Subsidiary ledger
Text Symbol: 006 = G/L acct postings
Text Symbol: 007 = Cash disbursement
Text Symbol: 008 = Outgoing checks
Text Symbol: 009 = Incoming checks
Text Symbol: 010 = Files created
Text Symbol: 011 = LI file
Text Symbol: 012 = You are not authorized to create
Text Symbol: 013 = Error in download of
Text Symbol: 014 = Lines:
Text Symbol: 015 = No open items created
Text Symbol: 016 = No files generated
Text Symbol: 017 = Company code
Text Symbol: 018 = House bk
Text Symbol: 019 = Bank acct
Text Symbol: 020 = Currncy
Text Symbol: 021 = Statement no.
Text Symbol: 022 = Stmt date
Text Symbol: 023 = Bank number
Text Symbol: 024 = Acct number
Text Symbol: 025 = Statement info
Text Symbol: 026 = Beg.bal.
Text Symbol: 027 = Sales debs
Text Symbol: 028 = Sales creds
Text Symbol: 029 = ClsgBal.
Text Symbol: 030 = Transactions
Text Symbol: 031 = Stmt file
Text Symbol: 032 = RFEBKATX generated
Text Symbol: 033 = Unknown customer
Text Symbol: 034 = No customer created
Text Symbol: 035 = File specifications
Text Symbol: 036 = Account details
Text Symbol: 037 = Statement data

Text Symbol: 038 = Statement date
Text Symbol: 039 = Invoice date
Text Symbol: 040 = Creating open items - Customers -
Text Symbol: 041 = Number of open items
Text Symbol: 042 = Last open item with different amount

INCLUDES used within this REPORT RFEBKATX

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:

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.

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.

CURRENCY_AMOUNT_IDOC_TO_SAP CALL FUNCTION 'CURRENCY_AMOUNT_IDOC_TO_SAP' "n893178 EXPORTING CURRENCY = WAERS IDOC_AMOUNT = WRBTR IMPORTING SAP_AMOUNT = KWBTR EXCEPTIONS OTHERS = 0.

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'.

WS_DOWNLOAD * CALL FUNCTION 'WS_DOWNLOAD' * EXPORTING * FILENAME = FILENAME * 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.

CURRENCY_AMOUNT_IDOC_TO_SAP CALL FUNCTION 'CURRENCY_AMOUNT_IDOC_TO_SAP' "n893178 EXPORTING CURRENCY = P_WAERS IDOC_AMOUNT = P_WRBTR IMPORTING SAP_AMOUNT = INTERIM EXCEPTIONS OTHERS = 0.

CURRENCY_AMOUNT_IDOC_TO_SAP CALL FUNCTION 'CURRENCY_AMOUNT_IDOC_TO_SAP' "n893178 EXPORTING CURRENCY = WAERS IDOC_AMOUNT = WRBTR IMPORTING SAP_AMOUNT = KWBTR EXCEPTIONS OTHERS = 0.

AUTHORITY_CHECK_DATASET CALL FUNCTION 'AUTHORITY_CHECK_DATASET' EXPORTING PROGRAM = I_PROGRAM ACTIVITY = SABC_ACT_WRITE FILENAME = I_FILE EXCEPTIONS NO_AUTHORITY = 1 ACTIVITY_UNKNOWN = 2 OTHERS = 3.

CURRENCY_AMOUNT_IDOC_TO_SAP CALL FUNCTION 'CURRENCY_AMOUNT_IDOC_TO_SAP' "n893178 EXPORTING CURRENCY = P_WAERS IDOC_AMOUNT = P_VALUE IMPORTING SAP_AMOUNT = P_VALUE EXCEPTIONS OTHERS = 0.

CURRENCY_CODE_SAP_TO_ISO CALL FUNCTION 'CURRENCY_CODE_SAP_TO_ISO' EXPORTING SAP_CODE = SAP_CODE IMPORTING ISO_CODE = ISO_CODE EXCEPTIONS NOT_FOUND = 1 OTHERS = 2.

CONVERT_DATE_TO_INTERNAL CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL' EXPORTING DATE_EXTERNAL = UMSATZ-BUDAT IMPORTING DATE_INTERNAL = LWA_TRANSACTION-DTPOSTED EXCEPTIONS DATE_EXTERNAL_IS_INVALID = 1 OTHERS = 2.

CONVERT_DATE_TO_INTERNAL CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL' EXPORTING DATE_EXTERNAL = UMSATZ-VALUT IMPORTING DATE_INTERNAL = LWA_TRANSACTION-DTAVAIL EXCEPTIONS DATE_EXTERNAL_IS_INVALID = 1 OTHERS = 2.

CURRENCY_CODE_SAP_TO_ISO CALL FUNCTION 'CURRENCY_CODE_SAP_TO_ISO' EXPORTING SAP_CODE = SAP_CODE IMPORTING ISO_CODE = ISO_CODE EXCEPTIONS NOT_FOUND = 1 OTHERS = 2.

OFX_STRUCTURE_GET CALL FUNCTION 'OFX_STRUCTURE_GET' EXPORTING IM_MESSAGE_SET = 'STMTTRNRS' IMPORTING EX_STRUCTURE_VERSION = L_APPLICATION_STRUCTURE_VRS.

COPY_STRUCTURE_CORRESPONDING CALL FUNCTION 'COPY_STRUCTURE_CORRESPONDING' EXPORTING IM_STRUCTURE = L_OFX_ACCOUNT_STMT IMPORTING EX_STRUCTURE = .

SAP_TO_OFX_CONVERT CALL FUNCTION 'SAP_TO_OFX_CONVERT' EXPORTING IM_STRUCTURE = IM_MESSAGESET = 'STMTTRNRS' * IM_STARTLEVEL = 0 * IM_NUMBER_OF_BLANKS = 2 * IM_WRITE_EMPTY_TAGS = ' ' TABLES PTE_OFXTEXT = OFX_TABLE.

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

RFEBKATX - Test Tool RFEBKATX: Create Open Items and Bank Statement Files
RFEBKATX - Test Tool RFEBKATX: Create Open Items and Bank Statement Files
RFEBKATM - documentation and ABAP source code
RFEBKATI - Generate Test Data for Multicash - Include Structures
RFEBKATC - documentation and ABAP source code
RFEBKAT9_NACC - RFEBKAT9NACC

RCMS_COLL_SHEET_PRINT

RCMS_COR_REQ_PRINT

REE_DATEX_TASKS_EXECUTE

REHSBCW_LIF_TREE_SEL_LISTENR