The technical setting specifies how the table should handle by the SAP system. The main technical settings of a table are
- Data Class
- Size category
- Buffering Permissions
- Buffering Type
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 specifies the expected space required for the table. And the options available in size category are
Each of this option will assign a certain fixed memory for that table.
There are 3 types of buffering permissions are there
- Buffering not permitted
- Buffering permitted but not activated
- Buffering activated ( in this option we need to specify the buffering type)
Following are the three buffering types used for tables
- Full buffering: All the records of accessed table will be buffered.
- Generic buffering: All other records which having the same generic fields of the accessed records will be buffered.
- 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.
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.
- rec/client = ALL (Enable log for all clients)
- rec/client = 000[,…] ( Enable log for only specified clients)
- rec/client = OFF ( Turn off the logging)
Also Read : ABAP Tutorial Home page -> Data Elements and Domains -> How to create a Transparent table