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
- 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
- Buffering not permitted
- Buffering permitted but not activated
- Buffering activated ( in this option we need to specify the buffering type)
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.
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.
- 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