SAP Reports / Programs | Financial Accounting | Consolidation | Basic Functions(FI-LC-LC) SAP FI

RGCPCU20 SAP ABAP Report - Upload Financial Data from External Data Entry using MS Access







RGCPCU20 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 RGCPCU20 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 RGCPCU20. "Basic submit
SUBMIT RGCPCU20 AND RETURN. "Return to original report after report execution complete
SUBMIT RGCPCU20 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: PA_DELD = Delete documents
Selection Text: PA_CKID = Copy check digit
Selection Text: PA_DOCQT = Document type for quantities
Selection Text: PD_DELB = Delete position data
Selection Text: PA_TEST = Test run
Selection Text: PA_RYEAR = Fiscal year
Selection Text: PA_RVERS = Version
Selection Text: PA_RLDNR = Ledger
Selection Text: PA_RCOMP = Company
Selection Text: PA_PERID = Period
Selection Text: PA_DOCVC = Document type for currencies
Title: Upload Financial Data from External Data Entry using MS Access
Text Symbol: 027 = No data records exist
Text Symbol: 028 = Group currency
Text Symbol: 020 = Item
Text Symbol: 001 = Logical filename: "
Text Symbol: 002 = Directory: "
Text Symbol: 003 = Filename: "
Text Symbol: T02 = Company:
Text Symbol: T00 = Upload financial data from MS Access
Text Symbol: 006 = Document types
Text Symbol: 007 = Local valuation data
Text Symbol: 008 = Data records for corp. val."
Text Symbol: 009 = of which with curr. vals "
Text Symbol: 010 = of which with quant. vals
Text Symbol: P03 = Standardizing entries
Text Symbol: P02 = Options
Text Symbol: P01 = General selections
Text Symbol: L03 = Correcting entries to corporate val. data
Text Symbol: L02 = Update information
Text Symbol: L01 = Upload information
Text Symbol: T03 = Year:
Text Symbol: T11 = Document type for currencies
Text Symbol: T10 = Parameters
Text Symbol: B01 = Standardizing entries from offline data entry
Text Symbol: T04 = Period:
Text Symbol: T05 = Ledger:
Text Symbol: T06 = Version:





Text Symbol: T07 = Upd. run
Text Symbol: T08 = Test run
Text Symbol: T09 = SPACE -> Upload whole fiscal year
Text Symbol: 026 = Local currency
Text Symbol: ZB1 = PrdGp
Text Symbol: ZB2 = SuppCo
Text Symbol: ZB3 = Book value - LC
Text Symbol: ZB4 = Quantity
Text Symbol: ZB5 = Depreciation
Text Symbol: ZB6 = T
Text Symbol: ZB7 = Percent
Text Symbol: ZBU = Additional financial data IPA: inventory management companies
Text Symbol: ZB0 = Item
Text Symbol: ZA0 = Ivstee
Text Symbol: ZA2 = TTy
Text Symbol: ZA3 = TrCo
Text Symbol: ZA4 = Activity description
Text Symbol: ZA6 = Amount in LC
Text Symbol: ZA7 = Amount in GC
Text Symbol: ZA8 = Change in share
Text Symbol: ZAU = Additional financial data: changes in investments
Text Symbol: ZK1 = S
Text Symbol: ZKU = Additional financial data: changes in investee equity
Text Symbol: ZL2 = Co.ID
Text Symbol: ZL5 = C
Text Symbol: ZL6 = COGM
Text Symbol: ZLU = Additional financial data IPA: costs of goods manufactured
Text Symbol: T12 = Document type for quantities
Text Symbol: 021 = TTy
Text Symbol: 022 = Partners
Text Symbol: 023 = YrAcq
Text Symbol: 024 = TC
Text Symbol: 025 = Transaction currency


INCLUDES used within this REPORT RGCPCU20

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:

G_SET_IMPORTSTATUS * CALL FUNCTION 'G_SET_IMPORTSTATUS' * EXPORTING * e_rldnr = pa_rldnr * e_rvers = pa_rvers * e_rcomp = pa_rcomp * e_ryear = pa_ryear * e_perid = v_perid * e_dbcnt = gd_dbcnt.

G_GET_FILENAME





* CALL FUNCTION 'G_GET_FILENAME' * EXPORTING * e_rcomp = pa_rcomp * e_rvers = pa_rvers * e_param1 = pa_rcomp "xhe311097 * e_param2 = pa_rvers "xhe311097 * e_use_pserver = ld_use_pserver * IMPORTING * i_filename = gd_filename * i_fileformat = gd_filetype * EXCEPTIONS * file_not_found = 01.

WS_UPLOAD ** call function 'WS_UPLOAD' "xhe000951 ** exporting "xhe000951 ** filename = gd_filename "xhe000951 ** filetype = gd_filetype "xhe000951 ** tables "xhe000951 ** data_tab = it_access_tab "xhe000951 ** exceptions "xhe000951 ** conversion_error = 01 "xhe000951 ** file_open_error = 02 "xhe000951 ** file_read_error = 03 "xhe000951 ** invalid_table_width = 04 "xhe000951 ** invalid_type = 05 "xhe000951 ** no_batch = 06 "xhe000951 ** unknown_error = 07. "xhe000951

UPLOAD * CALL FUNCTION 'UPLOAD' "xhe000951 * EXPORTING "xhe000951 * filename = ld_destination "xhe000951 * filetype = gd_filetype "xhe000951 * IMPORTING "xhe000951 * act_filename = ld_destination "xhe000951 * TABLES "xhe000951 * data_tab = it_access_tab "xhe000951 * EXCEPTIONS "xhe000951 ** conversion_error = 1 "xhe000951 ** invalid_table_width = 2 "xhe000951 ** invalid_type = 3 "xhe000951 ** no_batch = 4 "xhe000951 ** unknown_error = 5 "xhe000951 ** others = 6. "xhe000951

G_INVERT_FILCT * CALL FUNCTION 'G_INVERT_FILCT' * EXPORTING * i_poper = v_perid * i_rcomp = pa_rcomp * i_rldnr = pa_rldnr * i_rvers = pa_rvers * i_ryear = pa_ryear * i_vbi = ld_vbi * i_no_gcval = ld_no_gcval "vhs104345 * TABLES * it_filca = tab_filca.

CHECK_COMBINATION_OF_ADDFIELDS * CALL FUNCTION 'CHECK_COMBINATION_OF_ADDFIELDS' "xhe140798 * EXPORTING "xhe140798 * e_aftyp = gd_aftyp "xhe140798 * e_item = v_item "xhe140798 * e_adfld1 = v_adfld1 "xhe140798 * e_adfld2 = v_adfld2 "xhe140798 * e_adfld3 = v_adfld3 "xhe140798 * e_flgerr = ' ' "xhe140798 * IMPORTING "xhe140798 * i_subrc = r_subrc. "xhe140798

POP_VALUE_REQUEST * CALL FUNCTION 'POP_VALUE_REQUEST' * EXPORTING * e_rvers = v_rvers * e_tabname = 'T876' * e_titel = text-006 * IMPORTING * i_value = r_docty.

LC_DOC_POST * CALL FUNCTION 'LC_DOC_POST' * EXPORTING * e_rldnr = v_rldnr * e_rvers = v_rvers * e_ryear = v_ryear * e_perid = v_perid * TABLES * it_header = it_header * it_postab = it_lines * it_msgtab = it_msg.

LC_REVERSE * CALL FUNCTION 'LC_REVERSE' * EXPORTING * e_rldnr = v_rldnr * e_mode = 'O' * e_rvers = v_rvers * e_rvs_ryear = v_ryear * e_rvs_perid = v_perid * e_bdc_name = ld_bdc_name * TABLES * it_rvrs = lt_rvrs.



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