FICDOW20 SAP ABAP Report - Download Reported Financial Data
FICDOW20 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter FICDOW20 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
CX3D1 - Download Reported Financial Data
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 FICDOW20. "Basic submit
SUBMIT FICDOW20 AND RETURN. "Return to original report after report execution complete
SUBMIT FICDOW20 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: SO_BUNIT = Consolidation unit(s)
Selection Text: PA_TF586 = Supplier data
Selection Text: PA_TF585 = Inventory data
Selection Text: PA_RYEAR = D Fiscal year
Selection Text: PA_RVERS = D Version
Selection Text: PA_PERID = D Period
Selection Text: PA_ITCLG = D Cons chart of accounts
Selection Text: PA_DOCTY = DT for standardizing entries
Selection Text: PA_DIMEN = D Dimension
Selection Text: PA_CONGR = D Consolidation group
Title: Download Reported Financial Data
Text Symbol: C01 = Dim.
Text Symbol: B06 = Supplier data
Text Symbol: B05 = Inventory data
Text Symbol: B04 = Additional financial data for the elim. of IU profit/loss in inventory
Text Symbol: B03 = Further settings
Text Symbol: B02 = Version/time
Text Symbol: B01 = Organizational units
Text Symbol: 102 = *** unused
Text Symbol: 101 = Consolidation unit
Text Symbol: 006 = ASCII format
Text Symbol: 003 = Download supplier data
Text Symbol: 002 = Download inventory data
Text Symbol: 001 = Download reported data
INCLUDES used within this REPORT FICDOW20
INCLUDE FICDAT00.
INCLUDE: FICALV00, FICLPF00.
INCLUDE: FICALV00, FICLPF00.
INCLUDE FICDOW2S.
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:
FC_FIELD_PROPERTIES CALL FUNCTION 'FC_FIELD_PROPERTIES' IMPORTING it_fdep = gt_fdep[] it_fprop = gt_fprop[].
FC_GET_VERSIONS CALL FUNCTION 'FC_GET_VERSIONS' EXPORTING e_ind_ldrvs = con_on e_ind_strvs = con_on e_rvers = i_rvers IMPORTING i_ldrvs = e_ldrvs i_strvs = e_strvs.
GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING * BIN_FILESIZE = FILENAME = ld_fullpath * FILETYPE = 'ASC' * APPEND = ' ' * WRITE_FIELD_SEPARATOR = ' ' * HEADER = '00' * TRUNC_TRAILING_BLANKS = ' ' * WRITE_LF = 'X' * COL_SELECT = ' ' * COL_SELECT_MASK = ' ' codepage = '1101' "mix772413 * IMPORTING * FILELENGTH = TABLES DATA_TAB = it_data EXCEPTIONS FILE_WRITE_ERROR = 1 NO_BATCH = 2 GUI_REFUSE_FILETRANSFER = 3 INVALID_TYPE = 4 NO_AUTHORITY = 5 UNKNOWN_ERROR = 6 HEADER_NOT_ALLOWED = 7 SEPARATOR_NOT_ALLOWED = 8 FILESIZE_NOT_ALLOWED = 9 HEADER_TOO_LONG = 10 DP_ERROR_CREATE = 11 DP_ERROR_SEND = 12 DP_ERROR_WRITE = 13 UNKNOWN_DP_ERROR = 14 ACCESS_DENIED = 15 DP_OUT_OF_MEMORY = 16 DISK_FULL = 17 DP_TIMEOUT = 18 FILE_NOT_FOUND = 19 DATAPROVIDER_EXCEPTION = 20 CONTROL_FLUSH_ERROR = 21 OTHERS = 22.
DOWNLOAD * CALL FUNCTION 'DOWNLOAD' * EXPORTING * filename = e_filename * filetype = 'ASC' "hah145242 ** FILETYPE = 'DAT' "hah145242 ** We must use 'DAT' since 'ASC' will not store binary data "hah145242 ** types (e.g.int4) in text format
GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING * BIN_FILESIZE = FILENAME = ld_fullpath * FILETYPE = 'ASC' * APPEND = ' ' * WRITE_FIELD_SEPARATOR = ' ' * HEADER = '00' * TRUNC_TRAILING_BLANKS = ' ' * WRITE_LF = 'X' * COL_SELECT = ' ' * COL_SELECT_MASK = ' ' codepage = '1101' "mix772413 * IMPORTING * FILELENGTH = TABLES DATA_TAB = it_data EXCEPTIONS FILE_WRITE_ERROR = 1 NO_BATCH = 2 GUI_REFUSE_FILETRANSFER = 3 INVALID_TYPE = 4 NO_AUTHORITY = 5 UNKNOWN_ERROR = 6 HEADER_NOT_ALLOWED = 7 SEPARATOR_NOT_ALLOWED = 8 FILESIZE_NOT_ALLOWED = 9 HEADER_TOO_LONG = 10 DP_ERROR_CREATE = 11 DP_ERROR_SEND = 12 DP_ERROR_WRITE = 13 UNKNOWN_DP_ERROR = 14 ACCESS_DENIED = 15 DP_OUT_OF_MEMORY = 16 DISK_FULL = 17 DP_TIMEOUT = 18 FILE_NOT_FOUND = 19 DATAPROVIDER_EXCEPTION = 20 CONTROL_FLUSH_ERROR = 21 OTHERS = 22.
DOWNLOAD * CALL FUNCTION 'DOWNLOAD' * EXPORTING * filename = e_filename * filetype = 'ASC' * item = text-002 * filemask_mask = '*.txt'
GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING * BIN_FILESIZE = FILENAME = ld_fullpath * FILETYPE = 'ASC' * APPEND = ' ' * WRITE_FIELD_SEPARATOR = ' ' * HEADER = '00' * TRUNC_TRAILING_BLANKS = ' ' * WRITE_LF = 'X' * COL_SELECT = ' ' * COL_SELECT_MASK = ' ' * IMPORTING * FILELENGTH = codepage = '1101' "mix772413 TABLES DATA_TAB = it_data EXCEPTIONS FILE_WRITE_ERROR = 1 NO_BATCH = 2 GUI_REFUSE_FILETRANSFER = 3 INVALID_TYPE = 4 NO_AUTHORITY = 5 UNKNOWN_ERROR = 6 HEADER_NOT_ALLOWED = 7 SEPARATOR_NOT_ALLOWED = 8 FILESIZE_NOT_ALLOWED = 9 HEADER_TOO_LONG = 10 DP_ERROR_CREATE = 11 DP_ERROR_SEND = 12 DP_ERROR_WRITE = 13 UNKNOWN_DP_ERROR = 14 ACCESS_DENIED = 15 DP_OUT_OF_MEMORY = 16 DISK_FULL = 17 DP_TIMEOUT = 18 FILE_NOT_FOUND = 19 DATAPROVIDER_EXCEPTION = 20 CONTROL_FLUSH_ERROR = 21 OTHERS = 22.
DOWNLOAD * CALL FUNCTION 'DOWNLOAD' * EXPORTING * filename = e_filename * filetype = 'ASC' * item = text-003 * filemask_mask = '*.txt'
FC_CONGR_DISMANTLE CALL FUNCTION 'FC_CONGR_DISMANTLE' EXPORTING e_dimen = i_dimen e_congr = i_congr e_rvers = i_rvers e_ryear = i_ryear e_perid = i_perid e_rollup_cu = con_on e_tf160 = con_on IMPORTING it_tf160 = it_tf160[] EXCEPTIONS OTHERS = 1.
FC_IPI_GLOBAL_SETTINGS_READ CALL FUNCTION 'FC_IPI_GLOBAL_SETTINGS_READ' EXPORTING e_dimen = vd_dimen e_ryear = vd_ryear e_perid = vd_perid IMPORTING i_inval = ld_inval.
FC_IPI_INV_READ CALL FUNCTION 'FC_IPI_INV_READ' EXPORTING e_dimen = vd_dimen e_rldnr = vd_rldnr e_itclg = vd_itclg e_rvers = vd_rvers e_ryear = vd_ryear e_perid = vd_perid et_bunit = lt_bunit[] IMPORTING it_inv = lt_data[].
FC_IPI_SUP_READ CALL FUNCTION 'FC_IPI_SUP_READ' EXPORTING e_dimen = vd_dimen e_rldnr = vd_rldnr e_itclg = vd_ritclg e_rvers = vd_rvers e_ryear = vd_ryear e_perid = vd_perid et_bunit = lt_bunit[] IMPORTING it_sup = lt_data[].
FC_TOTALS_SELECT CALL FUNCTION 'FC_TOTALS_SELECT' EXPORTING it_sel = it_select it_fields = it_fields * it_kfig = * E_FIELDS_ALL = e_kfig_all = con_on * E_PERID_CUM = * E_SIGN = * E_SUMIT = * E_SUMCG = * E_SUMVS = IMPORTING it_data = it_totals EXCEPTIONS fields_missing = 1 kfig_missing = 2 OTHERS = 3.
FC_ITGRP_PROPERTIES CALL FUNCTION 'FC_ITGRP_PROPERTIES' EXPORTING e_itclg = i_itclg CHANGING ct_itgrp_prop = it_itgrp_prop[].
FC_CHAR_DEFVAL_GET CALL FUNCTION 'FC_CHAR_DEFVAL_GET' EXPORTING es_param = ls_defvalpara CHANGING ct_defval = lt_defval[].
FC_CHAR_DEFVAL_GET CALL FUNCTION 'FC_CHAR_DEFVAL_GET' EXPORTING es_param = ls_defvalpara CHANGING ct_defval = lt_defval[].
FC_AUTHORITY_CHECK CALL FUNCTION 'FC_AUTHORITY_CHECK' EXPORTING e_id = 'CACTT' e_dimen = pa_dimen e_congr = pa_congr e_rvers = pa_rvers e_cactt = '02' " Datenübernahme e_cacti = '' " Maßnahme e_actvt = '16'. " durchführen ?
FC_CG_CU_PROPERTIES CALL FUNCTION 'FC_CG_CU_PROPERTIES' EXPORTING e_dimen = i_dimen e_rvers = i_rvers e_ryear = i_ryear e_perid = '012' CHANGING ct_cg_prop = lt_cg[].
CALL FUNCTION 'FC_ALV_LIST_DISPLAY' EXPORTING i_tab_struct = 'FC03DOW20L' i_hlp_struct = 'FC03LSTDOW' * IS_LAYOUT = * IT_EXCLUDING = it_special_groups = it_sp_groups * IT_SORT = * IT_FILTER = * I_SAVE = * IT_EVENTS = * IT_EVENT_EXIT = * IMPORTING * E_EXIT_CAUSED_BY_CALLER = CHANGING ct_ffix = ct_ffix_dow ct_fieldcat = ct_fieldcat_dow ct_data = ct_datal[].
FC_CG_CU_PROPERTIES CALL FUNCTION 'FC_CG_CU_PROPERTIES' EXPORTING e_dimen = i_dimen e_rvers = i_rvers e_ryear = i_ryear e_perid = '012' CHANGING ct_cu_prop = lt_cu[].
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 FICDOW20 or its description.