topic Re: Reading SAP buffer in Application Development and Automation Discussions

Reading SAP buffer

AntonPierhagen — Wed, 26 Jan 2011 12:49:23 GMT

hi all

I've got a question. During a transaction an function module is started which i had created.

The function module is started before the data is saved. So, before a commit.

I had heard that before the data is committed to the database, you can read all this data.

All the data which is in the transaction. And this data should be in the so called SAP BUFFER.

But, how do you read it? En does anyone has more information about that?

Kindly hear from you!

Anton Pierhagen

Re: Reading SAP buffer

Clemenss — Wed, 26 Jan 2011 13:46:11 GMT

Hi AntonPierhagen2,

this just means that within the current processing step, all database changes done using UPDATE/INSERT will be visible to a subsequent SELECT in this processing step. This is no real advantage as usually the program knows what database changes it does.

But all other programs/processes will see the database changes after they are committed to the database.

This is the basic concept of database consistency: If a Type E A or X Error occurs, all changes are rolled back.

Note: An implicit database commit occurs after every processing step. In online programs this means that as soon as the program waits for user input (screen processing), calls an RFC module or receives results from an RFC call or just after executing the last program statement the database commit is done - no rollback after this.

See documentation [SAP LUW|http://help.sap.com/abapdocu_702/en/abapcommit.htm] to shed some light on this.

Regards,

Clemens

Link Edited by: Clemens Li on Jan 26, 2011 2:59 PM

Re: Reading SAP buffer

AntonPierhagen — Wed, 26 Jan 2011 14:17:12 GMT

thanks!