Table Buffering in SAP

SAP stores the content in tables (Every data except start and stop logs is stored in DATABASE, no prog/ no data is available in the file system)

There are four types of Buffering
1. FULL Buffering
2. Generic Buffering
3. Single Record Buffering
4. No Buffering

This is maintained for each table SE13 refer USR02 Table.
1. Full Buffering: The tables which are frequently used and rarely modified are eligible for buffering. (Also which are small in size)
Eg: T000 have all the clients and required to create a client copy. (This is fully buffered)

2. Generic Buffering: Tables which are relatively large, frequently used, rarely modified using a set of keys (Fields)
Eg: USR02; T001 Company info

3. Single Record Buffering: The tables which are large in size, frequently used and rarely modified are buffered using a primary key.

4. No Buffering: The tables which are large frequently used, and frequently modified are not eligible for buffering.. VBAK (SALES), EKKO (PURCHASE)

If you like this post, you may as well like these too:

1. Purpose of Table Buffering Table buffering is used to increase performance when reading data from database table. Data from a buffered table is read from a local buffer on the application server thus reducing...
2. ABAP Programs: Filling an internal table from a database table REPORT ZSOURCE1203.* Work area for a database tableTABLES CUSTOMERS.* Defining an internal table with header lineDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE.* Filling the internal table (previous content...
3. Add Fields to SAP Table An Append Structure or a customizing include can be used to add fields to the Table. Append structures are created by adding fields to the end of a table while...
4. Creating a table in SAP ABAP Here are the steps required to create a table in SAP ABAP. Step 1: Go to transaction SE11 and input a table name. Step 2: In the Dictionary menu:Select the...