how can we create a particular tables buffer which are
mostly used/ And where we can see them ?

Answer Posted / inder09

The table buffer is located between the application and the
database. Its goal is to cache portions of a database table
in the application server to reduce database load and
network communication.

ST10 will help you to identify buffering problems.
or use SE13 to display the buffer settings for several tables.

We can activate buffering for a table in the ABAP Dictionary
using Technical settings in transaction SE11 or SE13, you
can choose between different settings like Fully buffered,
Generic area buffered, and single record buffered.

Table buffer advantages:
Makes data access many time faster
Reduces the load on the database
Reduces the load on the network and on CPU
The work process is freed more quickly for other work

Table buffer disadvantages:
If an SAP system consists of more than one SAP instance,
then buffering might be dangerous.

Invalidation of buffered data - If data stored in a buffer
is outdated compared to data on the database, then this data
is no longer available for access and will be overwritten.

By setting the system parameter rdisp/bufrefmode to the
value sendon, exeauto you can ensure the following mechanism
and is strongly recommended by SAP:

The sendon switch for the parameter rdisp/bufrefmode will
force the SAP system to log each change to buffered data in
the table DDLOG on the database. By setting the exeauto
switch for the same parameter, you can force all SAP
instance to periodically check the validity of their locally
buffered data against table DDLOG

Hope answered all u r queries with regard to table buffer

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sox and sod in sap ?

1503


Can you change the profile parameter in the os level? Which one is advisable why?

1006


How to assign a mass Tables in Auth Group by using T-code:se54

1962


How should I set priority for Printing say like user, teamlead, project manager?

797


How do you create an instance?

822


What is process for applying patches?

878


What is MySAP?

865


What is rfc connection?

827


If possible send me screenshot doc for installation of ecc6

1477


How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

988


In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?

3589


what is the difference b/w 4.6c & 4.7EE?

2021


Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate

1839


How you will rate yourself in SAP, Oracle from a scale 1 - 10?

2138


What are the types of transport queries?

817