RTPM_TRAC_ACCSYMGLCUST_UPLOAD SAP ABAP Report - Excel Upload for G/L Account Determination Customizing

RTPM_TRAC_ACCSYMGLCUST_UPLOAD is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for With this function, you can upload entries to the Assignment of G/L Accounts to Account Symbols screen, which you can access in the IMG activity under Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Account Determination ...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 RTPM_TRAC_ACCSYMGLCUST_UPLOAD into the relevant SAP transactions such as SE38 or SE80

Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

TPM_ACCSYMGL_UPLOAD - Assign G/L Accts to Acc. Sym. Upload

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.

Text pool values

INCLUDES used within this REPORT RTPM_TRAC_ACCSYMGLCUST_UPLOAD

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:

CONVERSION_EXIT_NUMCV_INPUT
    CALL FUNCTION 'CONVERSION_EXIT_NUMCV_INPUT'
      EXPORTING
        input  = ls_excel_data-gl_account
      IMPORTING
        output = ls_excel_data-gl_account.

CONVERSION_EXIT_NUMCV_INPUT
    CALL FUNCTION 'CONVERSION_EXIT_NUMCV_INPUT'
      EXPORTING
        input  = ls_excel_data-valuation_area
      IMPORTING
        output = ls_excel_data-valuation_area.

VIEW_GET_CLIENT_STATE
    CALL FUNCTION 'VIEW_GET_CLIENT_STATE'
      IMPORTING
        transp_state = lv_transstate.

TR_REQUEST_CHOICE
      CALL FUNCTION 'TR_REQUEST_CHOICE'
        EXPORTING
          iv_request_types     = 'KW'
        IMPORTING
          es_request           = ls_request
        EXCEPTIONS
          invalid_request      = 1
          invalid_request_type = 2
          user_not_owner       = 3
          no_objects_appended  = 4
          enqueue_error        = 5
          cancelled_by_user    = 6
          recursive_call       = 7
          OTHERS               = 8.

TEXT_CONVERT_XLS_TO_SAP
  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*     I_FIELD_SEPERATOR    =
      i_line_header        = tpmco_xtrue
      i_tab_raw_data       = lt_raw_data
      i_filename           = uv_file
    TABLES
      i_tab_converted_data = ct_excel_data
    EXCEPTIONS
      conversion_failed    = 1
      OTHERS               = 2.

BAL_LOG_CREATE
  CALL FUNCTION 'BAL_LOG_CREATE'
    EXPORTING
      i_s_log                 = ls_log_header
    IMPORTING
      e_log_handle            = cv_log_handle
    EXCEPTIONS
      log_header_inconsistent = 1
      OTHERS                  = 2.

TR_OBJECTS_CHECK
  CALL FUNCTION 'TR_OBJECTS_CHECK'
    TABLES
      wt_ko200                = lt_ko200
      wt_e071k                = lt_e071k
    EXCEPTIONS
      cancel_edit_other_error = 1
      show_only_other_error   = 2
      OTHERS                  = 3.

TR_OBJECTS_INSERT
    CALL FUNCTION 'TR_OBJECTS_INSERT'
      EXPORTING
        wi_order                = uv_request
      TABLES
        wt_ko200                = lt_ko200
        wt_e071k                = lt_e071k
      EXCEPTIONS
        cancel_edit_other_error = 1
        show_only_other_error   = 2
        OTHERS                  = 3.

FI_GL_READ_CHART_OF_ACCOUNT
    CALL FUNCTION 'FI_GL_READ_CHART_OF_ACCOUNT'
      EXPORTING
        i_ktopl                    = cs_excel_data-chart_of_acc
      EXCEPTIONS
        chart_of_account_not_found = 1
        OTHERS                     = 2.

BAL_LOG_MSG_ADD
  CALL FUNCTION 'BAL_LOG_MSG_ADD'
    EXPORTING
      i_log_handle     = uv_log_handle
      i_s_msg          = cs_log_msg
    EXCEPTIONS
      log_not_found    = 1
      msg_inconsistent = 2
      log_is_full      = 3
      OTHERS           = 4.

TPM_TRAC_ACCSYMGLCUST_UPDATE
    CALL FUNCTION 'TPM_TRAC_ACCSYMGLCUST_UPDATE' IN UPDATE TASK
      TABLES
        it_input_data = ut_insert_data.

BAL_DB_SAVE
  CALL FUNCTION 'BAL_DB_SAVE'
    EXPORTING
      i_in_update_task = tpmco_xtrue
      i_save_all       = tpmco_xtrue
      i_t_log_handle   = ut_log_handle
    EXCEPTIONS
      log_not_found    = 1
      save_not_allowed = 2
      numbering_error  = 3
      OTHERS           = 4.

BAL_DSP_PROFILE_SINGLE_LOG_GET
  CALL FUNCTION 'BAL_DSP_PROFILE_SINGLE_LOG_GET'
    IMPORTING
      e_s_display_profile = ls_display_profile.

BAL_DSP_LOG_DISPLAY
  CALL FUNCTION 'BAL_DSP_LOG_DISPLAY'
    EXPORTING
      i_s_display_profile  = ls_display_profile
      i_t_log_handle       = ut_log_handle
    EXCEPTIONS
      profile_inconsistent = 1
      internal_error       = 2
      no_data_available    = 3
      no_authority         = 4
      OTHERS               = 5.