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

J_1I_WRITE_EXCBAL SAP ABAP Report - Read and archive records from extract and balance tables







J_1I_WRITE_EXCBAL 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 J_1I_WRITE_EXCBAL 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 J_1I_WRITE_EXCBAL. "Basic submit
SUBMIT J_1I_WRITE_EXCBAL AND RETURN. "Return to original report after report execution complete
SUBMIT J_1I_WRITE_EXCBAL 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: O_BUDAT = Posting Date
Selection Text: O_EXGRP = Excise Group
Selection Text: P_COMENT = Archiving Session Note
Selection Text: P_DELTST = Delete with Test Variant
Selection Text: P_PROT = D .
Selection Text: P_PROT_O = D .
Selection Text: P_WRIPRD = Production Mode
Selection Text: P_WRITST = Test Mode
Title: Read and archive records from extract and balance tables
Text Symbol: 001 = Extract and Balance tables archived
Text Symbol: 002 = &1% (&2 of &3) of Extract and Balance table archived
Text Symbol: 101 = Archiving Criteria
Text Symbol: 102 = Archiving extract & balance tables


INCLUDES used within this REPORT J_1I_WRITE_EXCBAL

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:

ARCHIVE_PROTOCOL_INIT CALL FUNCTION 'ARCHIVE_PROTOCOL_INIT' EXPORTING i_detailprotocol = p_prot i_protocol_output = p_prot_o.

ARCHIVE_OPEN_FOR_WRITE CALL FUNCTION 'ARCHIVE_OPEN_FOR_WRITE' EXPORTING call_delete_job_in_test_mode = lv_delete_testmode comments = p_coment create_archive_file = lv_files_create object = lc_object IMPORTING archive_handle = lv_handle.

ARCHIVE_NEW_OBJECT CALL FUNCTION 'ARCHIVE_NEW_OBJECT' EXPORTING archive_handle = lv_handle object_id = lv_data_object_id.

ARCHIVE_PUT_RECORD CALL FUNCTION 'ARCHIVE_PUT_RECORD' EXPORTING ARCHIVE_HANDLE = lv_handle RECORD = s_da_ext * RECORD_FLAGS = ' ' RECORD_STRUCTURE = 'J_2IEXTRCT' EXCEPTIONS INTERNAL_ERROR = 1 WRONG_ACCESS_TO_ARCHIVE = 2 INVALID_RECORD_STRUCTURE = 3 OTHERS = 4.

ARCHIVE_SAVE_OBJECT CALL FUNCTION 'ARCHIVE_SAVE_OBJECT' EXPORTING archive_handle = lv_handle EXCEPTIONS file_io_error = 1 internal_error = 2 open_error = 3 termination_requested = 4 wrong_access_to_archive = 5 OTHERS = 6.

ARCHIVE_PROTOCOL_COLLECT CALL FUNCTION 'ARCHIVE_PROTOCOL_COLLECT' EXPORTING i_object = lv_object_identifier i_text = 'Extract and Balance tables archived'(001) i_msgtype = 1.

PROGRESS_INDICATOR CALL FUNCTION 'PROGRESS_INDICATOR' EXPORTING i_text = '&1% (&2 of &3) of Extract and Balance table archived'(002) i_processed = lv_objects_processed i_total = lv_total_object_number importing e_progress_sent = lv_progress_send.

DB_COMMIT call function 'DB_COMMIT'.

PROGRESS_INDICATOR CALL FUNCTION 'PROGRESS_INDICATOR' EXPORTING i_text = '&1% (&2 of &3) of Extract and Balance table archived'(002) i_processed = lv_objects_processed i_total = lv_total_object_number i_output_immediately = 'X'.

ARCHIVE_NEW_OBJECT CALL FUNCTION 'ARCHIVE_NEW_OBJECT' EXPORTING archive_handle = lv_handle object_id = lv_data_object_id.

ARCHIVE_PUT_RECORD CALL FUNCTION 'ARCHIVE_PUT_RECORD' EXPORTING ARCHIVE_HANDLE = lv_handle RECORD = s_da_exd * RECORD_FLAGS = ' ' RECORD_STRUCTURE = 'J_2IEXDATE' EXCEPTIONS INTERNAL_ERROR = 1 WRONG_ACCESS_TO_ARCHIVE = 2 INVALID_RECORD_STRUCTURE = 3 OTHERS = 4.

ARCHIVE_SAVE_OBJECT CALL FUNCTION 'ARCHIVE_SAVE_OBJECT' EXPORTING archive_handle = lv_handle EXCEPTIONS termination_requested = 1.

ARCHIVE_NEW_OBJECT CALL FUNCTION 'ARCHIVE_NEW_OBJECT' EXPORTING archive_handle = lv_handle object_id = lv_data_object_id.

ARCHIVE_PUT_RECORD CALL FUNCTION 'ARCHIVE_PUT_RECORD' EXPORTING ARCHIVE_HANDLE = lv_handle RECORD = s_da_reg * RECORD_FLAGS = ' ' RECORD_STRUCTURE = 'J_2IREGBAL' EXCEPTIONS INTERNAL_ERROR = 1 WRONG_ACCESS_TO_ARCHIVE = 2 INVALID_RECORD_STRUCTURE = 3 OTHERS = 4.

ARCHIVE_SAVE_OBJECT CALL FUNCTION 'ARCHIVE_SAVE_OBJECT' EXPORTING archive_handle = lv_handle EXCEPTIONS termination_requested = 1.

ARCHIVE_NEW_OBJECT CALL FUNCTION 'ARCHIVE_NEW_OBJECT' EXPORTING archive_handle = lv_handle object_id = lv_data_object_id.

ARCHIVE_PUT_RECORD CALL FUNCTION 'ARCHIVE_PUT_RECORD' EXPORTING ARCHIVE_HANDLE = lv_handle RECORD = s_da_rgi * RECORD_FLAGS = ' ' RECORD_STRUCTURE = 'J_2IRG1BAL' EXCEPTIONS INTERNAL_ERROR = 1 WRONG_ACCESS_TO_ARCHIVE = 2 INVALID_RECORD_STRUCTURE = 3 OTHERS = 4.

ARCHIVE_SAVE_OBJECT CALL FUNCTION 'ARCHIVE_SAVE_OBJECT' EXPORTING archive_handle = lv_handle EXCEPTIONS termination_requested = 1.

ARCHIVE_NEW_OBJECT





CALL FUNCTION 'ARCHIVE_NEW_OBJECT' EXPORTING archive_handle = lv_handle object_id = lv_data_object_id.

ARCHIVE_PUT_RECORD CALL FUNCTION 'ARCHIVE_PUT_RECORD' EXPORTING ARCHIVE_HANDLE = lv_handle RECORD = s_da_acc * RECORD_FLAGS = ' ' RECORD_STRUCTURE = 'J_2IACCBAL' EXCEPTIONS INTERNAL_ERROR = 1 WRONG_ACCESS_TO_ARCHIVE = 2 INVALID_RECORD_STRUCTURE = 3 OTHERS = 4.

ARCHIVE_SAVE_OBJECT CALL FUNCTION 'ARCHIVE_SAVE_OBJECT' EXPORTING archive_handle = lv_handle EXCEPTIONS termination_requested = 1.

ARCHIVE_WRITE_STATISTICS CALL FUNCTION 'ARCHIVE_WRITE_STATISTICS' EXPORTING archive_handle = lv_handle.

ARCHIVE_CLOSE_FILE CALL FUNCTION 'ARCHIVE_CLOSE_FILE' EXPORTING archive_handle = lv_handle.

ARCHIVE_PROTOCOL_WRITE CALL FUNCTION 'ARCHIVE_PROTOCOL_WRITE'.



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