SAP RH_START_EXCEL_DATA_OLE Function Module for (obsolete)

Search SAP Function Modules

RH_START_EXCEL_DATA_OLE is a standard rh start excel data ole SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for (obsolete) processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.

See here to view full function module documentation and code listing for rh start excel data ole FM, simply by entering the name RH_START_EXCEL_DATA_OLE into the relevant SAP transaction such as SE37 or SE38.

Function Group: HRBAS00OFFICE
Program Name: SAPLHRBAS00OFFICE
Main Program: SAPLHRBAS00OFFICE
Appliation area: H
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:

Function RH_START_EXCEL_DATA_OLE pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.

CALL FUNCTION 'RH_START_EXCEL_DATA_OLE'"(obsolete)
  EXPORTING
*  DATA_NAME =  "Name of data file on presentation server
*  DATA_YBOT_COR = 0 "Bottom right corner of data field (y value)
*  CATEGORY_XTOP_COR = 0 "Top left corner of category axis title
*  CATEGORY_YTOP_COR = 0 "Top left corner of category axis title
*  CATEGORY_XBOT_COR = 0 "Bottom right corner of category axis title
*  CATEGORY_YBOT_COR = 0 "Bottom right corner of category axis title
*  DATA_TAB =  "Data table
*  CHART_TITLE = ' ' "Title for chart
*  CHART_TYPE = 2 "Type of chart (bar chart, ...)
*  CATEGORY_TITLE = ' ' "Title of category axis
*  VALUE_TITLE = ' ' "Title of value axis
*  DATA_XTOP_COR = 0 "Top left corner of data field (x value)
*  DATA_YTOP_COR = 0 "Top left corner of data field (y value)
*  DATA_XBOT_COR = 0 "Bottom right corner of data field (x value)

EXCEPTIONS
   NO_BATCH = 1    DOWNLOAD_ERROR = 2    INTERNAL_ERROR = 3    NO_OLE_SUPPORT = 4    OLE_FILE_ERROR = 5    OLE_ERROR = 6    NO_DATA = 7    COORDINATE_ERROR = 8 

.

IMPORTING Parameters details for RH_START_EXCEL_DATA_OLE

DATA_NAME - Name of data file on presentation server

Data type: STRING
Optional: Yes
Call by Reference: Yes

DATA_YBOT_COR - Bottom right corner of data field (y value)

Data type: I
Optional: Yes
Call by Reference: Yes

CATEGORY_XTOP_COR - Top left corner of category axis title

Data type: I
Optional: Yes
Call by Reference: Yes

CATEGORY_YTOP_COR - Top left corner of category axis title

Data type: I
Optional: Yes
Call by Reference: Yes

CATEGORY_XBOT_COR - Bottom right corner of category axis title

Data type: I
Optional: Yes
Call by Reference: Yes

CATEGORY_YBOT_COR - Bottom right corner of category axis title

Data type: I
Optional: Yes
Call by Reference: Yes

DATA_TAB - Data table

Data type: TABLE
Optional: Yes
Call by Reference: No ( called with pass by value option)

CHART_TITLE - Title for chart

Data type:
Default: SPACE
Optional: Yes
Call by Reference: Yes

CHART_TYPE - Type of chart (bar chart, ...)

Data type: I
Default: 2
Optional: Yes
Call by Reference: Yes

CATEGORY_TITLE - Title of category axis

Data type:
Default: SPACE
Optional: Yes
Call by Reference: Yes

VALUE_TITLE - Title of value axis

Data type:
Default: SPACE
Optional: Yes
Call by Reference: Yes

DATA_XTOP_COR - Top left corner of data field (x value)

Data type: I
Optional: Yes
Call by Reference: Yes

DATA_YTOP_COR - Top left corner of data field (y value)

Data type: I
Optional: Yes
Call by Reference: Yes

DATA_XBOT_COR - Bottom right corner of data field (x value)

Data type: I
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

NO_BATCH - Batch call not permitted

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

DOWNLOAD_ERROR - File could not be created

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

INTERNAL_ERROR - Internal error

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

NO_OLE_SUPPORT - OLE cannot be performed because EXCEL has not been started

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

OLE_FILE_ERROR - The file could not be imported

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

OLE_ERROR - Important OLE call causes error

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

NO_DATA - Table DATA_TAB does not contain any data

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

COORDINATE_ERROR - Invalid coordinates!

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for RH_START_EXCEL_DATA_OLE Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

ABAP code using 7.40 inline data declarations to call FM RH_START_EXCEL_DATA_OLE

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

Search for further information about these or an SAP related objects