Issues while creating customized table

Former Member — Tue, 23 Dec 2008 06:41:55 GMT

Can anyone please tell me what is Data Class and Buffering in technical setting of Table.

And which option i will prefer to give while creating a customized customer table. That table contains only one field and maximum records will not cross 100.

Thanks in advance

Md Azizur

Re: Issues while creating customized table

rajesh-2 — Wed, 24 Dec 2008 09:02:02 GMT

Use data class USR or USR1 for customized customer developments. Note that the data class only has an effect on table storage for the database systems ORACLE and INFORMIX.

If your table has mainly read access then use buffering and if your table has mainly write access then do not use buffering.

Regards,

Rajesh

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

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.

About Buffering:

The buffering status specifies whether or not a table may be buffered.

This depends on how the table is used, for example on the expected

volume of data in the table or on the type of access to a table. (mainly

read or mainly write access to the table. In the latter case, for

example, one would not select buffering).

You should therefore select

- Buffering not allowed if a table may not be buffered.

- Buffering allowed but not activated if buffering is

principally allowed for a table, but at the moment no buffering

should be active. The

buffering type specified in this case is only

a suggestion.

- Buffering allowed if the table should be buffered. In this

case a buffering type

must be specified.

topic Issues while creating customized table in Application Development and Automation Discussions

Issues while creating customized table

Re: Issues while creating customized table