BDC Update 'S'

[Former Member]

if i put update 'S' i. "N' mode in bdc does the transaction will take more time . is it a performance issue?

[Former Member]

if i put update 'S' i. "N' mode in bdc does the transaction will take more time . is it a performance issue?

[Former Member]

Hi,

<b>MODE</b>

The MODE addition determines the processing mode for batch input processing. As mode, you can specify a character-type data object. Its possible content and effect is displayed in the following table. Without use of one of the additions MODE or OPTIONS FROM, the effect is the same as if mode had the content "A".

mode Effect

"A" Processing with display of screens

"E" Display of screens only if an error occurs

"N" Processing without display of screens. If a breakpoint is reached in one of the called transactions, processing is terminated with sy-subrc same as 1001. The field sy-msgty contains "S", sy-msgid contains "00", sy-msgno contains "344", sy-msgv1 contains "SAPMSSY3", and sy-msgv2 contains "0131".

"P" Processing without display of the screens. If a breakpoint is reached in one of the called transactions, the system branches to the ABAP Debugger.

Others Like "A".

<b>UPDATE</b>

The UPDATE addition determines the processing mode for batch input processing. You can specify a character-type object for upd. Its possible content and its effect are displayed in the following table. Without use of one of the additions UPDATE or OPTIONS FROM, the effect is the same as if upd had the content "A".

update Effect

"A" Asynchronous update. Updates of called programs are executed in the same way as if in the COMMIT WORK statement the AND WAIT addition was not specified.

"S" Synchronous processing. Updates of the called programs are executed in the same way as if in the COMMIT WORK statement the AND WAIT addition had been specified.

"L" Local update. Updates of the called program are executed in such a way as if the SET UPDATE TASK LOCAL statement had been executed in it.

Other As for "A".

Regards

Gaurav

[Former Member]

Hi Shankar,

It depends on the number of records you are trying to upload, if the records are more it will take some time to finish the upload.

"N" Processing without display of screens.

"S" Synchronous processing. Updates of the called programs are executed in the same way as if in the COMMIT WORK statement the AND WAIT addition had been specified.

Regards

Gokul

[Former Member]

Yes, System will take more time For 'S' type Update.

because 'S' type waits untill updating the record and get respond from system.

For 'A' Type System will not wait for respons.

[Former Member]

Hi,

Yes, System will take more time For 'S' type Update.

So it is better to use 'A' update.

Here you are specifying update type by which database table is updated.

'S' is for Synchronous update in which if you change data of one table then all the related Tables gets updated. And sy-subrc is returned i.e., sy-subrc is returned for once and all.

'A' is for Asynchronous update. When you change data of one table, the sy-subrc is returned. And then updating of other affected tables takes place. So if system fails to update other tables, still sy-subrc returned is 0 (i.e., when first table gets updated).

Regards,

Sruthi

[anilnal]

Hi,

This depends on the type of data you are trying to post in the BDC.

S mode acts like a commit work and wait, while a A mode is just a commit work and each unit of work is independent of the previous record.

Ex. if you are trying to post inter-connected records - like a transaction which posts another record, comes back and saves/posts, it is always good to use mode S.

If you are posting multiple individual records it is preferable to use Asynchronous mode A. (saves time taken to commit the work)

Regards,

Anil.