SAP Reports / Programs
SAPDBSDF SAP ABAP Report - SAPDBSDF Logical Database
SAPDBSDF is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Report SAPDBSDF controls the access to the G/L account data base from a Financial Accounting point of view...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 SAPDBSDF 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 SAPDBSDF. "Basic submit
SUBMIT SAPDBSDF AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBSDF 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: ALCUR = Alternative local currency
Selection Text: EXCDT = Translation date
Selection Text: SD_AUGDT = Clearing date
Selection Text: SD_BUKRS = Company code
Selection Text: SD_CURTP = Currency type
Selection Text: SD_GJAHR = Fiscal Year
Selection Text: SD_GSB_B = Business area
Selection Text: SD_GSB_S = Business area
Selection Text: SD_KTOPL = Chart of accounts
Selection Text: SD_RLDNR = D Ledger
Selection Text: SD_SAKNR = G/L account
Selection Text: SD_STIDA = Open items at key date
Selection Text: XX_CURTP = Currency type
Selection Text: SD_INDEX = ?...(SD_INDEX)
Title: SAPDBSDF Logical Database
Text Symbol: SRC = Data Sources
Text Symbol: 950 = Standard screen
Text Symbol: 908 = Variant 8: Without chart of accounts and item selections
Text Symbol: 907 = Variant 7: Without chart of accts, OI key date and clrg date
Text Symbol: 906 = Variant 6: all entry fields
Text Symbol: 904 = Variant 5: Only chart/accts, G/L acct number and company code
Text Symbol: 903 = Variant 4: Without chart/accts and company code
Text Symbol: 902 = Variant 3: With currency key
Text Symbol: 000 = G/L account selection
Text Symbol: 001 = Matchcode
Text Symbol: 002 = Doc. Number
Text Symbol: 003 = not found
Text Symbol: 004 = For document
Text Symbol: 005 = in company code
Text Symbol: 006 = no items were found
Text Symbol: 007 = Document header for company code
Text Symbol: 008 = Acct type
Text Symbol: 013 = Archived documents were selected
Text Symbol: 014 = is not in view/table
Text Symbol: 015 = . Cannot be accessed.
Text Symbol: 021 = Alternative local currency
Text Symbol: 022 = Translation date
Text Symbol: 023 = Transaction Figures Selection
Text Symbol: 024 = Line item selection
Text Symbol: 025 = Alternative Currency
Text Symbol: 060 = Ledger selection
Text Symbol: 061 = Select a ledger for displaying
Text Symbol: 062 = the transaction figures
Text Symbol: 100 = Chart of accounts $1 for account $2 no longer exists
Text Symbol: 900 = Variant 1: Only selection of open items
Text Symbol: 901 = Variant 2: Only selection of cleared items
INCLUDES used within this REPORT SAPDBSDF
INCLUDE RFDBEXPC.
INCLUDE RFDBINCLUD1.
INCLUDE RFDBINCLUD2.
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:
CURRENCY_CHECK_FOR_PROCESS CALL FUNCTION 'CURRENCY_CHECK_FOR_PROCESS' EXPORTING process = 'SAPDBSDF' EXCEPTIONS process_not_maintained = 1 OTHERS = 2.
FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING i_bukrs = space i_user = sy-uname i_program = 'SAPDBSDF' IMPORTING e_return = ld_return EXCEPTIONS no_authority_prog = 1 no_authority_date = 2 wrong_parameter = 3 OTHERS = 4.
FUNCTION_EXISTS CALL FUNCTION 'FUNCTION_EXISTS' EXPORTING funcname = 'CA_WRITE_LOG' EXCEPTIONS function_not_exist = 1 OTHERS = 2.
FAGL_CHECK_GLFLEX_ACTIVE CALL FUNCTION 'FAGL_CHECK_GLFLEX_ACTIVE' IMPORTING e_glflex_active = g_glflex_active EXCEPTIONS error_in_setup = 1 OTHERS = 2.
FAGL_BUKRS_ACTIVE_IN_CLIENT CALL FUNCTION 'FAGL_BUKRS_ACTIVE_IN_CLIENT' IMPORTING e_glflex_active = g_glflex_act_cc.
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = database TABLES xbukreis = sd_bukrs.
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = 'B' TABLES xbukreis = sd_bukrs.
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = database TABLES xbukreis = sd_bukrs.
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = 'B' TABLES xbukreis = sd_bukrs.
TP_VALUATION_AUTHORITY CALL FUNCTION 'TP_VALUATION_AUTHORITY' EXPORTING i_bukrs = kbtab-bukrs i_cvtyp = sd_curtp IMPORTING e_xauth = l_tp_auth EXCEPTIONS kokrs_finding_error = 1 valutyp_finding_error = 2 insufficient_input_for_kokrs = 3 insufficient_input_for_valutyp = 4 activity_not_allowed = 5 OTHERS = 6.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING i_bukrs = kbtab-bukrs IMPORTING e_x001 = x001.
G_GIVE_LEDGERS_FOR_GLT0 CALL FUNCTION 'G_GIVE_LEDGERS_FOR_GLT0' EXPORTING bukrs = kbtab-bukrs curtp = sd_curtp ed_nledger = g_rldnr "n1262139 TABLES ledtab = ledtab.
FAGL_GET_LEADING_LEDGER CALL FUNCTION 'FAGL_GET_LEADING_LEDGER' IMPORTING e_rldnr = g_lead_rldnr EXCEPTIONS not_found = 1 OTHERS = 2.
FAGL_AUTHORITY_LEDGER CALL FUNCTION 'FAGL_AUTHORITY_LEDGER' "1531154 EXPORTING "1531154 i_bukrs = kbtab-bukrs "1531154 i_rldnr = g_rldnr "1531154 i_actvt = '03'. "1531154
AS_DATASOURCE_SELECT CALL FUNCTION 'AS_DATASOURCE_SELECT' EXPORTING i_db_and_arc = 'X' i_no_source_select = space i_infosys_possible = 'X' i_documentation = 'DEFAULT' i_report = ld_progname i_reporttype = space it_objects = lt_objects[] CHANGING c_use_database = sd_usedb c_use_archive = sd_usear c_use_infosys = sd_useas c_archobj = sd_objec ct_arch_sel = sd_files[].
ARCHIVE_ADMIN_DEFINE_FILTER CALL FUNCTION 'ARCHIVE_ADMIN_DEFINE_FILTER' EXPORTING status_deleted_only = 'X'.
AS_DATASOURCE_SELECT CALL FUNCTION 'AS_DATASOURCE_SELECT' EXPORTING i_db_and_arc = 'X' i_no_source_select = space i_infosys_possible = 'X' i_documentation = 'DEFAULT' it_objects = lt_objects[] CHANGING c_use_database = sd_usdb1 c_use_archive = sd_usar1 c_use_infosys = sd_usas1 c_archobj = sd_obje1 ct_arch_sel = sd_file1[].
ARCHIVE_ADMIN_DEFINE_FILTER CALL FUNCTION 'ARCHIVE_ADMIN_DEFINE_FILTER' EXPORTING status_deleted_only = 'X'.
AS_DATASOURCE_SELECT CALL FUNCTION 'AS_DATASOURCE_SELECT' EXPORTING i_db_and_arc = 'X' i_no_source_select = space i_infosys_possible = 'X' i_documentation = 'DEFAULT' it_objects = lt_objects[] CHANGING c_use_database = sd_usdb2 c_use_archive = sd_usar2 c_use_infosys = sd_usas2 c_archobj = sd_obje2 ct_arch_sel = sd_file2[].
FAGL_CHECK_GLFLEX_ACTIVE CALL FUNCTION 'FAGL_CHECK_GLFLEX_ACTIVE' IMPORTING e_glflex_active = g_glflex_active EXCEPTIONS error_in_setup = 1 OTHERS = 2.
FAGL_BUKRS_ACTIVE_IN_CLIENT CALL FUNCTION 'FAGL_BUKRS_ACTIVE_IN_CLIENT' IMPORTING e_glflex_active = g_glflex_act_cc.
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = database TABLES xbukreis = sd_bukrs.
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING xdatabase = 'B' TABLES xbukreis = sd_bukrs.
TP_VALUATION_AUTHORITY CALL FUNCTION 'TP_VALUATION_AUTHORITY' EXPORTING i_bukrs = kbtab-bukrs i_cvtyp = sd_curtp IMPORTING e_xauth = l_tp_auth EXCEPTIONS kokrs_finding_error = 1 valutyp_finding_error = 2 insufficient_input_for_kokrs = 3 insufficient_input_for_valutyp = 4 activity_not_allowed = 5 OTHERS = 6.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING i_bukrs = kbtab-bukrs IMPORTING e_x001 = x001.
G_GIVE_LEDGERS_FOR_GLT0 CALL FUNCTION 'G_GIVE_LEDGERS_FOR_GLT0' EXPORTING bukrs = kbtab-bukrs curtp = sd_curtp TABLES ledtab = ledtab.
FAGL_GET_LEADING_LEDGER CALL FUNCTION 'FAGL_GET_LEADING_LEDGER' IMPORTING e_rldnr = g_lead_rldnr EXCEPTIONS not_found = 1 OTHERS = 2.
FAGL_AUTHORITY_LEDGER CALL FUNCTION 'FAGL_AUTHORITY_LEDGER' "1531154 EXPORTING "1531154 i_bukrs = kbtab-bukrs "1531154 i_rldnr = g_rldnr "1531154 i_actvt = '03'. "1531154
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'.
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'.
READ_T001 CALL FUNCTION 'READ_T001' EXPORTING xbukrs = skb1-bukrs IMPORTING struct = t001.
LDB_LOG_WRITE * call function 'LDB_LOG_WRITE'.
CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE * call function 'LDB_LOG_WRITE'.
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'. "1344830
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'.
LDB_LOG_WRITE CALL FUNCTION 'LDB_LOG_WRITE'.
FAGL_GET_SUM_ARCH CALL FUNCTION 'FAGL_GET_SUM_ARCH' EXPORTING i_glt0_rldnr = xx_rldnr-low i_rldnr = g_rldnr i_range_rrcty = sd_stype[] i_range_rvers = version[] i_range_bukrs = sd_bukrs[] i_range_ryear = sd_gjahr[] i_range_rbusa = sd_gsber[] i_range_racct = k_saknr[] it_where_clause = faglfreesel_where i_authority_check = 'X' IMPORTING et_glt0 = lt_glt0 TABLES i_arch_sel = sd_file1[] EXCEPTIONS no_infostruc_found = 1 selections_error = 2.
FAGL_GET_GLT0 CALL FUNCTION 'FAGL_GET_GLT0' EXPORTING i_glt0_rldnr = xx_rldnr-low i_rldnr = g_rldnr * I_RRCTY = * I_RVERS = * i_bukrs = * I_RYEAR = * I_RACCT = * I_RBUSA = * I_RTCUR = * I_DRCRK = * I_RPMAX = i_range_rrcty = sd_stype[] i_range_rvers = version[] i_range_bukrs = sd_bukrs[] i_range_ryear = sd_gjahr[] i_range_rbusa = sd_gsber[] i_range_racct = k_saknr[] * I_RANGE_RTCUR = * I_RANGE_DRCRK = * I_RANGE_RPMAX = it_where_clause = faglfreesel_where i_authority_check = 'X' i_curtp = sd_curtp "1811139 IMPORTING et_glt0 = xglt0[].
FAGL_GET_SUM_ARCH CALL FUNCTION 'FAGL_GET_SUM_ARCH' EXPORTING i_glt0_rldnr = xx_rldnr-low i_rldnr = g_rldnr i_range_rrcty = sd_stype[] i_range_rvers = version[] i_range_bukrs = sd_bukrs[] i_range_ryear = sd_gjahr[] i_range_rbusa = sd_gsber[] i_range_racct = k_saknr[] it_where_clause = faglfreesel_where i_authority_check = 'X' IMPORTING et_glt0 = lt_glt0 TABLES i_arch_sel = sd_file2[].
FAGL_GET_GLT0 CALL FUNCTION 'FAGL_GET_GLT0' EXPORTING i_glt0_rldnr = xx_rldnr-low i_rldnr = g_rldnr * I_RRCTY = * I_RVERS = * i_bukrs = * I_RYEAR = * I_RACCT = * I_RBUSA = * I_RTCUR = * I_DRCRK = * I_RPMAX = i_range_rrcty = sd_stype[] i_range_rvers = version[] i_range_bukrs = sd_bukrs[] i_range_ryear = sd_gjahr[] i_range_rbusa = sd_gsber[] i_range_racct = k_saknr[] * I_RANGE_RTCUR = * I_RANGE_DRCRK = * I_RANGE_RPMAX = it_where_clause = faglfreesel_where i_curtp = sd_curtp "1811139 IMPORTING et_glt0 = xglt0[].
INIT_T001 CALL FUNCTION 'INIT_T001' TABLES xbukreis = sd_bukrs.
RS_REFRESH_FROM_DYNAMICAL_SEL CALL FUNCTION 'RS_REFRESH_FROM_DYNAMICAL_SEL' EXPORTING curr_report = sy-cprog mode_write_or_move = 'M' IMPORTING p_trange = gt_dyn_trange EXCEPTIONS not_found = 1 wrong_type = 2 OTHERS = 3.
FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING i_bukrs = skc1a-bukrs i_user = sy-uname i_program = 'SAPDBSDF' i_from_year = skc1a-gjahr EXCEPTIONS no_authority_prog = 1 no_authority_date = 2 wrong_parameter = 3 OTHERS = 4.
FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING i_bukrs = skc1c-bukrs i_user = sy-uname i_program = 'SAPDBSDF' i_from_year = skc1c-gjahr EXCEPTIONS no_authority_prog = 1 no_authority_date = 2 wrong_parameter = 3 OTHERS = 4.
FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING i_bukrs = bsis-bukrs i_user = sy-uname i_program = 'SAPDBSDF' i_from_date = ld_date EXCEPTIONS no_authority_prog = 1 no_authority_date = 2 wrong_parameter = 3 OTHERS = 4.
FI_F4_CURTP CALL FUNCTION 'FI_F4_CURTP' EXPORTING i_xct10 = 'X' IMPORTING e_curtp = sd_curtp.
FI_F4_CURTP CALL FUNCTION 'FI_F4_CURTP' EXPORTING i_xct00 = 'X' i_xct10 = 'X' IMPORTING e_curtp = xx_curtp-low.
FI_F4_CURTP CALL FUNCTION 'FI_F4_CURTP' EXPORTING i_xct00 = 'X' i_xct10 = 'X' IMPORTING e_curtp = xx_curtp-high.
G_DISPLAY_SELECTION_DYNPRO CALL FUNCTION 'G_DISPLAY_SELECTION_DYNPRO' EXPORTING dynp_title = title sel_title1 = title1 sel_title2 = title2 start_column = 05 start_row = 08 without_selection = ' ' IMPORTING sel_index = sy-tabix TABLES sel_table = f4tab EXCEPTIONS no_lines = 4 no_line_picked = 8.
FI_CHECK_DATE CALL FUNCTION 'FI_CHECK_DATE' EXPORTING i_bukrs = it001-bukrs i_user = sy-uname i_program = 'SAPDBSDF' i_from_year = sd_gjahr-low i_to_year = sd_gjahr-high EXCEPTIONS no_authority_prog = 1 no_authority_date = 2 wrong_parameter = 3 OTHERS = 4.
CA_WRITE_LOG CALL FUNCTION 'CA_WRITE_LOG' "#EC EXISTS EXPORTING i_program = sy-cprog EXCEPTIONS write_error = 1 OTHERS = 2.
LDB_LOG_INIT CALL FUNCTION 'LDB_LOG_INIT'.
LDB_LOG_DISPLAY CALL FUNCTION 'LDB_LOG_DISPLAY'.
AS_DATASOURCE_INIT CALL FUNCTION 'AS_DATASOURCE_INIT' EXPORTING i_report = l_progname i_reporttype = space IMPORTING e_use_database = r_usedb e_use_archive = r_usear e_use_infosys = r_useas et_arch_sel = rt_files[].
FI_DOCUMENT_ARCH_AS_ITEMS_READ CALL FUNCTION 'FI_DOCUMENT_ARCH_AS_ITEMS_READ' "#EC ENHOK EXPORTING i_selections = gt_selections i_convert_currency = ld_convert_currency i_show_errors = ld_errors i_show_progess = ld_progress TABLES e_bkpf = ybkpf e_bseg = ybseg e_bsis = ybsis e_bsas = ybsas i_arch_sel = sd_files[] EXCEPTIONS no_infostruc_found = 1 selections_error = 2.
FREE_SELECTIONS_WHERE_2_RANGE CALL FUNCTION 'FREE_SELECTIONS_WHERE_2_RANGE' EXPORTING where_clauses = lt_where IMPORTING field_ranges = lt_trange EXCEPTIONS expression_not_supported = 1 incorrect_expression = 2 OTHERS = 3.
DDIF_NAMETAB_GET CALL FUNCTION 'DDIF_NAMETAB_GET' EXPORTING tabname = ld_tablename lfieldname = ld_fieldname IMPORTING dfies_wa = ls_dfies EXCEPTIONS not_found = 1 OTHERS = 2.
RS_EXTERNAL_SELSCREEN_STATUS CALL FUNCTION 'RS_EXTERNAL_SELSCREEN_STATUS' EXPORTING p_fb = 'FAGL_EXTERNAL_STATUS_SET_SKC1A'.
RS_EXTERNAL_SELSCREEN_STATUS CALL FUNCTION 'RS_EXTERNAL_SELSCREEN_STATUS' EXPORTING p_fb = 'FAGL_EXTERNAL_STATUS_SET_SKC1C'.
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 SAPDBSDF or its description.