topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Wed, 28 Mar 2007 04:10:56 GMT

Hi ALL

When do we go for SESHEN METORD in BDC

what i know is :-

1) Background scheduling

2)error handling is automatic

3)syncronus

4)RSBDCSUB

5) Huge amount of DATA ( it seems it is not a genuine answer)

Hope you know what i need.

Regards

basheer

Re: BDC

Former Member — Wed, 28 Mar 2007 04:14:50 GMT

one time process and Immediate Update.

Re: BDC

Former Member — Wed, 28 Mar 2007 04:15:28 GMT

Hi Mohammed Ahmed,

Check this documentation about Session method.

In this method you transfer data from internal table to database table through sessions.

In this method, an ABAP/4 program reads the external data that is to be entered in the SAP System and stores the data in session. A session stores the actions that are required to enter your data using normal SAP transaction i.e., Data is transferred to session which in turn transfers data to database table.

Session is intermediate step between internal table and database table. Data along with its action is stored in session i.e., data for screen fields, to which screen it is passed, the program name behind it, and how the next screen is processed.

When the program has finished generating the session, you can run the session to execute the SAP transactions in it. You can either explicitly start and monitor a session or have the session run in the background processing system.

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

BDC_OPEN_GROUP

You create the session through program by BDC_OPEN_GROUP function.

Parameters to this function are:

• User Name: User name

• Group: Name of the session

• Lock Date: The date on which you want to process the session.

• Keep: This parameter is passed as ‘X’ when you want to retain session after

processing it or ‘ ‘ to delete it after processing.

BDC_INSERT

This function creates the session & data is transferred to Session.

Parameters to this function are:

• Tcode: Transaction Name

• Dynprotab: BDC Data

BDC_CLOSE_GROUP

This function closes the BDC Group. No Parameters.

Some additional information for session processing

When the session is generated using the KEEP option within the BDC_OPEN_GROUP, the system always keeps the sessions in the queue, whether it has been processed successfully or not.

However, if the session is processed, you have to delete it manually. When session processing is completed successfully while KEEP option was not set, it will be removed automatically from the session queue. Log is not removed for that session.

If the batch-input session is terminated with errors, then it appears in the list of INCORRECT session and it can be processed again. To correct incorrect session, you can analyze the session. The Analysis function allows to determine which screen and value has produced the error. If you find small errors in data, you can correct them interactively, otherwise you need to modify batch input program, which has generated the session or many times even the data file.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: BDC

Former Member — Wed, 28 Mar 2007 04:16:46 GMT

Hi Mohammed ,

Most of the reasons you haev mentioned are correct .

When volume of data is large : In call transaction the transaction is run only for one set of data , for the next set another call has to be made . So session is used when volume of data is large i.e. the transaction is to be called a number of times.

For this very reason that you can call the transaction a number of times so session is also used when we want to schedule the job in background.

It is easier to handle errors in session as we can handle all the errors at a go but in call transaction for each call we need to handle errors.

Regards

Arun

Re: BDC

Former Member — Wed, 28 Mar 2007 04:19:47 GMT

hai basheer

1) Background scheduling

SM36 - Create background job

SM37 - Background job monitor, Select background jobs

2)error handling is automatic

In call transaction use structure BDCMSGCOLL and for session method go to sm35

3)syncronus

During the processing no transaction is stored until the previous transaction has been written to the Database. This is called Synchronous Database update.

4)RSBDCSUB

Ready made program for Release batch-input sessions automatically

5) Huge amount of DATA ( it seems it is not a genuine answer)

More than 10000 records

**Please reward suitable points***

With Regards

Navin Khedikar

Re: BDC

Former Member — Wed, 28 Mar 2007 04:27:42 GMT

Hi,

Batch Input Session: In this method data consistency is checked with the help of screen logic.

As soon as the program generates the session, you will be able to run the session in order to execute the SAP transactions in it. Moreover, you can start the session, and at the same time, can monitor a session with the help of batch input management function. For this you have to choose:

System à Services à Batch input. Moreover, you can have the session run in the background processing.

Batch input method is a type of data transfer method. It is used for bulk data transfer; it is one of the primary ways by which data can transferred into the R/3 System. This method is not for near real-time data transfers.

There are various typical uses of batch input. One of the ways includes the one-time import of data. This import of data is from a legacy system into a newly installed R/3 System. In addition to it, another typical use is for periodic (i.e. hourly, daily..., and so on) transfers of data. These transfers are from external systems or legacy systems which are still in use into R/3 system where all enterprise data is consolidated.

The R/3 applications deliver different programs for batch input, which are ready to be used. However, in some cases a customer has to write his or her own batch input program. This is required in order to convert the concerned data from a legacy System or from a proprietary format into an R/3 data format.

regards,

keerthi

Re: BDC

Former Member — Wed, 28 Mar 2007 06:33:14 GMT

Dear Arun

Thanks for the answer it was exactly what i ws looking for can you put some more light onthsi please.

Query:

1) One set of data means? suppose i have a flat file with 1lakhs records i gave the path and it starts to update both CALL TRANS AND SESHEN . But what is one set of DATA? will we hav to take flat files dynamcally

thansk a lot

Re: BDC

Former Member — Wed, 28 Mar 2007 06:37:30 GMT

Hi Mohammed,

For such huge amount of data , it is better to go for the Bapi Method .

As asked by you , in Arun's post, the one set of data means that in Session method we can create a session for each set of data individually for the same program and release them at a later time.

For more info check my post which I have posted or revert back.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: BDC

Former Member — Wed, 28 Mar 2007 06:39:47 GMT

Hi ,

What i ment by one set of data is all the data you need to execute the transaction once.

Consider this scenario you want to upload 10 materials into your system using BDC , if you use call transaction you will have to call the transaction 10 times , once for each material , but in case of Session all this is done at one go , tough internally when you execute the session , the process might be the same , but for you as a user the process is done only once.

One more advantage of using the session mehod is in case there is some sort of system error when you execute the session you also have the option to execute it again , but in case of call transaction , you will have to execute the entire program.

Regadrs

Arun

Please assign points if reply is useful

Re: BDC

Former Member — Wed, 28 Mar 2007 06:49:21 GMT

Dar Kiran

Can you put som more light on thsi satements

System à Services à Batch input. Moreover, you can have the session run in the background processing.

Batch input method is a type of data transfer method. It is used for bulk data transfer; it is one of the primary ways by which data can transferred into the R/3 System. This method is not for near real-time data transfers.

There are various typical uses of batch input. One of the ways includes the one-time import of data. This import of data is from a legacy system into a newly installed R/3 System. In addition to it, another typical use is for periodic (i.e. hourly, daily..., and so on) transfers of data. These transfers are from external systems or legacy systems which are still in use into R/3 system where all enterprise data is consolidated.

Query :
1) so we dont use

Batch input

methord in real time ? if so what is the other one used?

2) If i have to run BDC every day night 1am

to upload a file from my desk top then? what is to process...... SHOULD I CREATE FLAT FILE WITH SAME DLETING TH OLD FILE EVERY DAY?