SAP Reports / Programs | Controlling | Profitability Analysis | Tools(CO-PA-TO) SAP CO

RKEBW3RE SAP ABAP Report - Retractor: Query Data Transfer







RKEBW3RE 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 RKEBW3RE 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

KELR - BW/CO-PA Retraction: Execute


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 RKEBW3RE. "Basic submit
SUBMIT RKEBW3RE AND RETURN. "Return to original report after report execution complete
SUBMIT RKEBW3RE VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Retractor: Query Data Transfer
Text Symbol: 001 = Name of transfer
Text Symbol: 002 = BW System
Text Symbol: 003 = Query
Text Symbol: 004 = BW-CO-PA Field Assignment
Text Symbol: 005 = Variant for Query Variable
Text Symbol: 006 = Actual
Text Symbol: 007 = Plan
Text Symbol: 008 = Record Type
Text Symbol: 009 = Version
Text Symbol: 010 = Create Variant for Query Variable
Text Symbol: 011 = Transfer planning data on weekly basis
Text Symbol: 012 = Perform Valuation
Text Symbol: 013 = Test Run Without DB Update
Text Symbol: 014 = BW data
Text Symbol: 015 = CO-PA update
Text Symbol: 016 = Planning functions
Text Symbol: 017 = Logs
Text Symbol: 018 = Reverse
Text Symbol: 019 = Query Variable
Text Symbol: 020 = Update of Correct Line Items Despite Error Messages


INCLUDES used within this REPORT RKEBW3RE

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:

COPA_GET_ERK CALL FUNCTION 'COPA_GET_ERK' EXPORTING mode = 'F' IMPORTING ERKRS = GS_ERKRS * ok_code = ok_code PA_TYPE = GS_PATYPE EXCEPTIONS ERKRS_INACTIVE = 1.

RKE_CHECK_GENERATION CALL FUNCTION 'RKE_CHECK_GENERATION' EXPORTING ERKRS = GS_ERKRS.

RSCRMBW_REPORT CALL FUNCTION 'RSCRMBW_REPORT' "initialisation of report DESTINATION GS_BW_SY EXPORTING I_MODE = 'OPEN' I_REPORTUID = GS_QUERY I_REPNAME = GS_REP IMPORTING E_REPORTUID = EX_REPORTUID * E_CUBENAME = E_CUBENAME "JW HW520104 TABLES E_T_AXIS = E_T_AXIS E_T_CELL = E_T_CELL * e_t_meta = e_t_meta " not available any more E_T_RETURN = E_T_RETURN E_T_MDX = E_T_MDX EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

RSCRMBW_FLATTEN_VIEW CALL FUNCTION 'RSCRMBW_FLATTEN_VIEW' DESTINATION GS_BW_SY EXPORTING I_REPORTUID = GS_QUERY I_INCLUDE_SLICER = 'X' TABLES E_T_MDX = E_T_MDX E_T_RETURN = E_T_RETURN.

RSCRMBW_DIMENSIONS_GET CALL FUNCTION 'RSCRMBW_DIMENSIONS_GET' " get dimensions of query DESTINATION GS_BW_SY EXPORTING I_REPORTUID = GS_QUERY TABLES E_T_CRMDIM = E_T_CRMDIM E_T_RETURN = E_T_RETURN EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

RSCRMBW_VARIABLES_SET CALL FUNCTION 'RSCRMBW_VARIABLES_SET' DESTINATION GS_BW_SY EXPORTING I_REPORTUID = GS_QUERY I_VARIANT = GS_VARNT TABLES I_T_CRMVAR = VARIABLES I_T_CRMVARP = I_T_CRMVARP E_T_RETURN = E_T_RETURN E_T_MDX = E_T_MDX EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

BAPI_MDPROVIDER_GET_VARIABLES CALL FUNCTION 'BAPI_MDPROVIDER_GET_VARIABLES' DESTINATION GS_BW_SY EXPORTING * cat_nam = e_catalog CUBE_NAM = E_CUBENAME IMPORTING RETURN = WA_RETURN TABLES VARIABLES = VARIABLES.

RSCRMBW_VARIABLE_POPUP CALL FUNCTION 'RSCRMBW_VARIABLE_POPUP' DESTINATION GS_BW_SY EXPORTING I_REPORTUID = GS_QUERY TABLES E_T_CRMVAR = I_T_CRMVAR E_T_MDX = E_T_MDX E_T_RETURN = E_T_RETURN EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

RSCRMBW_REPORT CALL FUNCTION 'RSCRMBW_REPORT' DESTINATION GS_BW_SY EXPORTING I_MODE = 'START' I_REPORTUID = GS_QUERY I_REPNAME = GS_REP IMPORTING E_REPORTUID = EX_REPORTUID TABLES E_T_AXIS = E_T_AXIS E_T_CELL = E_T_CELL * e_t_meta = e_t_meta E_T_RETURN = E_T_RETURN E_T_MDX = E_T_MDX EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

RSCRMBW_REPORT CALL FUNCTION 'RSCRMBW_REPORT' DESTINATION GS_BW_SY EXPORTING I_MODE = 'CLOSE' I_REPORTUID = GS_QUERY I_REPNAME = GS_REP IMPORTING E_REPORTUID = EX_REPORTUID EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

KEX2_PROG_ACTION_DETERMINE CALL FUNCTION 'KEX2_PROG_ACTION_DETERMINE' EXPORTING I_AREA = 'QUERY_DATA_TRANSFER' I_GENERATE = 'X' I_ERKRS = GS_ERKRS IMPORTING E_IS_ACTIVE = E_IS_ACTIVE E_PROGNAME = PROGNAME EXCEPTIONS ERROR = 1.

RSZ_X_CONTROL_TEXTS_GET CALL FUNCTION 'RSZ_X_CONTROL_TEXTS_GET' DESTINATION GS_BW_SY EXPORTING I_LANGU = SY-LANGU IMPORTING ESUBRC = L_SUBRC E_FRONTEND_MAJOR_VERSION = L_FRONTEND_MAJOR_VERSION E_FRONTEND_MINOR_VERSION = L_FRONTEND_MINOR_VERSION E_FRONTEND_REVISION = L_FRONTEND_REVISION E_SERVER_VERSION = L_SERVER_VERSION E_MAX_FRONTEND_MAJOR_VERSION = L_MAX_FRONTEND_MAJOR_VERSION E_MAX_FRONTEND_MINOR_VERSION = L_MAX_FRONTEND_MINOR_VERSION E_MAX_FRONTEND_REVISION = L_MAX_FRONTEND_REVISION * tables * e_t_control_text structure rsz_x_control_text optional * e_t_operator structure rsz_x_treecontent optional * e_t_treestructure structure rsz_x_treestructure optional EXCEPTIONS COMMUNICATION_FAILURE = 3 SYSTEM_FAILURE = 5 OTHERS = 6.

RSZ_X_CONTROL_TEXTS_GET CALL FUNCTION 'RSZ_X_CONTROL_TEXTS_GET' DESTINATION GS_BW_SY EXPORTING I_LANGU = SY-LANGU IMPORTING ESUBRC = L_SUBRC E_FRONTEND_MAJOR_VERSION = L_FRONTEND_MAJOR_VERSION E_FRONTEND_MINOR_VERSION = L_FRONTEND_MINOR_VERSION E_FRONTEND_REVISION = L_FRONTEND_REVISION E_SERVER_VERSION = L_SERVER_VERSION E_MAX_FRONTEND_MAJOR_VERSION = L_MAX_FRONTEND_MAJOR_VERSION E_MAX_FRONTEND_MINOR_VERSION = L_MAX_FRONTEND_MINOR_VERSION E_MAX_FRONTEND_REVISION = L_MAX_FRONTEND_REVISION * tables * e_t_control_text structure rsz_x_control_text optional * e_t_operator structure rsz_x_treecontent optional * e_t_treestructure structure rsz_x_treestructure optional EXCEPTIONS COMMUNICATION_FAILURE = 3 SYSTEM_FAILURE = 5 OTHERS = 6.

DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING DYNAME = SY_REPID "sy-repid DYNUMB = SY-DYNNR TRANSLATE_TO_UPPER = ' ' TABLES DYNPFIELDS = DYNPFIELDS.

BAPI_MDPROVIDER_GET_CUBES CALL FUNCTION 'BAPI_MDPROVIDER_GET_CUBES' DESTINATION GS_BW_SY EXPORTING CUBE_NAM = L_CUBE_NAM IMPORTING RETURN = L_RETURN TABLES CUBES = L_CUBES.

DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING DYNAME = SY_REPID "sy-repid DYNUMB = SY-DYNNR TRANSLATE_TO_UPPER = ' ' TABLES DYNPFIELDS = DYNPFIELDS.

BAPI_MDPROVIDER_GET_CUBES CALL FUNCTION 'BAPI_MDPROVIDER_GET_CUBES' DESTINATION GS_BW_SY EXPORTING CUBE_NAM = L_CUBE_NAM IMPORTING RETURN = L_RETURN TABLES CUBES = L_CUBES.

RSCRMBW_ATTRIBUTES_GET CALL FUNCTION 'RSCRMBW_ATTRIBUTES_GET' DESTINATION L_TKEBWLRE-BW_SYS EXPORTING I_REPORTUID = L_TKEBWLRE-QUERY I_IOBJNM = WA_RSCRMDIM-IOBJNM TABLES E_T_CRMATR = I_T_RSCRMATR E_T_RETURN = E_T_RETURN EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

BAPI_IOBJ_GETDETAIL





* call function 'BAPI_IOBJ_GETDETAIL' * destination l_tkebwlre-l_bw_sys * exporting * infoobject = wa_rscrmatr-atr_nam * importing * details = wa_detail * return = e_return.

RSCRMBW_ATTRIBUTES_GET CALL FUNCTION 'RSCRMBW_ATTRIBUTES_GET' "don't want to save this DESTINATION L_TKEBWLRE-BW_SYS EXPORTING I_REPORTUID = L_TKEBWLRE-QUERY I_IOBJNM = WA_RSCRMDIM-IOBJNM TABLES E_T_CRMATR = I_T_RSCRMATR E_T_RETURN = E_T_RETURN EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

BAPI_IOBJ_GETDETAIL * call function 'BAPI_IOBJ_GETDETAIL' * destination l_tkebwlre-l_bw_sys * exporting * infoobject = wa_rscrmatr-atr_nam * importing * details = wa_detail * return = e_return.

DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING DYNAME = 'RKEBW3RE' "sy-repid DYNUMB = SY-DYNNR TRANSLATE_TO_UPPER = ' ' TABLES DYNPFIELDS = DYNPFIELDS.

RSCRM_REPORT_VARIANTS_F4 CALL FUNCTION 'RSCRM_REPORT_VARIANTS_F4' DESTINATION GS_BW_SY EXPORTING I_REPORTUID = GS_QUERY IMPORTING E_VARIANT = GS_VARNT TABLES E_T_RETURN = E_T_RETURN EXCEPTIONS ERROR = 1 COMMUNICATION_FAILURE = 4.

DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING DYNAME = SY_REPID "sy-repid DYNUMB = SY-DYNNR TRANSLATE_TO_UPPER = ' ' TABLES DYNPFIELDS = DYNPFIELDS.

HELP_VALUES_GET_WITH_TABLE call function 'HELP_VALUES_GET_WITH_TABLE' exporting FIELDNAME = 'QUERY' TABNAME = 'TKEBWLTNT' importing SELECT_VALUE = GS_QUERY tables FIELDS = LT_FIELDS VALUETAB = VALUES_QUERY.

HELP_VALUES_GET_WITH_TABLE CALL FUNCTION 'HELP_VALUES_GET_WITH_TABLE' EXPORTING * display = display TABNAME = 'TKVS' FIELDNAME = 'VERSI' IMPORTING SELECT_VALUE = GS_VERSI TABLES FIELDS = FIELDS VALUETAB = VALUES.

RSCRMBW_KEY_FIGURES_GET CALL FUNCTION 'RSCRMBW_KEY_FIGURES_GET' DESTINATION BWSYS EXPORTING I_REPORTUID = QUERY TABLES E_T_CRMKYF = E_T_CRMKYF E_T_RETURN = E_T_RETURN EXCEPTIONS COMMUNICATION_FAILURE = 4 SYSTEM_FAILURE = 5 OTHERS = 7.

RSCRMBW_KEY_FIGURES_GETDETAIL CALL FUNCTION 'RSCRMBW_KEY_FIGURES_GETDETAIL' DESTINATION BWSYS EXPORTING I_REPORTUID = QUERY I_MEM_NAM = S_CRMKYF-MEMNAM * IMPORTING * E_S_CRMKYFDETAIL = E_S_CRMKYFDETAIL TABLES E_T_CRMKYFFILTER = E_T_CRMKYFFILTER E_T_RETURN = E_T_RETURN.



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