11-29-2007 9:29 AM
11-29-2007 9:33 AM
<b>The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged.</b>
The most important parameters are:
<b>Data class:</b> The data class defines the physical area of the database (tablespace) in which the table should be created.
<b>Size category:</b> The size category defines the size of the extents created for the table.
When the table is created in the database, the required information about the memory area to be selected and the extent size is determined from the technical settings.
<b>Buffering permission:</b> The buffering permission defines whether the table may be buffered.
<b>Buffering type:</b> If the table may be buffered, you must define a buffering type (full, single-record, generic). The buffering type defines how many table records are loaded into the buffer when a table entry is accessed.
<b>Logging:</b> This parameter defines whether changes to the table entries should be logged. If logging is switched on, each change to a table record is recorded in a log table.
The Convert to transparent table flag ( transparent flag) is also displayed for pooled tables or for tables which were converted into transparent tables earlier on with this flag.
11-29-2007 9:33 AM
Hi,
Technical Settings: The technical settings control, for example, table buffering.
Select Data Class (Mandatory) [APPL0]
Select Size Category (Table size - No. of records - Mandatory) [1 to 6]
Specify Buffering [allowed / not allowed]
Save
Check Inconsistencies
Activate & Go Back to Maintain Table Screen
Data Class: The data class defines the physical area of the database (for ORACLE
the TABLESPACE) in which your table is logically stored. If you choose a data
class correctly, your table will automatically be assigned to the correct area
when it is created on the database.
The most important data classes
are (other than the system data):
APPL0 Master data
APPL1 Transaction data
APPL2 Organizational and customizing data
Size category: The size category determines the probable space requirement for a table in the database.
Buffering: The buffering status specifies whether or not a table may be buffered.
Regards
Nicole
11-29-2007 9:34 AM
11-29-2007 9:34 AM
Technical Settings
The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged.
The most important parameters are:
Data class: The data class defines the physical area of the database (tablespace) in which the table should be created.
Size category: The size category defines the size of the extents created for the table.
When the table is created in the database, the required information about the memory area to be selected and the extent size is determined from the technical settings.
Buffering permission: The buffering permission defines whether the table may be buffered.
Buffering type: If the table may be buffered, you must define a buffering type (full, single-record, generic). The buffering type defines how many table records are loaded into the buffer when a table entry is accessed.
Logging: This parameter defines whether changes to the table entries should be logged. If logging is switched on, each change to a table record is recorded in a log table.
The Convert to transparent table flag ( transparent flag) is also displayed for pooled tables or for tables which were converted into transparent tables earlier on with this flag.
See also:
Maintaining Technical Settings
Buffering Database Tables
Maintaining Technical Settings
Procedure
In the field maintenance screen of the table, choose Technical settings.
The maintenance screen of the technical settings appears.
Select the data class and size category of the table.
The input help for the Size category field shows how many data records correspond to the individual categories.
The buffering permission defines whether the table may be buffered.
If you permitted table buffering, define the buffering type of the table.
You can find further information about when to buffer tables and what buffering type you should choose in Buffering Database Tables.
Select Log data changes if you want to log changes to data records of the table (see Logging).
To log changes, system logging must be switched on with the profile parameter rec/client. The Log data changes flag on its own does not cause the table changes to be logged!
Choose .
Errors that occurred during activation are displayed in the activation log.
Other Options
The Convert to transparent table flag is displayed for pooled tables (and tables that were converted to a transparent table with this flag at an earlier time). You can convert the pooled table to a transparent table with this flag (see Converting Pooled Tables to Transparent Tables).
Constraints
If the key length of the table is larger than 64, the table cannot be buffered generically.
If the key length of the table is larger than 120, the table cannot be buffered.
If the key of the table has more than 86 places or the data part of the table has more than 500 places, it is not possible to log the table.
See also:
Technical Settings
Which Tables Should be Buffered?
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eba2446011d189700000e8322d00/frameset.htm
11-29-2007 9:39 AM
In technical settings we can specify the data class , size category, buffering is needed or not etc.
data class :
In data class we can give the type of the table we are creating(for eg; master table, transaction table, organization table etc.
size category:
shows how many data records correspond to the individual categories
Go through this link:
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eba2446011d189700000e8322d00/content.htm
Reward me plz
Shyja
11-29-2007 9:40 AM
hi srinath,
The technical settings are used to individually optimize the storage requirements and accessing behavior of database tables.
The technical settings can be used to define how the table should be handled when it is created on the database, whether the table should be buffered, and whether changes to entries should be logged.
The table is automatically created on the database when it is activated in the ABAP Dictionary. The storage area to be selected (tablespace) and space allocation settings are determined from the settings for the data class and size category.
The settings for buffering define whether and how the table should be buffered.
If u still much more details, revert back to me.
Regards,
Prashant