‎2007 Sep 03 7:18 AM
supose that I am uploading data from a flat file with 10 records and suppose if I get an error while uploading 5th record,then what willl happen and what we have to do in case of 'SESSION' as well as 'CALL TRANSACTION'.
‎2007 Sep 03 7:22 AM
Hi
it will generate a seesion log there you will find at which record the error was found
if you put commitwork at the end it will stop at that record and the total records will not be updated
if don't put commit work then it will up date up to 4th record
‎2007 Sep 03 7:23 AM
session stop the process.
call do success record.
SESSION METHOD
Data is not updated in database table unless Session is processed.
No sy-subrc is returned.
Error log is created for error records.
Updation in database table is always synchronous
CALL TRANSACTION
Immediate updation in database table.
Sy-subrc is returned.
Errors need to be handled explicitly
Updation in database table can be synchronous Or Asynchronous
Call transaction :
the transaction will be called immediatly when u run the report and the recording will be done once u execute the program...
Session method:
Session method will create a session ... U can schedule the session at any time so that it runs at the specified time..
Let us suppose that u need to enter some 1000 materials using MM01.. when u run this during normal working hours, it consumes time and server may lose its pace..
to avoid this , u can create a session for this data upload and schedule the session when users are less...say friday night..
hope this will be useful
‎2007 Sep 03 7:28 AM
Hi,
When you use CALL TRANSACTION, the data for the previous four records is already updated in the database.. if you have used it in E or A mode then the system will stop at the error screen.. but if you have used N mode, then it will skip the record and go ahead to the next record..
In this case, you will need to track the error record from the message table.. and later display a report or download the error records..
For SESSION method.. no record data will be updated in the database.. a log will be generated.. you can see that, correct the error record and re execute the session..
Thanks and Best Regards,
Vikas Bittera.