Technical Settings

[Former Member]

Hello all,

Are Technical settings mandatory while creating tables,if yes why?

Thanks in advance

SRiNi

[Former Member]

Hello,

Yes. They are Mandatory.

The required fiedls are the dataclass and size catagory:

Data class in technical settings

    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):

    o   APPL0    Master data

    o   APPL1    Transaction data

    o   APPL2    Organizational and customizing data

    Master data is data which is frequently read, but rarely updated.
    Transaction data is data which is frequently updated. Organizational und
    customizing data is data which is defined when the system is initialized
    and then rarely changed.
There are two more data classes available, USR and USR1. These are
reserved for user developments. The tables assigned to these data
classes are stored in a tablespace for user developments.

Note:The data class only has an effect on table storage for the database
systems ORACLE and INFORMIX.

 Size category

     The size category determines the probable space requirement for a table
     in the database.

     You can select the categories 0 to 4 for your table. Each category is
     assigned a specific fixed storage area value in the database. When you
     create a table, initial space is saved for it in the database. If more
     space is required later as a result of data that has been entered, the
     storage space is increased in accordance with the category selected.

     Press F4 on the field Size category to see the number of data records
     that can be maintained for the individual categories of your table
     without complications ensuing. These complications could be for example
     a reorganization becoming necessary because the maximum space to be
     reserved for the table was exceeded due to the maintained size category.

Regards,

Vasanth

[Former Member]

Technical setting are mandatory to creat a table,

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.