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 are the key activities that you perform as part of sap basis support?

584


I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.

1667


What are common transport errors and their codes?

1460


What is sap single stack system?

658


What is upgrade process? And how u will do that?

1253






How to do transport at OS level?

1402


hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me

6075


How to add authorizations, how you will maintain profiles?

1562


Is it possible to install sap patches when other users are online?

578


Explain what is the use of reference and service user in sap?

609


Where do you check transport request logs?

657


If a background job runs more than the time it should be completed normally then what actions will u take?

1349


what are the current support stack levels at market place?

1806


Difference between system refresh and client copy?

2331


Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com

1004