Data class in technical attributes

[Former Member]

Dear Experts,

I have a z table which has the data class defined as "Organization and customizing" but its having Transaction data and updated frequently. The table has about 10,000,000 records. If the table data class is now changed from APPL2 to APPL1 what would be the impact? can there be possible side effects when such table change setting in transported to live production system? The underlying database is Oracle.

Would like know the feedback of others on this particular scenario.

Thanks.

[Former Member]

Hi Srinivas,

The Data Class corresponds to the Tablespace in which the table is logically stored.  There should be no side effects. The data would be secured.

Regards

Vivek

[Former Member]

Hi Srinivas,

Table Space are created as per the APPL1 or APPL2 inside DB. so based on the data class it will just allocate memory by size. so u can change it ..no need to worry about side effects.

Regards,

GSANA

[RaymondGiuseppi]

First If your database is neither Oracle nor Informix, no problem. Else check if the two data class actually use different table spaces (eg. browse TAORA for Oracle) if no, no problem, if yes check via DB02 if the new data space has enough free space allocated to contain the database table and its indexes with its 10.000.000 records.

Regards,

Raymond

[harkesh_deshwal]

Data Class tell the system where the table will store in database.

[Former Member]

Hello,

If you choose the data class correctly, your table is automatically assigned to the correct area (table space or DB space) 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.

  APPL0 (master data):

Data that is seldom 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 seldom changed. An example is the table with country codes.

So when you change the data class of the table, whole table and its data will be shifted to the corresponding area.

During the transfer, clients wont have access to it.

Thank You.