RFTBDF_OLE SAP ABAP Report - Program RFTBDF_OLE
RFTBDF_OLE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Spreadsheet: Import Market Data Report RFTBDF_OLE (transaction TBEX or TBEXN with the enhanced UI) allows you to transfer external market data directly from a spreadsheet to the SAP system...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 RFTBDF_OLE 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
TBEX - Spreadsheet for Market Data
TBEXN - Spreadsheet Upload of Market Data
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 RFTBDF_OLE. "Basic submit
SUBMIT RFTBDF_OLE AND RETURN. "Return to original report after report execution complete
SUBMIT RFTBDF_OLE 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: S_KDATE = D .
Title: Program RFTBDF_OLE
Text Symbol: 234 = Status
Text Symbol: 235 = Term
Text Symbol: 237 = Error message
Text Symbol: 300 = Test run was carried out
Text Symbol: 335 = @01@ Entries copied
Text Symbol: 336 = @03@ Entries not copied
Text Symbol: 444 = Do you wish to leave the spreadsheet?
Text Symbol: 445 = Cancel
Text Symbol: 446 = Should the spreadsheet created be saved first?
Text Symbol: 447 = End Spreadsheet
Text Symbol: 450 = File name & was saved
Text Symbol: 451 = Configuration was saved
Text Symbol: 567 = From-factor & contains invalid signs!
Text Symbol: 568 = To-factor & contains invalid signs!
Text Symbol: 655 = R/3 Treasury mkt data
Text Symbol: 693 = Spreadsheet market data interface
Text Symbol: 803 = Select document cat
Text Symbol: 900 = Test run finished
Text Symbol: 920 = File format must be .xls, otherwise errors may occur.
Text Symbol: 921 = Error when uploading Excel file; allow macros in Excel
Text Symbol: 233 = Strike Amount
Text Symbol: 001 = Due date is missing
Text Symbol: 002 = Due date &1 is not valid for DCS ID &2
Text Symbol: 003 = Due date &1 is not valid for due date &2
Text Symbol: 050 = Spreadsheet is being opened
Text Symbol: 071 = Market data transfer is starting
Text Symbol: 072 = Market data is being checked and saved
Text Symbol: 073 = Market data is displayed
Text Symbol: 089 = File & was saved
Text Symbol: 100 = PC file
Text Symbol: 101 = File selection not possible
Text Symbol: 202 = Class
Text Symbol: 205 = Key 1
Text Symbol: 208 = Key 2
Text Symbol: 210 = Cat
Text Symbol: 213 = Date
Text Symbol: 216 = Time
Text Symbol: 219 = Val.
Text Symbol: 222 = Currncy
Text Symbol: 225 = "Fr" ratio
Text Symbol: 228 = To factor
Text Symbol: 231 = Addit.
Text Symbol: 232 = Put/Call
INCLUDES used within this REPORT RFTBDF_OLE
INCLUDE OFFICEINTEGRATIONINCLUDE.
INCLUDE DEMOOFFICEINTEGRATIONUTILS.
INCLUDE OFFICEINTEGRATION_UI_ENH.
INCLUDE RFTBDF_OLE_SCREEN_MODIFYO01.
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:
TB_DATAFEED_CUS_AUTHORITY_CHKS call function 'TB_DATAFEED_CUS_AUTHORITY_CHKS' tables sop_scl = klasse.
TB_DATAFEED_GET_CUST_ALL call function 'TB_DATAFEED_GET_CUST_ALL' exporting feedname = feedname * SOURCE = 'F' tables klasse = klasse rkey1 = rkey1 rkey2 = rkey2 sinstrumnt = sinstrumnt sap_cust = sap_cust.
TB_DATAFEED_GET_CUST_ALL CALL FUNCTION 'TB_DATAFEED_GET_CUST_ALL' EXPORTING feedname = feedname TABLES klasse = klasse rkey1 = rkey1 rkey2 = rkey2 sinstrumnt = sinstrumnt keydate = r_keydates PRICEDATE = r_pricedates sap_cust = sap_cust.
TB_DATAFEED_CHECK_CUSTOMIZING call function 'TB_DATAFEED_CHECK_CUSTOMIZING' tables sap_cust = local_market_data_table[] error_sap_cust = error_market_data_table[] exceptions error_found = 0 others = 0.
TB_DATAFEED_R3TABLES_UPDATE call function 'TB_DATAFEED_R3TABLES_UPDATE' exporting filesource = 'X' ** Enable Test Run NOETZELS test_only = iv_test_run **// tables sap_answer = local_market_data_table[] exceptions update_error = 1 others = 2.
WS_QUERY call function 'WS_QUERY' exporting * ENVIRONMENT = filename = filename query = 'FE' "/ file exists * WINID = importing return = return_param exceptions inv_query = 1 no_batch = 2 frontend_error = 3 others = 4.
CONTROL_DISPATCH * call function 'CONTROL_DISPATCH' <<< OLD * exporting * fcode = lc_fcode.
WS_QUERY call function 'WS_QUERY' exporting * ENVIRONMENT = filename = filename query = 'FE'"/ file exists * WINID = importing return = return_parameter exceptions inv_query = 1 no_batch = 2 frontend_error = 3 others = 4.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting * PERCENTAGE = 0 text = status_text.
DYNP_VALUES_READ call function 'DYNP_VALUES_READ' exporting dyname = modul dynumb = lv_dynnr request = 'A' tables dynpfields = lt_dynpread .
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting * PERCENTAGE = 0 text = 'Tabellenkalkulation wird gestartet'(050).
SAP_OI_LOAD_MIME_DATA call function 'SAP_OI_LOAD_MIME_DATA' exporting object_id = descr-document_id importing data_size = doc_size document_type = docutype document_format = doc_format tables data_table = doc_table exceptions object_not_found = 1 internal_error = 2 others = 3.
WS_QUERY call function 'WS_QUERY' exporting * ENVIRONMENT = filename = filename query = 'FE'"/ file exists * WINID = importing return = return_parameter exceptions inv_query = 1 no_batch = 2 frontend_error = 3 others = 4.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = 'Tabellenkalkulation wird gestartet'(050).
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = status_text.
POPUP_TO_CONFIRM_LOSS_OF_DATA call function 'POPUP_TO_CONFIRM_LOSS_OF_DATA' exporting textline1 = 'Möchten Sie die Tabellenkalkulation abbrechen?'(444) * TEXTLINE2 = ' ' titel = 'Abbrechen'(445) * START_COLUMN = 25 * START_ROW = 6 importing answer = answer.
POPUP_TO_CONFIRM_STEP call function 'POPUP_TO_CONFIRM_STEP' exporting defaultoption = 'J' textline1 = 'Soll die erstellte Tabellenkalkulation vorher gespeichert werden?'(446) * TEXTLINE2 = ' ' titel = 'Tabellenkalkulation beenden'(447) * START_COLUMN = 25 * START_ROW = 6 * CANCEL_DISPLAY = 'X' importing answer = answer.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = status_text.
HELP_OBJECT_SHOW call function 'HELP_OBJECT_SHOW' exporting dokclass = 'RE' "# EC NOTEXT * DOKLANGU = SY-LANGU dokname = 'RFTBDF_OLE' "# EC NOTEXT * DOKTITLE = ' ' * CALLED_BY_PROGRAM = ' ' * CALLED_BY_DYNP = ' ' * CALLED_FOR_TAB = ' ' * CALLED_FOR_FIELD = ' ' * CALLED_FOR_TAB_FLD_BTCH_INPUT = ' ' * MSG_VAR_1 = ' ' * MSG_VAR_2 = ' ' * MSG_VAR_3 = ' ' * MSG_VAR_4 = ' ' * CALLED_BY_CUAPROG = ' ' * CALLED_BY_CUASTAT = * SHORT_TEXT = ' ' tables links = tline exceptions object_not_found = 1 sapscript_error = 2 others = 3.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = 'Marktdatenübernahme wird gestartet'(071).
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = 'Marktdaten werden geprüft und gespeichert'(072).
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = text-300.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = 'Marktdaten werden angezeigt'(073).
SAP_OI_LOAD_MIME_DATA call function 'SAP_OI_LOAD_MIME_DATA' exporting object_id = descr-document_id importing data_size = doc_size document_type = document_type document_format = doc_format tables data_table = doc_table exceptions object_not_found = 1 internal_error = 2 others = 3.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting * PERCENTAGE = 0 text = 'Konfiguration wurde gespeichert'(451).
WS_FILENAME_GET call function 'WS_FILENAME_GET' exporting mask = ',*.*,*.*.'
GUI_HAS_ACTIVEX call function 'GUI_HAS_ACTIVEX' importing return = b_has_activex.
RS_VALUES_BOX call function 'RS_VALUES_BOX' exporting * COLUMN_HEADING = ' ' * CURSOR_FIELD = 1 * CURSOR_LINE = 1 left_upper_col = 5 left_upper_row = 5 pagesize = 10 title = dialog_title importing linenumber = l_nr tables field_desc = field_desc value_tab = descr_list exceptions others = 1.
TB_DATAFEED_CHECK_DCS CALL FUNCTION 'TB_DATAFEED_CHECK_DCS' EXPORTING DCSID = TBAT_PRICEQUOT-DCSID MIC = TBAT_PRICEQUOT-mic keydate = keydate PRICETYPE = TBAT_PRICEQUOT-PRICETYPE PRICEDATE = TBAT_PRICEQUOT-PRICEDATE CHANGING SSTATS = lv_sstats ERROR_FLAG = lv_flag ERROR_MSG = lv_msg.
TB_DATAFEED_CHECK_DCS CALL FUNCTION 'TB_DATAFEED_CHECK_DCS' EXPORTING DCSID = TBAT_PRICEQUOT-DCSID keydate = keydate PRICETYPE = TBAT_PRICEQUOT-PRICETYPE PRICEDATE = TBAT_PRICEQUOT-PRICEDATE CHANGING SSTATS = lv_sstats ERROR_FLAG = lv_flag ERROR_MSG = lv_msg.
TBA_DCS_DISPLAY CALL FUNCTION 'TBA_DCS_DISPLAY' DESTINATION 'NONE' EXPORTING iv_dcs_id = uv_dcsid.
TBA_MIC_DISPLAY CALL FUNCTION 'TBA_MIC_DISPLAY' EXPORTING IV_MIC = uv_mic.
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 RFTBDF_OLE or its description.
RFTBDF_OLE - Program RFTBDF_OLE RFTBDF_OLE - Program RFTBDF_OLE RFTBDF20 - Datafeed: Deletion Of Technical Errors In Workflow DATAFEED RFTBDF20 - Datafeed: Deletion Of Technical Errors In Workflow DATAFEED RFTBDF19 - Datafeed: Output Of Technical Errors In Workflow DATAFEED RFTBDF19 - Datafeed: Output Of Technical Errors In Workflow DATAFEED