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

comments icon Comments

RFEBSTMTTOOL SAP ABAP Report - Program RFEBSTMTTOOL







RFEBSTMTTOOL is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Bank statment analyzer tool To analyze the content of a bank delivered data file...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 RFEBSTMTTOOL 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 RFEBSTMTTOOL. "Basic submit
SUBMIT RFEBSTMTTOOL AND RETURN. "Return to original report after report execution complete
SUBMIT RFEBSTMTTOOL VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Bank statement analyzer tool
Selection Text: SHTEXT = Display memo text
Selection Text: SHSPLIT = Display fund availability
Selection Text: RADIO2 = Display 2
Selection Text: RADIO1 = Display 1
Selection Text: PCUPLOAD = PC Upload
Selection Text: AUSZFILE = File Name
Title: Program RFEBSTMTTOOL
Text Symbol: 227 = Modifier:
Text Symbol: 226 = Memo Text
Text Symbol: 225 = Item
Text Symbol: 224 = Inconsistency between house bank account table and house BANK TABLE
Text Symbol: 223 = House bank table: No entry with bank key
Text Symbol: 222 = Group status:
Text Symbol: 221 = File time:
Text Symbol: 220 = File date:
Text Symbol: 219 = File ID:
Text Symbol: 218 = File Control Total
Text Symbol: 217 = Ext txn text not defined
Text Symbol: 216 = Description
Text Symbol: 215 = Date:
Text Symbol: 214 = Customer Specific Txn
Text Symbol: 213 = Cust Ref
Text Symbol: 228 = No. of Groups
Text Symbol: 229 = No. of Record
Text Symbol: 230 = Originator:
Text Symbol: 231 = Receiver:
Text Symbol: 232 = Record length:
Text Symbol: 233 = Same bank account in several company codes
Text Symbol: 234 = Sender:
Text Symbol: 235 = Stmt Date
Text Symbol: 236 = Table T012 does not have an entry with bank key
Text Symbol: 237 = Time:
Text Symbol: 238 = Type
Text Symbol: 239 = and account
Text Symbol: 240 = for
Text Symbol: 241 = not permitted
Text Symbol: 242 = Cur





Text Symbol: 243 = Txn
Text Symbol: 051 = File upload selection
Text Symbol: 052 = Report selection
Text Symbol: 053 = Cash management position
Text Symbol: 061 = File detail report
Text Symbol: 062 = Header transaction detail
Text Symbol: 063 = Transaction item detail
Text Symbol: 064 = Split availability information
Text Symbol: 065 = Text detail display
Text Symbol: 066 = Bank account transaction summary
Text Symbol: 067 = Line item configuration check
Text Symbol: 068 = Total line item transaction stats
Text Symbol: 069 = Detail summarization
Text Symbol: 079 = File detail report
Text Symbol: 080 = Bank Statement Information Analysis Tool
Text Symbol: 082 = Line Item Transaction Statistics
Text Symbol: 083 = Bank Account transaction summary
Text Symbol: 084 = Item Configuration Check Listing
Text Symbol: 085 = Line Item Cash Management and Posting information
Text Symbol: 091 = Line 1: File Header Information
Text Symbol: 092 = Line 2: Group Header Information
Text Symbol: 093 = Line 3: Account Header Information
Text Symbol: 094 = Line 16: Transaction Detail Information
Text Symbol: 095 = Additional memo from line 16
Text Symbol: 096 = Split Availability Info from line 16
Text Symbol: 097 = Line 49: Account Trailer Information
Text Symbol: 098 = Line 98: Group Trailer Information
Text Symbol: 099 = Line 99: File Trailer Information
Text Symbol: 201 = Acct #
Text Symbol: 202 = Acct No.
Text Symbol: 203 = Amount
Text Symbol: 204 = Avail. Date
Text Symbol: 205 = BAI type:
Text Symbol: 206 = Bank Accont transaction type missing.
Text Symbol: 207 = Bank Ref
Text Symbol: 208 = Block size:
Text Symbol: 209 = Control Total
Text Symbol: 210 = Count
Text Symbol: 211 = Currency





Text Symbol: 212 = Currency:


INCLUDES used within this REPORT RFEBSTMTTOOL

INCLUDE RFEBKA03.


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'

WS_UPLOAD
*  CALL FUNCTION 'WS_UPLOAD'
*       EXPORTING
*            filename        = auszug-file
*            filetype        = 'ASC'
*       TABLES
*            data_tab        = bai_in
*       EXCEPTIONS
*            file_open_error = 1
*            file_read_error = 2.

FILE_GET_NAME
  CALL FUNCTION 'FILE_GET_NAME'
    EXPORTING
      logical_filename = logFilename
      parameter_1      = sy-cprog
      including_dir    = 'X'
    IMPORTING
      file_name        = auszugfile
    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                = auszugfile
   EXCEPTIONS
       LOGICAL_FILENAME_NOT_FOUND     = 1
       OTHERS                         = 2.

CONVERT_YEAR_WITH_THRESHOLD
    CALL FUNCTION 'CONVERT_YEAR_WITH_THRESHOLD'
         EXPORTING
              input     = numc02
*           THRESHOLD = 50
        IMPORTING
              output    = numc04
         EXCEPTIONS
              OTHERS    = 1.

GET_BANK_ACCOUNT
  CALL FUNCTION 'GET_BANK_ACCOUNT'
       EXPORTING
            i_bankl                = bankl
            i_bnkn2                = bnkn2
       IMPORTING
            e_t012                 = t012
            e_t012k                = t012k
       EXCEPTIONS
            bank_account_not_found = 01
            bank_key_false         = 02
            bank_key_not_found     = 03
            multiple_bank_account  = 04
            input_wrong            = 05
            currency_false         = 06
            currency_not_found     = 06.


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


   
 

RFEBSTMTTOOL - Program RFEBSTMTTOOL
RFEBSTMTTOOL - Program RFEBSTMTTOOL
RFEBSEI0 - Define Record Layout for Swedish Electronic Bank Statement Globally
RFEBSE00_NACC - Convert Swedish Bank Statement to MultiCash Format
RFEBSE00_NACC - Convert Swedish Bank Statement to MultiCash Format
RFEBSE00 - Convert Swedish Bank Statement to MultiCash Format