topic Re: why do we need a session in Application Development and Automation Discussions

why do we need a session

former_member644292 — Tue, 20 Feb 2007 18:50:53 GMT

in bdc session method we create a session by bdc_open_group , i want to know the exact functionality in creating this session .we procees this session in t code sm35.we r processing means it is updating the database,is that right.

thank u in advance......

Re: why do we need a session

Former Member — Tue, 20 Feb 2007 18:55:12 GMT

Hi,

Yes, when we processing the Session, it is nothing but we are enbtering the records in the Transaction(Database) and pressing the Savfe button, if we do the same thing manuvally it will take time so instead of this we do the BDC(Session method)

Regards

Sudheer

Re: why do we need a session

Former Member — Tue, 20 Feb 2007 18:55:21 GMT

Hi Chaitanya,

Creating a Session means that we are creating keeping the data to be uploaded in a format that can be readily made available to the transaction(One record at a time). This process can be thought of the the programatic equivalent of creating the records through transaction. Creating the session will not update the database as you already noticed. Just that we are keepinng the data ready in an internal table with the BDCDATA structure.

Regards,

Ravi

Re: why do we need a session

Former Member — Tue, 20 Feb 2007 19:02:05 GMT

hi chaitanya,

Batch input method is used to transfer data from internal table to database table through sessions.

Session is nothing but a intermediate step between internal table and database table. Data along with its action is stored in the session.

Unless u process the session, the data is not transferred to database table.

So v r using the t/c SM35 to process the session, in order transfer the data into the database table.

Regards...

Arun.

Re: why do we need a session

abdul_hakim — Tue, 20 Feb 2007 21:33:32 GMT

hi,

sessions are actually processed from the session queue sm35..So inorder to place the session in queue we need to create the same using bdc_open_group.

Without this you cannot process the session..

Cheers,

Hakim

Re: why do we need a session

Former Member — Fri, 23 Feb 2007 02:58:12 GMT

hi,

if you have to write something on to the file ...first step will be opening.

so in session method also first open the session using function module

BDC_OPEN_GROUP.

Data is transferred to session by BDC_insert.

this function creates the session through the program.

remember session is an intermediated step between internal table and database table. Data along with its action is stored in session ie data for screen fields,to which screen it is passes,the program name,and how the next screen is processed.

unless session is processed, the data is not transfered to database table.

BDC_ClOSE_GROUP.

Re: why do we need a session

Former Member — Fri, 23 Feb 2007 17:41:51 GMT

Bcoz

we can process the session in

1.back ground or foreground

2.The maximum time allowed for online execution should not exceed 300 seconds. User gets TIMEOUT error and an aborted transaction, if time for execution exceeds 300 seconds. To avoid these types of error.

use session .

3. u can schedule it (job).