Delete and recreate BWA BW Index as job, Batch as background job

[former_member270264]

Hi experts,

In t-code: RSDDB we can create bwa-bw index. But we dont want to do it every month. So i have created batch and background job program for it. But when i schedule to job its not working. When i execute the program myself its working without any problem. Is this just because batch cant handle some pop-ups or something else. Or is there any other way to do it?

Im also sharing my batch code.

DATA: bdcdata TYPE TABLE OF bdcdata WITH HEADER LINE,
xmsg TYPE TABLE OF bdcmsgcoll WITH HEADER LINE.

PARAMETERS:p_mode TYPE char1 DEFAULT 'N'.

REFRESH: bdcdata, xmsg.

PERFORM bdc_dynpro USING 'SAPLRSDDB_UI' '0100'.
PERFORM bdc_field USING 'BDC_OKCODE' '=QUERY'.
PERFORM bdc_field USING 'BDC_CURSOR' 'G_BIA_INDEX'.
PERFORM bdc_field USING 'G_BIA_INDEX' 'ZZ'.

PERFORM bdc_dynpro USING 'SAPLRSDDB_UI' '0100'.
PERFORM bdc_field USING 'BDC_OKCODE' '=CREATE'.
PERFORM bdc_field USING 'BDC_CURSOR' 'G_BIA_INDEX'.
PERFORM bdc_field USING 'G_BIA_INDEX' 'ZZ'.

PERFORM bdc_dynpro USING 'SAPLRSDDB_UI' '0200'.
PERFORM bdc_field USING 'BDC_OKCODE' '=AKTV'.
PERFORM bdc_field USING 'BDC_CURSOR' 'BIA_INDEX'.
PERFORM bdc_field USING 'BDC_SUBSCR' 'SAPLRSDDB_UI 0201TAB_SCREEN_SCA'.

PERFORM bdc_dynpro USING 'SAPLBTCH' '1010'.
PERFORM bdc_field USING 'BDC_OKCODE' '=IMMD'.

PERFORM bdc_dynpro USING 'SAPLBTCH' '1010'.
PERFORM bdc_field USING 'BDC_CURSOR' 'BTCH1010-PERIODIC'.
PERFORM bdc_field USING 'BDC_OKCODE' '=SAVS'.

PERFORM bdc_dynpro USING 'SAPLRSDDB_UI' '0100'.
PERFORM bdc_field USING 'BDC_OKCODE' '=BACK'.
PERFORM bdc_field USING 'BDC_CURSOR' 'G_BIA_INDEX'.

PERFORM bdc_field USING 'G_BIA_INDEX' 'ZZ'.

CALL TRANSACTION 'RSDDB' USING bdcdata
MODE p_mode
UPDATE 'S'

MESSAGES INTO xmsg.

*&---------------------------------------------------------------------*
*& Form BDC_DYNPRO
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* -->P_0242 text
* -->P_0243 text
*----------------------------------------------------------------------*
FORM bdc_dynpro USING program dynpro.
CLEAR bdcdata.
bdcdata-program = program.
bdcdata-dynpro = dynpro.
bdcdata-dynbegin = 'X'.
APPEND bdcdata.
ENDFORM. " BDC_DYNPRO
*&---------------------------------------------------------------------*
*& Form BDC_FIELD
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* -->P_0302 text
* -->P_P2_WERKS text
*----------------------------------------------------------------------*
FORM bdc_field USING fnam fval.
CLEAR bdcdata.
bdcdata-fnam = fnam.
bdcdata-fval = fval.
APPEND bdcdata.

ENDFORM. "BDC_FIELD

Thanks,