SAPF101 SAP ABAP Report - Balance Sheet Supplement - OI - Analysis per &
SAPF101 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program groups the receivables and payables according to a required list (for example, "EU Guideline 4") and performs transfer postings...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 SAPF101 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
F101 - ABAP/4 Reporting: Balance Sheet Adj.
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 SAPF101. "Basic submit
SUBMIT SAPF101 AND RETURN. "Return to original report after report execution complete
SUBMIT SAPF101 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: DK_WBRSL = D .
Selection Text: DKONTO = D .
Selection Text: BUKRS = D .
Selection Text: BELNR = D .
Selection Text: AKONTO = D .
Selection Text: UMBWM = Use Valuations
Selection Text: STICHTAG = Balance Sheet Key Date
Selection Text: SKONTO = G/L Account Number
Selection Text: P_ZBUKRS = Target Company Code
Selection Text: P_SSALDO = G/L Accounts Group Definition
Selection Text: P_SBLART = Reversal Document Type
Selection Text: P_LVARS = Totals List Variant
Selection Text: P_LVAR = List Variant
Selection Text: P_LSAVE = Save Log
Selection Text: P_LDSCR = Log Name
Selection Text: P_LDISP = Output Log
Selection Text: P_KSALDO = Vendor Group Definition
Selection Text: P_FILE = Generate File
Selection Text: P_DSALDO = Customer Group Definition
Selection Text: P_CURTP1 = Valuation in Currency Type
Selection Text: KONTOART = Account Type (D/K/S)
Selection Text: KK_UMSKZ = Special General Ledger Vendor
Selection Text: GESBER = D .
Selection Text: XALTKT = D .
Selection Text: WV_BWERT = D .
Selection Text: VERBUND = D .
Selection Text: TITLE = D .
Selection Text: P_VBUND = D .
Selection Text: P_SBUPEM = D .
Selection Text: P_SBUDAT = D .
Selection Text: P_METHD = D .
Selection Text: P_LVIEW = D .
Selection Text: P_FLNAM = D .
Selection Text: P_CHG_AC = D .
Selection Text: P_BWBER = D .
Selection Text: P_BLDAT = D .
Selection Text: P_BLART = D .
Selection Text: P_BKTXT = D .
Selection Text: P_BBUPEM = D .
Selection Text: P_BBUDAT = D .
Selection Text: PA_WAERS = D .
Selection Text: PAR_BNAM = D .
Selection Text: PAR_BI = D .
Selection Text: KKONTO = D .
Selection Text: INV_KZ = D .
Selection Text: DK_UMSKZ = Special Gen. Ledger Customer
Title: Balance Sheet Supplement - OI - Analysis per &
Text Symbol: 115 = Amount in FC
Text Symbol: 114 = Amount in LC
Text Symbol: 112 = Exchange Rate
Text Symbol: 111 = Amount Valuated
Text Symbol: 102 = Key Date
Text Symbol: 082 = Totals List
Text Symbol: 080 = List
Text Symbol: 045 = Spool Number:
Text Symbol: 044 = Messages for SAPF101
Text Symbol: 037 = SAP (EU 93 F/S Guidelines)
Text Symbol: 036 = Payables Within 1 Year
Text Symbol: 035 = Receivables Within 1 Year
Text Symbol: 030 = Only single values permitted
Text Symbol: 020 = SAPF101 Reverse Posting
Text Symbol: 019 = SAPF101 B/S Adjustment
Text Symbol: 013 = Dynamic Selections
Text Symbol: 006 = Error when opening file
Text Symbol: 005 = Number of Data Records
Text Symbol: 004 = Generated File:
Text Symbol: 003 = Selections
Text Symbol: 002 = Postings
Text Symbol: 001 = Parameters
Text Symbol: V02 = Save Log (Name)
Text Symbol: V01 = View cannot be used
Text Symbol: S14 = Group
Text Symbol: S12 = Error in Field Assignment COBL -> GLU1
Text Symbol: 402 = Incorrect posting
Text Symbol: 271 = Active
Text Symbol: 270 = Custom Selections
Text Symbol: 265 = Changed Partner Old &V1 New &V2
Text Symbol: 264 = Investments Transfer Posting
Text Symbol: 263 = Changed Reconc. Acct Old &V1 New &V2
Text Symbol: 245 = Error
Text Symbol: 244 = Posting(s) in Ledger
Text Symbol: 243 = Postings in Batch Input Session
Text Symbol: 242 = Posting Proposal
Text Symbol: 241 = Postings Generated
Text Symbol: 240 = Error when opening the session
Text Symbol: 200 = No text
Text Symbol: 121 = Indic. A00
Text Symbol: 120 = Prev.rec.led
Text Symbol: 119 = Old Partner
Text Symbol: 118 = Local Currency
Text Symbol: 116 = Account
INCLUDES used within this REPORT SAPF101
INCLUDE SBAL_CONSTANTS.
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:
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = 'B' TABLES xbukreis = bukrs.
DETERMINE_DUE_DATE CALL FUNCTION 'DETERMINE_DUE_DATE' EXPORTING i_faede = x_faede IMPORTING e_faede = x_faede EXCEPTIONS OTHERS = 1.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING i_bukrs = i_bukrs IMPORTING e_x001 = x001 EXCEPTIONS OTHERS = 0.
VALUATION_GET_OLD_VALUE CALL FUNCTION 'VALUATION_GET_OLD_VALUE' EXPORTING i_bwber = p_bwber i_umbwm = umbwm_tab i_curtp = t033-curtp * I_KUNNR = BELEGE-KONTO x_curr = 'X' x_curr_value = wr_diff "input i_belnr = belege-belnr i_bukrs = belege-bukrs i_gjahr = belege-gjahr i_buzei = belege-buzei IMPORTING old_difference = old_diff "summ der differences EXCEPTIONS OTHERS = 0.
READ_SKA1 CALL FUNCTION 'READ_SKA1' EXPORTING xktopl = ktopl xsaknr = ska1-saknr IMPORTING xska1 = ska1 xskat = skat EXCEPTIONS OTHERS = 4.
FI_FIELD_SELECTION_DETERMINE CALL FUNCTION 'FI_FIELD_SELECTION_DETERMINE' EXPORTING i_bschl = pa_buschl i_bukrs = pa_bukrs i_saknr = pa_saknr IMPORTING e_faus1 = tbsl-faus1 e_faus2 = tbsl-faus2 EXCEPTIONS error_message = 4 OTHERS = 4.
GET_FIELDTAB CALL FUNCTION 'GET_FIELDTAB' EXPORTING tabname = 'SAPF100_OUTIN' TABLES fieldtab = inttab EXCEPTIONS OTHERS = 1.
FUNCTION_EXISTS CALL FUNCTION 'FUNCTION_EXISTS' EXPORTING funcname = 'K_PCA_GET_BALANCE_FLAG' EXCEPTIONS function_not_exist = 1 OTHERS = 2.
K_PCA_GET_BALANCE_FLAG CALL FUNCTION 'K_PCA_GET_BALANCE_FLAG' EXPORTING i_bukrs = ibukrs IMPORTING e_biact = eflag EXCEPTIONS OTHERS = 7.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING i_function = func i_group = par_bnam i_keep = 'X' i_mode = mode i_user = user * create batch input when error occurs *not i_xbdcc = 'X' EXCEPTIONS error_message = 1 OTHERS = 6.
POSTING_INTERFACE_END CALL FUNCTION 'POSTING_INTERFACE_END'.
VALUATION_SL_POSTINGS CALL FUNCTION 'VALUATION_SL_POSTINGS' EXPORTING i_bwber = p_bwber i_new_awref = g_new_awref i_comp = 'GL' old_awref = g_awref_old IMPORTING e_awref = g_awref TABLES t_bkpf = t_bkpf t_bseg = t_bseg EXCEPTIONS error_message = 1 OTHERS = 1.
POSTING_INTERFACE_DOCUMENT CALL FUNCTION 'POSTING_INTERFACE_DOCUMENT' EXPORTING i_tcode = 'FBB1' IMPORTING e_subrc = subrc e_msgid = fimsg-msgid e_msgty = fimsg-msgty e_msgno = fimsg-msgno e_msgv1 = fimsg-msgv1 e_msgv2 = fimsg-msgv2 e_msgv3 = fimsg-msgv3 e_msgv4 = fimsg-msgv4 TABLES t_ftpost = ftpost t_blntab = xblntab t_fttax = xfttax EXCEPTIONS error_message = 1 OTHERS = 9.
RS_REFRESH_FROM_SELECTOPTIONS CALL FUNCTION 'RS_REFRESH_FROM_SELECTOPTIONS' EXPORTING curr_report = 'SAPF101' TABLES selection_table = gt_params.
BAL_LOG_MSG_CUMULATE CALL FUNCTION 'BAL_LOG_MSG_CUMULATE' EXPORTING i_s_msg = ls_msg i_compare_attributes = 'X' i_compare_context = 'X' i_compare_parameters = 'X' EXCEPTIONS log_not_found = 0 msg_inconsistent = 2.
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_callback_program = h_repid i_callback_pf_status_set = h_set_pf_status i_callback_user_command = h_user_command i_default = 'X' is_layout = t_slis_layout_alv is_print = t_slis_print_alv it_events = t_events[] it_fieldcat = t_fieldcat[] i_save = 'A' is_variant = h_variant TABLES t_outtab = list_item EXCEPTIONS program_error = 1 OTHERS = 2.
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = h_repid i_internal_tabname = i_tab i_inclname = h_repid " i_client_never_display = 'X' i_bypassing_buffer = 'X' CHANGING ct_fieldcat = ti_fieldcat[] EXCEPTIONS OTHERS = 3.
REUSE_ALV_EVENTS_GET CALL FUNCTION 'REUSE_ALV_EVENTS_GET' EXPORTING i_list_type = 1 IMPORTING et_events = t_event[] EXCEPTIONS list_type_wrong = 1 OTHERS = 2.
REUSE_ALV_LIST_LAYOUT_INFO_GET CALL FUNCTION 'REUSE_ALV_LIST_LAYOUT_INFO_GET' IMPORTING et_sort = t_slis_sort EXCEPTIONS OTHERS = 0.
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = gt_list_top_of_page.
GET_FIELDTAB * CALL FUNCTION 'GET_FIELDTAB' * EXPORTING * tabname = itabname * TABLES * fieldtab = inttab * EXCEPTIONS * OTHERS = 1.
FI_POSTINGS_ALV CALL FUNCTION 'FI_POSTINGS_ALV' EXPORTING i_headline = hd_txt is_variant = l_variant "n1324482 i_acc_principle = g_acc_principle is_layout = t_slis_layout_alv TABLES t_doc_hdr = t_header t_doc_lines = t_item.
BAL_DSP_LOG_PRINT CALL FUNCTION 'BAL_DSP_LOG_PRINT' EXPORTING * I_S_PRINT_OPTIONS = i_s_list_append = t_slis_layout_alv-list_append * I_S_DISPLAY_PROFILE = * I_T_LOG_HANDLE = * I_T_MSG_HANDLE = * I_S_LOG_FILTER = * I_S_MSG_FILTER = * I_T_LOG_CONTEXT_FILTER = * I_T_MSG_CONTEXT_FILTER = EXCEPTIONS * PROFILE_INCONSISTENT = 1 * INTERNAL_ERROR = 2 * NO_DATA_AVAILABLE = 3 * NO_AUTHORITY = 4 OTHERS = 5.
BAL_DSP_LOG_DISPLAY CALL FUNCTION 'BAL_DSP_LOG_DISPLAY' EXCEPTIONS OTHERS = 1.
FI_MESSAGES_ALV CALL FUNCTION 'FI_MESSAGES_ALV' EXPORTING i_headline = text-044 is_variant = h_variant is_layout = t_slis_layout_alv EXCEPTIONS OTHERS = 0.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING i_fimsg = fimsg i_xappn = ' ' EXCEPTIONS OTHERS = 0.
BAL_LOG_MSG_CUMULATE CALL FUNCTION 'BAL_LOG_MSG_CUMULATE' EXPORTING * I_LOG_HANDLE = i_s_msg = l_s_msg i_compare_attributes = 'X' i_compare_context = 'X' i_compare_parameters = 'X' * IMPORTING * E_S_MSG_HANDLE = * E_MSG_WAS_LOGGED = * E_MSG_WAS_DISPLAYED = EXCEPTIONS log_not_found = 0 msg_inconsistent = 2 * OTHERS = 3 .
BAL_LOG_CREATE CALL FUNCTION 'BAL_LOG_CREATE' EXPORTING i_s_log = g_s_log EXCEPTIONS OTHERS = 1.
MONTH_PLUS_DETERMINE CALL FUNCTION 'MONTH_PLUS_DETERMINE' EXPORTING months = t044l-duevl olddate = x_t044l-gtdatum IMPORTING newdate = x_t044l-gtdatum.
MONTH_PLUS_DETERMINE CALL FUNCTION 'MONTH_PLUS_DETERMINE' EXPORTING months = t044l-duevl olddate = x_t044l-gtdatum IMPORTING newdate = x_t044l-gtdatum.
KPEP_MONI_INIT_RECORD CALL FUNCTION 'KPEP_MONI_INIT_RECORD' EXPORTING ls_detail = ls_detail ls_witem = ls_witem * LS_APPL = * LD_WORKLIST_FLAG = ' ' IMPORTING ls_key = ls_key_static TABLES lt_selkrit = lt_selkrit lt_param = lt_param.
KPEP_MONI_CLOSE_RECORD CALL FUNCTION 'KPEP_MONI_CLOSE_RECORD' EXPORTING ls_key = ls_key_static * LS_MESSAGE = ls_message * LD_OBJECTS = * LS_EXT = * LS_RL = ls_scma_event = ls_scma_event TABLES lt_spool = gt_spono CHANGING ld_aplstat = ld_aplstat EXCEPTIONS * NO_ID_GIVEN = 1 OTHERS = 0.
FREE_SELECTIONS_INIT CALL FUNCTION 'FREE_SELECTIONS_INIT' EXPORTING kind = 'T' * Alte Abgrenzungen erscheinen wieder expressions = fs_dyns-texpr * FIELD_GROUPS_KEY = * RESTRICTION = * ALV = * CURR_QUAN_PROG = SY-CPROG * CURR_QUAN_RELATION = IMPORTING selection_id = selection_id where_clauses = fs_dyns-clauses expressions = fs_dyns-texpr field_ranges = fs_dyns-trange number_of_active_fields = fs_num TABLES tables_tab = tables_tab fields_tab = fields * FIELD_DESC = * FIELD_TEXTS = * EVENTS = * EVENT_FIELDS = fields_not_selected = fields_not EXCEPTIONS fields_incomplete = 1 fields_no_join = 2 field_not_found = 3 no_tables = 4 table_not_found = 5 expression_not_supported = 6 incorrect_expression = 7 illegal_kind = 8 area_not_found = 9 inconsistent_area = 10 kind_f_no_fields_left = 11 kind_f_no_fields = 12 too_many_fields = 13 dup_field = 14 field_no_type = 15 field_ill_type = 16 dup_event_field = 17 node_not_in_ldb = 18 area_no_field = 19 OTHERS = 20.
FREE_SELECTIONS_DIALOG CALL FUNCTION 'FREE_SELECTIONS_DIALOG' EXPORTING selection_id = selection_id title = 'Freie Selektion '(013) * FRAME_TEXT = ' ' * STATUS = * AS_WINDOW = ' ' * START_ROW = 2 * START_COL = 2 * NO_INTERVALS = ' ' * JUST_DISPLAY = ' ' * PFKEY = * ALV = ' ' * TREE_VISIBLE = 'X' * DIAG_TEXT_1 = * DIAG_TEXT_2 = * WARNING_TITLE = IMPORTING where_clauses = fs_dyns-clauses expressions = fs_dyns-texpr field_ranges = fs_dyns-trange number_of_active_fields = fs_num TABLES fields_tab = fields * FCODE_TAB = fields_not_selected = fields_not EXCEPTIONS * internal_error = * no_action = * selid_not_found = * illegal_status = OTHERS = 0.
FREE_SELECTIONS_RANGE_2_WHERE CALL FUNCTION 'FREE_SELECTIONS_RANGE_2_WHERE' EXPORTING field_ranges = fs_dyns-trange IMPORTING where_clauses = fs_dyns-clauses.
FI_LIST_VARIANTS_PREVIEW_ALV CALL FUNCTION 'FI_LIST_VARIANTS_PREVIEW_ALV' EXPORTING i_repid = irepid i_list_form = iform_name TABLES t_outtab = list_item.
ACC_TARGET_LEDGER_READ * CALL FUNCTION 'ACC_TARGET_LEDGER_READ' * EXPORTING * ID_ACC_PRINCIPLE = e_acc_principle * IMPORTING * ED_TARGET_LEDGER = e_ledger * EXCEPTIONS * OTHERS = 2.
FAGL_CHECK_GLFLEX_ACTIVE CALL FUNCTION 'FAGL_CHECK_GLFLEX_ACTIVE' EXPORTING id_bukrs = cga_bukrs IMPORTING e_glflex_active = ld_active.
BAL_LOG_MSG_CUMULATE CALL FUNCTION 'BAL_LOG_MSG_CUMULATE' EXPORTING i_s_msg = l_s_msg * I_LOG_HANDLE = * importing * E_MSG_WAS_LOGGED = G_E_MSG EXCEPTIONS log_not_found = 0 OTHERS = 1.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING i_fimsg = fimsg i_xappn = ' ' EXCEPTIONS OTHERS = 01.
FB_SELECTIONS_DISPLAY CALL FUNCTION 'FB_SELECTIONS_DISPLAY' EXPORTING ed_program = sy-repid et_selections = gt_params et_dynamic_selections = fs_dyns-trange ed_mode = '1'.
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 SAPF101 or its description.