RKE_HDB_WRITE_DATA SAP ABAP Report - Replication of CO-PA Data to SAP HANA Database

RKE_HDB_WRITE_DATA is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for You can use this program to transfer actual data and plan data from operating concerns to the SAP HANA database...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 RKE_HDB_WRITE_DATA 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

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

Text pool values

INCLUDES used within this REPORT RKE_HDB_WRITE_DATA

INCLUDE: RKE_HDB_WRITE_DATA_F02.

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'
      IMPORTING
        ERKRS   = P_ERKRS
        PA_TYPE = G_PATYPE
      EXCEPTIONS
        OTHERS  = 1.

POPUP_TO_CONFIRM
      CALL FUNCTION 'POPUP_TO_CONFIRM'
        EXPORTING
          TITLEBAR              = TEXT-005
          TEXT_QUESTION         = TEXT-006
          DISPLAY_CANCEL_BUTTON = FALSE
        IMPORTING
          ANSWER                = G_ANSWER
        EXCEPTIONS
          TEXT_NOT_FOUND        = 1
          OTHERS                = 2.

RKE_CHECK_GENERATION
  CALL FUNCTION 'RKE_CHECK_GENERATION'
    EXPORTING
      ERKRS  = P_ERKRS
    EXCEPTIONS
      OTHERS = 1.

RKE_CHECK_GENERATION
  CALL FUNCTION 'RKE_CHECK_GENERATION'
    EXPORTING
      ERKRS  = P_ERKRS
    EXCEPTIONS
      OTHERS = 1.

BAL_LOG_CREATE
  CALL FUNCTION 'BAL_LOG_CREATE'
    EXPORTING
      I_S_LOG      = S_LOG
    IMPORTING
      E_LOG_HANDLE = G_LOG_HANDLE
    EXCEPTIONS
      OTHERS       = 1.

RKE_ACC_CHECK_DELTA_INDEX
    CALL FUNCTION 'RKE_ACC_CHECK_DELTA_INDEX'
      EXCEPTIONS
        OTHERS = 1.

ENQUEUE_EKCND
    CALL FUNCTION 'ENQUEUE_EKCND'
      EXPORTING
        ERKRS          = P_ERKRS
      EXCEPTIONS
        FOREIGN_LOCK   = 1
        SYSTEM_FAILURE = 2
        OTHERS         = 3.

DEQUEUE_EKCND
    CALL FUNCTION 'DEQUEUE_EKCND'
      EXPORTING
        ERKRS = P_ERKRS.

RKE_NUMBER_GET_CURRENT
  CALL FUNCTION 'RKE_NUMBER_GET_CURRENT'
    EXPORTING
      I_NR_RANGE_NR     = '01'
      I_OBJECT          = 'COPA_OBJ'
      I_SUBOBJECT       = SUBOBJECT
      I_FROM_ALL_SERVER = TRUE
    IMPORTING
      E_NRLEVEL         = NRLEVEL
    EXCEPTIONS
      OTHERS            = 1.

DB_COMMIT
  CALL FUNCTION 'DB_COMMIT'.

HDB_TABLE_DROP
    CALL FUNCTION 'HDB_TABLE_DROP'
      EXPORTING
        I_TABNAME        = TABNAME
        I_DROP_WITH_DATA = TRUE
        I_APPLICATION    = 'KE'
        I_SUBAPPLICATION = SUB_APPL
        I_KEY_VALUE      = KEY
      EXCEPTIONS
        OTHERS           = 1.

HDB_TABLE_DROP
      CALL FUNCTION 'HDB_TABLE_DROP'
        EXPORTING
          I_TABNAME        = 'COBK'
          I_DROP_WITH_DATA = TRUE
          I_APPLICATION    = 'KE'
          I_SUBAPPLICATION = SUB_APPL
          I_KEY_VALUE      = KEY
        EXCEPTIONS
          OTHERS           = 1.

RKE_HDBC_TABLE_CREATE
  CALL FUNCTION 'RKE_HDBC_TABLE_CREATE'
    EXPORTING
      I_ERKRS  = P_ERKRS
      I_PATYPE = G_PATYPE
      I_ACT    = ACT
      I_PLAN   = PLAN
      I_CE4    = CE4
    EXCEPTIONS
      OTHERS   = 1.

RKE_HDBC_OLAP_VIEW_GET
  CALL FUNCTION 'RKE_HDBC_OLAP_VIEW_GET'
    EXPORTING
      I_ERKRS        = P_ERKRS
      I_PATYPE       = G_PATYPE
      I_CHECK_STATUS = TRUE
    EXCEPTIONS
      STATUS_NOT_OK  = 1
      OTHERS         = 2.

RKE_HDBC_OLAP_CREATE
  CALL FUNCTION 'RKE_HDBC_OLAP_CREATE'
    EXPORTING
      I_ERKRS  = P_ERKRS
      I_PATYPE = G_PATYPE
    EXCEPTIONS
      OTHERS   = 1.

ENQUEUE_EKCCESVBE
    CALL FUNCTION 'ENQUEUE_EKCCESVBE'
      EXPORTING
        ERKRS        = P_ERKRS
        _WAIT        = TRUE
      EXCEPTIONS
        FOREIGN_LOCK = 1
        OTHERS       = 2.

RKE_TIMESTAMP_CONVERT_INPUT
  CALL FUNCTION 'RKE_TIMESTAMP_CONVERT_INPUT'
    EXPORTING
      I_DATE     = SY-DATUM
      I_DAYST    = SY-DAYST
      I_TIME     = SY-UZEIT
      I_TZONE    = SY-TZONE
    IMPORTING
      E_TIMESTMP = NOW.

DEQUEUE_EKCCESVBE
  CALL FUNCTION 'DEQUEUE_EKCCESVBE'
    EXPORTING
      ERKRS = P_ERKRS.

DB_COMMIT














  CALL FUNCTION 'DB_COMMIT'.

RKE_HDB_INSERT_DATA
    CALL FUNCTION 'RKE_HDB_INSERT_DATA'
      EXPORTING
        I_DBCON       = G_DBCON
        I_TABLE       = TABNAME
        I_WHERE       = WHERE_CL
      IMPORTING
        E_DBCNT_READ  = DBCNT_READ
        E_DBCNT_WRITE = DBCNT_WRITE
        E_TIME_READ   = TIME_READ
        E_TIME_WRITE  = TIME_WRITE.

RKE_HDB_INSERT_DATA
    CALL FUNCTION 'RKE_HDB_INSERT_DATA' STARTING NEW TASK S_TASK-ID
      DESTINATION IN GROUP P_GROUP
      PERFORMING DONE ON END OF TASK
      EXPORTING
        I_DBCON               = G_DBCON
        I_TABLE               = TABNAME
        I_WHERE               = WHERE_CL
      EXCEPTIONS
        RESOURCE_FAILURE      = 1
        SYSTEM_FAILURE        = 2  MESSAGE MSG
        COMMUNICATION_FAILURE = 3  MESSAGE MSG
        OTHERS                = 4.

RKE_READ_ERKRS_MESSAGE
  CALL FUNCTION 'RKE_READ_ERKRS_MESSAGE'
    EXPORTING
      I_ERKRS   = P_ERKRS
    IMPORTING
      E_V_TKEBB = S_TKEBB
    EXCEPTIONS
      OTHERS    = 1.