Background job getting CANCELLED

[Former Member]

hi,

one background job is scheduled for a report which is getting status CANCELLED after executing.....what could be the problem exactly here?

[former_member156446]

make sure you do not have any GUI_download or GUi_upload or any kind of gui interference in the code.

or an exception is being raised which you might have not handled in code.

[Former Member]

its giving error "SQLerror while accessing LIKP table"

its showing error for following piece of code:

select vbtyp vbeln vkorg into (likp-vbtyp, likp-vbeln, likp-vkorg)

from likp where wadat_ist in s_wadat.

if LIKP-VBTYP Eq 'T'. "Returns Delivery

ww_pos_neg = 0 - 1.

else.

ww_pos_neg = 1.

endif.

select single vbeln into vbuk-vbeln

from vbuk where vbeln eq likp-vbeln

and fkstk in ('A', 'B')

and gbstk in ('B', 'C').

check sy-subrc = 0.

select lfimg vgbel vgpos vrkme umvkz umvkn posnr into

(lips-lfimg, lips-vgbel, lips-vgpos,

lips-vrkme, lips-umvkz, lips-umvkn, lips-posnr)

from lips where vbeln = likp-vbeln.

CHECK NOT LIPS-LFIMG IS INITIAL. "Ignore when del qty is zero

PERFORM B_EXTRACT_DATA.

endselect.

endselect.

[Former Member]

go thru ST22 and see where the issue is. And remove nested select statements from the code first.

[Former Member]

Nobody can help much if you don't say what the error is.

Rob