Technical Settings of a Database Table in SAP ABAP
Technical Settings of a Database Table in SAP ABAP
When you are creating a Database table in the SAP ,you must be maintain the technical settings of a table to define how the table is handled. The main technical settings of table are defining the Data Clas ,Size category ,buffering type and Logging.
As a ABAP consultant while you are facing the interview ,interviewer will expect these basic questions to test your basic knowledge on Data Dictionary Table ,most of the times ,myself ,faced questions on table technical settings ,so keeping it on my mind ,i am sharing this post for freshers and experienced.
Different Table Technical Settings in SAP
Data Class
Data Class is Physical Space in the Data Base, when you are creating the table ,If you choose the one of the data classes correctly , table is automatically assigned to that chosen Data class (table space or DB space) in the database . Each data class has its own physical area in SAP Database.
Different types of data classes
APPL0 (master data):
Data that is seldom changed: master data.
APPL1 (transaction data):
Data that is frequently changed: transaction data.
APPL2 (organizational data):
Customizing data : table with country codes.
Two further data classes, USR and USR1, are provided for the customer. These are for user developments.
Size Category
You use the size category to define the expected space(Memory size) required for the table in the database. You can choose a size category from 0 to 4 for your table.
When you create a table, the system creates initial space in the database. If you required more space due to data entries, additional memory is added depending on the selected size category.
Buffering Permission
Table Buffering is used to access the Data from Application Layer for fast access.
Buffering not allowed:
Application programs always need the most recent data from the table or the table is changed too frequently.
Buffering allowed but switched off:
Buffering is allowed from the business and technical points of view. Applications which access the table work correctly with and without table buffering.
Buffering switched on:The table is buffered. In this case you must specify a buffering type.
Buffering Types
The buffering type defines which table records are loaded into the buffer of the application server when a table record is accessed. The following buffering types exist:
Full buffering:
The system loads all the records of the table into the buffer when one record of the table is accessed.
Generic buffering:
When a record of the table is accessed, all the records having this record in the generic key fields
Single-record buffering:
Only the records of a table that are really accessed are loaded into the buffer.
Comments
Post a Comment