SAP Reports / Programs | Financial Accounting | Localization(FI-LOC) SAP FI

IDMX_MONTHREPORT SAP ABAP Report - Monthly Invoice Report (Mexico)







IDMX_MONTHREPORT 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 IDMX_MONTHREPORT 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

IDMX_MONTHREPORT - Monthly Invoice Report (Mexico)


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 IDMX_MONTHREPORT. "Basic submit
SUBMIT IDMX_MONTHREPORT AND RETURN. "Return to original report after report execution complete
SUBMIT IDMX_MONTHREPORT 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: TXT_FILE = D .
Selection Text: DATE = D .
Selection Text: COMPCODE = D .
Title: Monthly Invoice Report (Mexico)
Text Symbol: 024 = Document Type
Text Symbol: 023 = Official Document
Text Symbol: 022 = Customs
Text Symbol: 021 = Reporting Period
Text Symbol: 020 = Tax Exemption
Text Symbol: 019 = Invoice Details
Text Symbol: 018 = Text File Containing Invoice Details
Text Symbol: 017 = Approval Number
Text Symbol: 016 = Customer Tax ID
Text Symbol: 015 = Cancellation
Text Symbol: 014 = Tax Amount
Text Symbol: 013 = Invoice Amount
Text Symbol: 012 = Creation Time
Text Symbol: 011 = Creation Date
Text Symbol: 010 = Reference
Text Symbol: 009 = Billing Document
Text Symbol: 008 = Prefix
Text Symbol: 007 = Type
Text Symbol: 006 = Fiscal Year
Text Symbol: 005 = Accounting Document
Text Symbol: 004 = Company Code
Text Symbol: 003 = Text File
Text Symbol: 002 = Type of Invoice
Text Symbol: 001 = Additional Selection


INCLUDES used within this REPORT IDMX_MONTHREPORT

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:

J_1BSA_COMPONENT_ACTIVE CALL FUNCTION 'J_1BSA_COMPONENT_ACTIVE' EXPORTING bukrs = compcode component = 'MX' IMPORTING out_country = place EXCEPTIONS component_not_active = 1 OTHERS = 2.

DAYS_BETWEEN_TWO_DATES CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES' EXPORTING i_datum_bis = date-high i_datum_von = date-low IMPORTING e_tage = day.

BAL_LOG_CREATE CALL FUNCTION 'BAL_LOG_CREATE' EXPORTING i_s_log = ls_s_log_header IMPORTING e_log_handle = lv_log_handle EXCEPTIONS log_header_inconsistent = 1 OTHERS = 2.

IDMX_DI_CHECK_INVOIC CALL FUNCTION 'IDMX_DI_CHECK_INVOIC' EXPORTING iv_bukrs = ls_fi_docs_period-bukrs iv_blart = ls_fi_docs_period-blart IMPORTING ev_mx_di_indicator = lv_mx_di_indicator.

BAL_DSP_LOG_DISPLAY CALL FUNCTION 'BAL_DSP_LOG_DISPLAY' EXPORTING * I_S_DISPLAY_PROFILE = i_t_log_handle = lt_log_handle * I_T_MSG_HANDLE = * I_S_LOG_FILTER = * I_S_MSG_FILTER = * I_T_LOG_CONTEXT_FILTER = * I_T_MSG_CONTEXT_FILTER = * I_AMODAL = ' ' * I_SRT_BY_TIMSTMP = ' ' * IMPORTING * E_S_EXIT_COMMAND = EXCEPTIONS profile_inconsistent = 1 internal_error = 2 no_data_available = 3 no_authority = 4 OTHERS = 5 .

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = gl_filename filetype = 'ASC' write_field_separator = '' trunc_trailing_blanks = 'X' write_lf = 'X' trunc_trailing_blanks_eol = 'X' TABLES data_tab = it_file 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.

GUI_DOWNLOAD * CALL FUNCTION 'GUI_DOWNLOAD' * EXPORTING * filename = gl_filename * filetype = 'ASC' * write_field_separator = '' * trunc_trailing_blanks = 'X' * write_lf = 'X' * trunc_trailing_blanks_eol = 'X' * TABLES * data_tab = it_file.

GUI_DOWNLOAD * CALL FUNCTION 'GUI_DOWNLOAD' * EXPORTING * filename = gl_filename * filetype = 'ASC' * write_field_separator = '' * trunc_trailing_blanks = 'X' * write_lf = 'X' * trunc_trailing_blanks_eol = 'X' * TABLES * data_tab = it_file.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING client = sy-mandt date = wa_sd-post_date foreign_amount = wa_sd-mwsts foreign_currency = wa_sd-waerk local_currency = lv_waers * RATE = 0 * TYPE_OF_RATE = 'M' * READ_TCURR = 'X' IMPORTING * EXCHANGE_RATE = * FOREIGN_FACTOR = local_amount = wa_sd-mwsts * LOCAL_FACTOR = * EXCHANGE_RATEX = * FIXED_RATE = * DERIVED_RATE_TYPE = EXCEPTIONS no_rate_found = 1 overflow = 2 no_factors_found = 3 no_spread_found = 4 derived_2_times = 5 OTHERS = 6 .

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING client = sy-mandt date = wa_sd-post_date foreign_amount = wa_sd-dmbtr foreign_currency = wa_sd-waerk local_currency = lv_waers * RATE = 0 * TYPE_OF_RATE = 'M' * READ_TCURR = 'X' IMPORTING * EXCHANGE_RATE = * FOREIGN_FACTOR = local_amount = wa_sd-dmbtr * LOCAL_FACTOR = * EXCHANGE_RATEX = * FIXED_RATE = * DERIVED_RATE_TYPE = EXCEPTIONS no_rate_found = 1 overflow = 2 no_factors_found = 3 no_spread_found = 4 derived_2_times = 5 OTHERS = 6 .

IDMX_DI_GET_SD_DOCTYP CALL FUNCTION 'IDMX_DI_GET_SD_DOCTYP' EXPORTING iv_netwr = wa_main-netwr iv_vbtyp = wa_main-vbtyp IMPORTING ev_doctyp_report = wa_main-doctyp EXCEPTIONS error = 1.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = ls_text_objects-tdid language = lv_language name = lv_name object = ls_text_objects-tdobject * ARCHIVE_HANDLE = 0 * LOCAL_CAT = ' ' * IMPORTING * HEADER = TABLES lines = text_line EXCEPTIONS id = 1 language = 2 name = 3 not_found = 4 object = 5 reference_check = 6 wrong_access_to_archive = 7 OTHERS = 8 .

IDMX_DI_CHECK_TAX_ADJUSTMENT CALL FUNCTION 'IDMX_DI_CHECK_TAX_ADJUSTMENT' EXPORTING it_bkpf = it_bkpf_fi it_bseg = it_bseg_fi it_bset = lt_bset_fi IMPORTING et_bkpf_tax_adjust = lt_bkpf_tax_adjust * et_bset_tax_adjusted EXCEPTIONS error = 1 OTHERS = 2.

IDMX_DI_FI_DATA_EXTRACT CALL FUNCTION 'IDMX_DI_FI_DATA_EXTRACT' EXPORTING is_bkpf = ls_bkpf_tax_adjust it_bseg = lt_bseg_tax_adjust it_bset = lt_bset_tax_adjust it_bsec = lt_bsec_tax_adjust * IV_TEXT_READ_FLAG = ' ' * IV_TEXT_BADI_FLAG = ' ' IMPORTING es_data_extract = ls_extract_adjust * EV_STRING_ADDENDA = * EV_STRING_HEADER_COMPL_XML = * ET_ITEM_COMPL_XML = * ET_BSEG_REF = EXCEPTIONS error = 1 OTHERS = 2 .

IDMX_DI_GET_FI_DOCTYP CALL FUNCTION 'IDMX_DI_GET_FI_DOCTYP' EXPORTING iv_blart = wa_main-blart IMPORTING ev_doctyp_report = wa_main-doctyp EXCEPTIONS error = 1.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = ls_text_objects-tdid language = lv_language name = lv_name object = ls_text_objects-tdobject * ARCHIVE_HANDLE = 0 * LOCAL_CAT = ' ' * IMPORTING * HEADER = TABLES lines = text_line EXCEPTIONS id = 1 language = 2 name = 3 not_found = 4 object = 5 reference_check = 6 wrong_access_to_archive = 7 OTHERS = 8 .

XBLNR_BUILD_AND_SPLIT_MX CALL FUNCTION 'XBLNR_BUILD_AND_SPLIT_MX' EXPORTING i_bukrs = wa_main-bukrs i_xblnr = wa_main-xblnr IMPORTING e_rgtno = wa_main-prefix e_invno = wa_main-invfr EXCEPTIONS parameter_wrong = 1 not_found = 2 xblnr_format_wrong = 3 OTHERS = 4.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = ls_text_objects-tdid language = lv_language name = lv_name object = ls_text_objects-tdobject * ARCHIVE_HANDLE = 0 * LOCAL_CAT = ' ' * IMPORTING * HEADER = TABLES lines = text_line EXCEPTIONS id = 1 language = 2 name = 3 not_found = 4 object = 5 reference_check = 6 wrong_access_to_archive = 7 OTHERS = 8 .

IDMX_DI_GET_TEXT





* CALL FUNCTION 'IDMX_DI_GET_TEXT' * EXPORTING * iv_dataid = 'APY' * iv_doc_awkey = lv_doc_awkey * iv_doc_awtyp = lv_doc_awtyp * iv_language = lv_language * IMPORTING * et_t_tline = text_line * EXCEPTIONS * error = 1 * OTHERS = 2.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = ls_text_objects-tdid language = lv_language name = lv_name object = ls_text_objects-tdobject * ARCHIVE_HANDLE = 0 * LOCAL_CAT = ' ' * IMPORTING * HEADER = TABLES lines = text_line EXCEPTIONS id = 1 language = 2 name = 3 not_found = 4 object = 5 reference_check = 6 wrong_access_to_archive = 7 OTHERS = 8 .

IDMX_DI_GET_TEXT * CALL FUNCTION 'IDMX_DI_GET_TEXT' * EXPORTING * iv_dataid = 'APN' * iv_doc_awkey = lv_doc_awkey * iv_doc_awtyp = lv_doc_awtyp * iv_language = lv_language * IMPORTING * et_t_tline = text_line * EXCEPTIONS * error = 1 * OTHERS = 2.

IDMX_DI_GET_APPROVAL_FOR_SD CALL FUNCTION 'IDMX_DI_GET_APPROVAL_FOR_SD' EXPORTING iv_bukrs = wa_main-bukrs iv_fkart = ls_vbrk_doc-fkart iv_odn_prefix = wa_main-prefix iv_odn_seqnumber = wa_main-invfr is_vbrk = ls_vbrk_doc IMPORTING ev_aprovnum = app_num ev_aprovyear = app_year EXCEPTIONS error = 1 OTHERS = 2.

IDMX_DI_GET_APPROVAL_FOR_FI CALL FUNCTION 'IDMX_DI_GET_APPROVAL_FOR_FI' EXPORTING iv_bukrs = wa_main-bukrs iv_blart = ls_bkpf_doc-blart iv_odn_prefix = wa_main-prefix iv_odn_seqnumber = wa_main-invfr IMPORTING ev_aprovnum = app_num ev_aprovyear = app_year EXCEPTIONS error = 1 OTHERS = 2.

REUSE_ALV_GRID_DISPLAY CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = w_prog i_callback_pf_status_set = 'SET_PF' i_callback_top_of_page = 'TOP_PAGE' i_callback_user_command = 'USER_COMM ' i_grid_title = title_for_grid it_fieldcat = t_fieldcat[] it_excluding = i_exclude i_save = 'A' is_variant = ls_variant TABLES t_outtab = itab_main.

REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = header * I_LOGO = * I_END_OF_LIST_GRID = .

IDMX_DI_CHECK_INVOIC CALL FUNCTION 'IDMX_DI_CHECK_INVOIC' EXPORTING iv_bukrs = compcode iv_fkart = ls_vbrk-fkart * IV_BLART = iv_netwr = ls_vbrk-netwr iv_vkorg = ls_vbrk-vkorg IMPORTING ev_mx_di_indicator = ls_vbrk-di .

BAL_LOG_CREATE CALL FUNCTION 'BAL_LOG_CREATE' EXPORTING i_s_log = ls_s_log_header IMPORTING e_log_handle = lv_log_handle EXCEPTIONS log_header_inconsistent = 1 OTHERS = 2.

BAL_LOG_MSG_ADD CALL FUNCTION 'BAL_LOG_MSG_ADD' EXPORTING i_log_handle = lv_log_handle i_s_msg = lv_log_msg IMPORTING e_s_msg_handle = lv_e_msg_handle e_msg_was_logged = lv_msg_was_logged e_msg_was_displayed = lv_msg_was_displayed EXCEPTIONS log_not_found = 1 msg_inconsistent = 2 log_is_full = 3 OTHERS = 4.

PFL_GET_PARAMETER CALL FUNCTION 'PFL_GET_PARAMETER' TABLES parameter_table = parameter_table EXCEPTIONS OTHERS = 1.

XBLNR_BUILD_AND_SPLIT_MX * CALL FUNCTION 'XBLNR_BUILD_AND_SPLIT_MX' * EXPORTING * i_bukrs = wa_main-bukrs * i_xblnr = wa_main-xblnr * IMPORTING * e_rgtno = wa_main-prefix * e_invno = wa_main-invfr * EXCEPTIONS * parameter_wrong = 1 * not_found = 2 * xblnr_format_wrong = 3 * OTHERS = 4.

IDMX_PRE_GET_APPROVAL * CALL FUNCTION 'IDMX_PRE_GET_APPROVAL' * EXPORTING * iv_bukrs = wa_main-bukrs * iv_belnr = wa_main-belnr * iv_gjahr = wa_main-gjahr * IMPORTING * ev_approval_number = wa_main-bkdes.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = ls_text_objects-tdid language = lv_language name = lv_name object = ls_text_objects-tdobject * ARCHIVE_HANDLE = 0 * LOCAL_CAT = ' ' * IMPORTING * HEADER = TABLES lines = text_line EXCEPTIONS id = 1 language = 2 name = 3 not_found = 4 object = 5 reference_check = 6 wrong_access_to_archive = 7 OTHERS = 8 .

IDMX_DI_FI_DATA_EXTRACT CALL FUNCTION 'IDMX_DI_FI_DATA_EXTRACT' EXPORTING is_bkpf = ls_bkpf_cust it_bseg = lt_bseg_cust it_bset = lt_bset_cust it_bsec = lt_bsec_cust * IV_TEXT_READ_FLAG = ' ' * IV_TEXT_BADI_FLAG = ' ' IMPORTING es_data_extract = ls_data_extract * EV_STRING_ADDENDA = * EV_STRING_HEADER_COMPL_XML = * ET_ITEM_COMPL_XML = * ET_BSEG_REF = EXCEPTIONS error = 1 OTHERS = 2 .

IDMX_DI_TLINE_INTO_STRING CALL FUNCTION 'IDMX_DI_TLINE_INTO_STRING' EXPORTING it_tline = text_line IMPORTING ev_text_string = lv_cus_string.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = ls_text_objects-tdid language = lv_language name = lv_name object = ls_text_objects-tdobject * ARCHIVE_HANDLE = 0 * LOCAL_CAT = ' ' * IMPORTING * HEADER = TABLES lines = text_line EXCEPTIONS id = 1 language = 2 name = 3 not_found = 4 object = 5 reference_check = 6 wrong_access_to_archive = 7 OTHERS = 8 .

IDMX_DI_SD_DATA_EXTRACT CALL FUNCTION 'IDMX_DI_SD_DATA_EXTRACT' EXPORTING is_xvbrk = ls_xvbrk it_xvbrp = lt_xvbrp it_xkomv = lt_xkomv it_xvbpa = lt_xvbpa * IV_TEXT_READ_FLAG = ' ' * iv_text_badi_flag = ' ' IMPORTING es_data_extract = ls_data_extract * et_xvbrp_ref = st_xvbrp_ref EXCEPTIONS error = 1 OTHERS = 2 .

IDMX_DI_TLINE_INTO_STRING CALL FUNCTION 'IDMX_DI_TLINE_INTO_STRING' EXPORTING it_tline = text_line IMPORTING ev_text_string = lv_cus_string.

IDMX_DI_GET_XMLVERSION CALL FUNCTION 'IDMX_DI_GET_XMLVERSION' EXPORTING iv_bukrs = iv_bukrs iv_inv_erdat = iv_date_low IMPORTING ev_xml_version = lv_xml_version EXCEPTIONS no_xml_version_found = 1 OTHERS = 2.






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