tables

[Former Member]

when we r creating tables if we go to techinical settings there we will give data class as appl0 why we have use this option.plz explain me

[Former Member]

Data Classs:

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

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.

[Former Member]

Hi,

refer this link,

http://help.sap.com/saphelp_47x200/helpdata/EN/cf/21ea0b446011d189700000e8322d00/frameset.htm

Reward points if useful..

Regards

Nilesh

[Former Member]

APPL0 is for master data

Master data is data which is frequently read, but rarely updated.

[Former Member]

Hi,

Data Class

If you choose the data class correctly, your table is automatically assigned to the correct area (tablespace or DBspace) of the database when it is created. Each data class corresponds to a physical area in which all the tables assigned to this data class are stored. There are the following data classes:

APPL0 (master data): Data which is seldomly changed. An example of master data is the data contained in an address file, such as the name, address and telephone number.

APPL1 (transaction data): Data that is frequently changed. An example of transaction data is the goods in a warehouse, which change after each purchase order.

APPL2 (organizational data): Customizing data that is defined when the system is installed and seldomly changed. An example is the table with country codes.

pls go through this link also

http://help.sap.com/saphelp_nw04/helpdata/en/0d/ed6258a0364845829ff51ee22fb4ae/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eac5446011d189700000e8322d00/frameset.htm

pls reward if it helpful

Thnaks

Vana

[Former Member]

Hi Naga,

You would select this class if you are creating a database to store Master Data i.e. Data which is seldomly changed. An example of master data is the data contained in an address file, such as the name, address and telephone number.

When you choose this class your table is automatically assigned to the correct area (tablespace or DBspace) of the database when it is created.

Hope this helps.

Regards,

Philip Johannesen

[Former Member]

Hi mrudula,

Do post ur requirements in one post.

APP0 is for master data.

Regards,

Pavan

[Former Member]

Check this link ...standard SAP help..will surely clear your doubts.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eab8446011d189700000e8322d00/frameset.htm

Regards,

Jayant.

Award Points to all helpful answers