/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
Below is a list of transaction codes which are relevant to this SAP report
/TDAG/RCS_PRP_CGBC - RCS PRP: Upload Excel Macro
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.
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
INCLUDE: CBUI09.
No SAP DATABASE tables are accessed within this REPORT code!
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.
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
/TDAG/RCSR_PRP_UPLOAD_XLSFILE - Upload Macro for Preregistration Output: Macro File /TDAG/RCSR_PRP_UPLOAD_XLSFILE - Upload Macro for Preregistration Output: Macro File /TDAG/RCSR_PRP_IMPORT_RESULTS - Import Preregistration Results: Result File /TDAG/RCSR_PRP_IMPORT_RESULTS - Import Preregistration Results: Result File /TDAG/RCSR_PROP_CONVERT - Convert Property and Characteristic Mappings /TDAG/RCSR_PROP_CONVERT - Convert Property and Characteristic Mappings