SAP Reports / Programs

/TDAG/RCSR_PRP_UPLOAD_XLSFILE SAP ABAP Report - Upload Macro for Preregistration Output: Macro File







/TDAG/RCSR_PRP_UPLOAD_XLSFILE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program uploads the macro that is required for the substance information system (spreadsheet output)...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 /TDAG/RCSR_PRP_UPLOAD_XLSFILE 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

/TDAG/RCS_PRP_CGBC - RCS PRP: Upload Excel Macro


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 /TDAG/RCSR_PRP_UPLOAD_XLSFILE. "Basic submit
SUBMIT /TDAG/RCSR_PRP_UPLOAD_XLSFILE AND RETURN. "Return to original report after report execution complete
SUBMIT /TDAG/RCSR_PRP_UPLOAD_XLSFILE 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: ENV_KEY = Environment Parameter
Selection Text: FILENAME = File Path for XLS File
Title: Upload Macro for Preregistration Output: Macro File
Text Symbol: 001 = Error when uploading file:
Text Symbol: 002 = Error when creating document header in the DMS:
Text Symbol: 003 = Error when creating document contents in DMS:
Text Symbol: 006 = Error when reading table TCGENV
Text Symbol: 007 = Error when entering DMS key in TCGENV table:
Text Symbol: 008 = Please enter the following data manually:
Text Symbol: 009 = Excel macro was loaded successfully into DMS
Text Symbol: 010 = Error deleting previously stored document from DMS:
Text Symbol: 011 = Please delete it manually:
Text Symbol: 012 = Error when reading table TCGS2 (document category):
Text Symbol: 015 = Upload Excel Macro
Text Symbol: A01 = Parameter missing in Customizing:
Text Symbol: A02 = Enter it in Customizing for Environment, Health and Safety under
Text Symbol: A03 = Basic Data and Tools -> Basic Settings -> Specify Environment Parameters


INCLUDES used within this REPORT /TDAG/RCSR_PRP_UPLOAD_XLSFILE

INCLUDE: CBUI09.


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:

WS_FILENAME_GET CALL FUNCTION 'WS_FILENAME_GET' EXPORTING mask = l_mask title = text-015 IMPORTING filename = filename rc = l_rc EXCEPTIONS inv_winsys = 1 no_batch = 2 selection_cancel = 3 selection_error = 4 OTHERS = 5.

C1I0_TCGENV_READ CALL FUNCTION 'C1I0_TCGENV_READ' EXPORTING i_param = env_key IMPORTING e_value = value EXCEPTIONS param_not_found = 1 OTHERS = 2.

C14S_DOCUMENT_NEW_RECYCLE CALL FUNCTION 'C14S_DOCUMENT_NEW_RECYCLE' EXPORTING i_doccat = dmsdokar i_doktext = 'EHS: Excel macro' "#EC NOTEXT IMPORTING e_newdockey = newdockey EXCEPTIONS doccat_needed = 1 illegal_status = 2 general_failure = 3 object_not_existent = 4 OTHERS = 5.

C14S_DOCUMENT_ORIGINAL_PUT CALL FUNCTION 'C14S_DOCUMENT_ORIGINAL_PUT' EXPORTING i_dockey = newdockey i_orig1_size = filelength i_orig1_fname = org_name i_orig1_dappl = 'WWI' "#EC NOTEXT i_orig2_size = 0 i_orig2_fname = ' ' "#EC NOTEXT i_orig2_dappl = ' ' "#EC NOTEXT i_orig1_pages = '001' "#EC NOTEXT i_orig2_pages = 0 TABLES original1_data = data_tab EXCEPTIONS OTHERS = 1.

C1I0_TCGENV_UPDATE CALL FUNCTION 'C1I0_TCGENV_UPDATE' EXPORTING i_param = env_key i_value = newdockey i_flg_commit = true EXCEPTIONS param_not_found = 1 OTHERS = 2.

C14S_DOCUMENT_DELETE CALL FUNCTION 'C14S_DOCUMENT_DELETE' EXPORTING i_doccat = olddockey-dokar i_docno = olddockey-doknr i_partdoc = olddockey-doktl i_version = olddockey-dokvr i_flg_do_commit = true EXCEPTIONS doccat_needed = 1 document_not_exists = 2 docno_needed = 3 OTHERS = 4.

C14S_DOCUMENT_ORIGINAL_DELETE CALL FUNCTION 'C14S_DOCUMENT_ORIGINAL_DELETE' EXPORTING i_dockey = olddockey i_flg_commit = true EXCEPTIONS no_delflag = 1 document_not_found = 2 original1_not_found = 3 original2_not_found = 4 OTHERS = 5.



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 /TDAG/RCSR_PRP_UPLOAD_XLSFILE or its description.