Technical settings of ABAP table

The technical setting specifies how the table should handle by the SAP system. The main technical settings of a table are

  1. Data Class
  2. Size category
  3. Buffering Permissions
  4. Buffering Type
  5. Logging

Data class:

Data class specifies the physical area in RDBMS called tablepsace. The table will be created in that area. The following are the main data class options used.

APPL0: Master data which is rarely changes

APPL1: Transaction data which is frequently changed

APPL2: Organization data which is holding the customizing data and very rarely changes.

Apart from these USR and USR1 are other special data classes for user developments.

Size category:

Size category specifies the expected space required for the table. And the options available in size category are

  • 0
  • 1
  • 2
  • 3
  • 4

Each of this option will assign a certain fixed memory for that table.

Buffering Permissions:

There are 3 types of buffering permissions are there

  1. Buffering not permitted
  2. Buffering permitted but not activated
  3. Buffering activated ( in this option we need to specify the buffering type)

Buffering Type:

Following are the three buffering types used for tables

  1. Full buffering: All the records of accessed table will be buffered.
  2. Generic buffering: All other records which having the same generic fields of the accessed records will be buffered.
  3. Single record buffering: Only the accessed record will buffer in this case.

We can determine the buffering type based on the table size and the operations need to handle in our applications.

Logging:

This option specifies about the storage of log about the changes in table. The changes will be logged in a table DBTABPRT. There are 3 types of logging options for a table.

  1. rec/client = ALL  (Enable log for all clients)
  2. rec/client = 000[,…] ( Enable log for only specified clients)
  3. rec/client = OFF ( Turn off the logging)
Also Read : ABAP Tutorial Home page -> Data Elements and Domains -> How to create a Transparent table