how to release a session thru coding

[Former Member]

hi friends,

i am wrkingon a code to release a session which is a day old and still lying "in processing" state

i m using uc4 to get the details of such sessions frm sap

but i need to write a code in sap for

a) get hold of tht session

b) release tht session

i knw tht the sessions names are mentioned in apqi table but i cnt trace the session status in it .

i cnt locate wht is the status entry when the sessionis in new and in processing

can u guys help me in this ?

if possible will u guys pls send me sample code pertaning to this

[Former Member]

check APQI table with datatyp = 'BDC', groupid = 'your session name', qstate will have the status of the session.

[Former Member]

actually i have tried tht but i cnt locate the qstate entry for session inbackground,and most importantly ''in new''

like qstate for in processing is ''r''

can u help me in this?

[Former Member]

actually i have tried tht but i cnt locate the qstate entry for session inbackground,and most importantly ''in new''

like qstate for in processing is ''r''

can u help me in this?

[sreeramkumar_madisetty]

Hi

Can I know how u r processing the sessions?

Whether in fore ground or in Background thru

SUBMIT rsbdcsub

WITH mappe EQ 'session name' " Session Name

WITH von EQ sy-datum " Starting Interval date

WITH bis EQ sy-datum " Closing Interval Date

WITH z_verarb EQ 'X'

WITH logall EQ 'X' " Log Info

AND RETURN .

try with this by changing the dates which ever u required and check the the specified tables also.

Regards,

kumar