SAP Reports / Programs

comments icon Comments

RFKLET01 SAP ABAP Report - Accumulated Balance Audit Trail







RFKLET01 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The Report "Balance Audit Trail" for historical or open-item balance audit trail...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 RFKLET01 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 RFKLET01. "Basic submit
SUBMIT RFKLET01 AND RETURN. "Return to original report after report execution complete
SUBMIT RFKLET01 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: AKONTO = Reconciliation Account
Selection Text: BA_CHECK = Suppress Reconciliation
Selection Text: IACC = Archive Account
Selection Text: IBAREA = Archive Business Area
Selection Text: IBUKRS = Archive Company Code
Selection Text: ICLEARY = Archive up to and incl.fisc.yr
Selection Text: IKOART = Archive Account Type
Selection Text: IRESET = Reset Tables
Selection Text: I_ONLY = Delete Balance
Selection Text: MERGE_F = Create Balance
Selection Text: NO_DOCS = Do Not Read Documents
Selection Text: PAR_GKON = Offsetting Acct Determination
Selection Text: P_ALTKT = Alternative Account Number
Selection Text: P_KKET = Sort by Alternative Acc. No.
Selection Text: P_KLET = Classic Sort Order
Selection Text: XSTAJ = Read Year-End Closing Postings
Selection Text: ACCTYPE = D .
Selection Text: DKONTO = D .
Selection Text: KKONTO = D .
Selection Text: POSTEN = D .
Selection Text: SKONTO = D .
Title: Accumulated Balance Audit Trail
Text Symbol: T06 = Classic Sort Order
Text Symbol: T05 = Delete Balance
Text Symbol: T04 = Test Run
Text Symbol: T03 = Sorting
Text Symbol: T02 = Create Balance
Text Symbol: 060 = Customer: General Part
Text Symbol: 061 = Customer: Company Code Part
Text Symbol: 062 = G/L Account: General Part
Text Symbol: 063 = G/L Account: Company Code Part
Text Symbol: 068 = Company Code
Text Symbol: 069 = not found
Text Symbol: 100 = Check Documents/Items in Database
Text Symbol: 135 = Reset DB Table
Text Symbol: 210 = Master Record Bals Not Equal to Item Bals:
Text Symbol: 211 = Messages
Text Symbol: 510 = Number Insert G/L Account Master Record





Text Symbol: 511 = Number Insert G/L Account Items
Text Symbol: 512 = Number Insert Subsidiary Ledger Master
Text Symbol: 513 = Number Insert Subsidiary Ledger Items
Text Symbol: 514 = Number Insert Master Data of Open Items
Text Symbol: 515 = Number Insert Open Items
Text Symbol: 520 = DSKOS
Text Symbol: 521 = DSKOP
Text Symbol: 522 = DKKOS
Text Symbol: 523 = DKKOP
Text Symbol: 524 = DKOKS
Text Symbol: 525 = DKOKP
Text Symbol: E01 = This report is no longer supported
Text Symbol: E02 = Use new report RFKLET01
Text Symbol: E10 = Ledger selection is not supported!
Text Symbol: T01 = Processing


INCLUDES used within this REPORT RFKLET01

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:

READ_SKC1C
    CALL FUNCTION 'READ_SKC1C'
      EXPORTING
        xbukrs    = skc1a-bukrs
        xgjahr    = skc1a-gjahr
        xgsber    = skc1a-gsber
        xrtcur    = skb1-waers
        xsaknr    = skc1a-saknr
      IMPORTING
        xskc1c    = skc1c
      EXCEPTIONS
        others = 0.

GET_GKONT_2
    CALL FUNCTION 'GET_GKONT_2'
      EXPORTING
        gknkz  = par_gkon
      TABLES
        xbseg  = xbseg
        xbsegz = xbsegz
      EXCEPTIONS
        OTHERS = 0.

GET_CURRENT_YEAR
        CALL FUNCTION 'GET_CURRENT_YEAR'
          EXPORTING
            BUKRS         = xbseg-bukrs
            DATE          = xbseg-augdt
          IMPORTING
            CURRY         = lf_gjahr_augdt.

DD_DROP_TABLE
    CALL FUNCTION 'DD_DROP_TABLE'
      EXPORTING
        tabname = itab
      EXCEPTIONS
        OTHERS  = 0.

DDIF_TABL_ACTIVATE
    CALL FUNCTION 'DDIF_TABL_ACTIVATE'
         EXPORTING
              name        =  itab
              auth_chk    = ' '
*               PRID        = -1
*          IMPORTING
*               RC          =
        EXCEPTIONS
              not_found   = 1
              put_failure = 2
              OTHERS      = 3
              .

DB_COMMIT
        CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT
            CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT
    CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT
  CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT
        CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT
















  CALL FUNCTION 'DB_COMMIT'.

READ_KNA1
      CALL FUNCTION 'READ_KNA1'
        EXPORTING
          xkunnr         = xx-konto
        IMPORTING
          xkna1          = kna1
        EXCEPTIONS
          key_incomplete = 04
          not_authorized = 04
          not_found      = 04.

READ_KNB1
      CALL FUNCTION 'READ_KNB1'
        EXPORTING
          xkunnr         = xx-konto
          xbukrs         = xx-bukrs
        IMPORTING
          xknb1          = knb1
        EXCEPTIONS
          key_incomplete = 04
          not_authorized = 04
          not_found      = 04.

READ_LFA1
      CALL FUNCTION 'READ_LFA1'
        EXPORTING
          xlifnr         = xx-konto
        IMPORTING
          xlfa1          = lfa1
        EXCEPTIONS
          key_incomplete = 04
          not_authorized = 04
          not_found      = 04.

READ_LFB1
      CALL FUNCTION 'READ_LFB1'
        EXPORTING
          xlifnr         = xx-konto
          xbukrs         = xx-bukrs
        IMPORTING
          xlfb1          = lfb1
        EXCEPTIONS
          key_incomplete = 04
          not_authorized = 04
          not_found      = 04.

READ_SKA1
      CALL FUNCTION 'READ_SKA1'
        EXPORTING
          xktopl         = t001-ktopl
          xsaknr         = xx-konto
        IMPORTING
          xska1          = ska1
          xskat          = skat
        EXCEPTIONS
          key_incomplete = 04
          not_authorized = 04
          not_found      = 04.

READ_SKB1
      CALL FUNCTION 'READ_SKB1'
        EXPORTING
          xsaknr         = xx-konto
          xbukrs         = xx-bukrs
        IMPORTING
          xskb1          = skb1
        EXCEPTIONS
          key_incomplete = 04
          not_authorized = 04
          not_found      = 04.

DB_COMMIT
  CALL FUNCTION 'DB_COMMIT'.

DB_COMMIT
  CALL FUNCTION 'DB_COMMIT'.

POPUP_TO_INFORM
  CALL FUNCTION 'POPUP_TO_INFORM'
    EXPORTING
      titel = ' '
      txt1  = text-e01
      txt2  = text-e02.

READ_SACHKONTO_ALTKT
    CALL FUNCTION 'READ_SACHKONTO_ALTKT'
      EXPORTING
        bukrs  = ibukrs
        saknr  = ikonto
      IMPORTING
        altkt  = alt_tab-altkt
      EXCEPTIONS
        OTHERS = 4.

FAGL_CHECK_GLFLEX_ACTIVE
      CALL FUNCTION 'FAGL_CHECK_GLFLEX_ACTIVE'
        IMPORTING
          e_glflex_active = ld_glflex_active.

FAGL_GET_LEADING_LEDGER
        CALL FUNCTION 'FAGL_GET_LEADING_LEDGER'
          IMPORTING
            e_rldnr = ld_leading_ledger.

RS_REFRESH_FROM_DYNAMICAL_SEL
  CALL FUNCTION 'RS_REFRESH_FROM_DYNAMICAL_SEL'
    EXPORTING
      curr_report        = p_repid
      mode_write_or_move = 'M'
    IMPORTING
      p_trange           = pt_ranges
    EXCEPTIONS
      not_found          = 1
      wrong_type         = 2
      OTHERS             = 3.

FREE_SELECTIONS_RANGE_2_WHERE
    CALL FUNCTION 'FREE_SELECTIONS_RANGE_2_WHERE'  "#EC *
      EXPORTING
        field_ranges  = pt_ranges
      IMPORTING
        where_clauses = pt_where.

BAL_LOG_MSG_ADD_FREE_TEXT
*  CALL FUNCTION 'BAL_LOG_MSG_ADD_FREE_TEXT'
*    EXPORTING
*      i_log_handle     = i_log_handle1
*      i_msgty          = 'I'
*      i_text           = i_text
*    EXCEPTIONS
*      log_not_found    = 1
*      msg_inconsistent = 2
*      log_is_full      = 3
*      OTHERS           = 4.

REUSE_ALV_LIST_LAYOUT_INFO_GET
  CALL FUNCTION 'REUSE_ALV_LIST_LAYOUT_INFO_GET'
    IMPORTING
      e_width       = lv_width
    EXCEPTIONS
      no_infos      = 1
      program_error = 2
      OTHERS        = 3.

FAGL_BATCH_HEADING_PERFORM
  CALL FUNCTION 'FAGL_BATCH_HEADING_PERFORM'
    EXPORTING
      is_bhdgd     = bhdgd
    IMPORTING
      eo_form_grid = lo_grid.

REUSE_ALV_LIST_DISPLAY
  CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
    EXPORTING
      i_callback_program = g_repid
      i_structure_name   = 'fagl_acc_s_header'
      is_layout          = ls_layout
      i_CALLBACK_PF_STATUS_SET = 'HANDLE_SET_PF_STATUS'
*            it_fieldcat        = gt_fieldcat
      it_events          = lt_eventtab
*            it_sort            = gt_sorttab
*            is_print           = ls_print
*            i_save             = gc_save
             is_variant         = ls_variant
    TABLES
      t_outtab           = gt_statistics.

REUSE_ALV_LIST_DISPLAY
  CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
    EXPORTING
      i_callback_program = g_repid
      i_structure_name   = 'fagl_s_rfklet01_list2'
      is_layout          = ls_layout
      i_CALLBACK_PF_STATUS_SET = 'HANDLE_SET_PF_STATUS'


*            it_fieldcat        = gt_fieldcat
      it_events          = lt_eventtab
*            it_sort            = gt_sorttab
*            is_print           = ls_print
*            i_save             = gc_save
*            is_variant         = gs_variant
    TABLES
      t_outtab           = gt_items.




REUSE_ALV_EVENTS_GET
  CALL FUNCTION 'REUSE_ALV_EVENTS_GET'
    EXPORTING
      i_list_type     = 1
    IMPORTING
      et_events       = xt_eventtab
    EXCEPTIONS
      list_type_wrong = 1
      OTHERS          = 2.

BAL_LOG_CREATE
*  CALL FUNCTION 'BAL_LOG_CREATE'
*    EXPORTING
*      i_s_log                 = lv_s_log
*    IMPORTING
*      e_log_handle            = x_log_handle1
*    EXCEPTIONS
*      log_header_inconsistent = 1
*      OTHERS                  = 2.

BAL_DSP_PROFILE_NO_TREE_GET
*  CALL FUNCTION 'BAL_DSP_PROFILE_NO_TREE_GET'
*    IMPORTING
*      e_s_display_profile = xs_prof.


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


   
 

RFKLET01 - Accumulated Balance Audit Trail
RFKLET01 - Accumulated Balance Audit Trail
RFKLET00 - Extract for the Accumulated Historical Balance Audit Trail
RFKLET00 - Extract for the Accumulated Historical Balance Audit Trail
RFKLBU10_NACC - Account Details from Historical Accumulated Balance Audit Trail
RFKLBU10_NACC - Account Details from Historical Accumulated Balance Audit Trail