size categories and data classes

[Former Member]

Hi

How Many types of size categories and data classes are there

[Former Member]

Hi

How Many types of size categories and data classes are there

[Former Member]

Hi,

Find the below list of Data Classes available.

Data Classes: Is a physical memory of database where in your actual table will stored.

APPL0 Master data, transparent tables

APPL1 Transaction data, transparent tables

APPL2 Organization and customizing

USER Customer data class

USER1 Customer data class

USER6 Customer data class, generated by SAPDBA

USER7 Customer data class, generated by SAPDBA

Size Category: This determines the probable space requirement for a table

0 0 to 640

1 640 to 2,500

2 2,500 to 10,000

3 10,000 to 41,000

4 41,000 to 160,000

5 160,000 to 330,000

6 330,000 to 660,000

7 660,000 to 1,300,000

8 1,300,000 to 2,600,000

9 2,600,000 to 100,000,000

Regards

Chowdary

[Former Member]

The Data class determines in which table space the table is stored when it is created in the database.

The Size (0-4)category describes the probable space requirement of the table in the database.

Data classes :

APPL0- Master data (data frequently accessed but rarely updated).

· APPL1- Transaction data (data that is changed frequently).

· APPL2- Organizational data (customizing data that is entered when system is configured and then rarely changed).

The other two types are:

· USR

· USR1 – Intended for customer’s own developments

Regards

[Former Member]

Hi

There are five size categories (0-4) and 11 data classes, only three of

which are appropriate for application tables:

- APPL0 - Master data (data frequently accessed but rarely updated)

- APPL1 - Transaction data (data that is changed frequently)

- APPL2 - Organizational data (customizing data that is entered when system is Configured and then rarely changed)

The other two types are:

- USR

- USR1 - Intended for customers own developments

[former_member726634]

The answer is copied from the following website(link provide below).

https://www.iteanz.com/sap-abap-data-dictionary-interview-questions/

[Former Member]

<b>DATA CLASS</b>

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.

<b>SIZE CATEGORY</b>

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,

srinivas

<b>*reward for useful answers*</b>