topic Re: how to release a session thru coding in Application Development and Automation Discussions

how to release a session thru coding

Former Member — Mon, 12 Feb 2007 07:17:53 GMT

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 — Mon, 12 Feb 2007 21:03:11 GMT

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

Former Member — Tue, 13 Feb 2007 04:04:51 GMT

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 — Tue, 13 Feb 2007 04:05:47 GMT

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 — Tue, 13 Feb 2007 05:12:03 GMT

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