Read the log for a finished batchinput -SUBMIT rsbdcsub-

[Former Member]

Hello,

I have executed a b.i.session with SUBMIT rsbdcsub in my program.

My question is: how can I get the result status now??? I need to know if the transaction finished ok or not...

Is there any parameter with the SUBMIT rsbdcsub?... Or... Have I to do a submit to another program to read the status of the session name?

Thanks in advance,

Carles

[Former Member]

You can look at the results in the SM35 transaction for each session individually.

Regards,

Ravi

[Former Member]

Ok, yes, I know it... But I need to do this read, inside the program code... After the submit sentence...

[Former Member]

Hi Carles!

To read the status of the session from within the program after submitting the program rsbdcsub, you can check from table apqi.

DATA i_apqi LIKE TABLE OF apqi WITH HEADER LINE.

DATA : msg1(50) TYPE c,

msg2(50) TYPE c,

msg3(50) TYPE c.

**********

SUBMIT rsbdcsub WITH mappe EQ group_name

WITH fehler EQ ' '

WITH z_verarb EQ 'X'

EXPORTING LIST TO MEMORY

AND RETURN.

WAIT UP TO 5 SECONDS. " For session to complete processing.

SELECT * UP TO 1 ROWS INTO TABLE i_apqi

FROM apqi

WHERE groupid = group_name

AND credate <= sy-datum

AND cretime <= sy-uzeit

ORDER BY cretime DESCENDING.

READ TABLE i_apqi INDEX 1.

clear : msg1, msg2, msg3.

concatenate 'Session' group_name into msg1 SEPARATED BY SPACE.

IF i_apqi-qstate = 'F'.

msg2 = 'has been successfully processed'.

MESSAGE i150 WITH msg1 msg2

.

ELSEIF i_apqi-qstate = 'E'.

msg2 = 'has been processed with errors.'.

msg3 = 'Please use SM35 to view the errors'.

MESSAGE i150 WITH msg1 msg2 msg3 .

ELSE. " Still in processing.

msg2 = 'has been transferred to the background for'.

msg3 = 'processing. Please use SM35 to view the status'.

MESSAGE i150 WITH msg1 msg2 msg3.

ENDIF.

Hope that was what you wanted.

Thanks,

Susmitha

[Former Member]

Hi,

Once rsbdcsub has been executed, you can got to SM35 and see the status of the session there.

It will be either Processed or in Processing or in Error status.

You can check the log by selecting your session and clicking on analysis. Third tab is log.

Yes you can give parameters, otherwise it will process all unprocessed sessions, thus consuming a lot of time.

Parameters include

session Name : mappe.

created on - from date : von

created on - to date : bis

session status - New : z_verarb EQ ' ' or 'X'.

session status - Incorred : fehler EQ 'X' or ' '.

Thanks,

Susmitha

Dont forget to reward points for useful answers.