Implementation of Data Classes and Relocating table to a Different Data Class
Implement New Data Classes in the technical Settings & Change the Data Class of a SAP Table
1. Create a new memory area in the Database
First create a new memory area, for example, a tablespace, in the database. This tablespace must be made known the R/3 System by entering it in the following table TSORA
a. Go to Table TSORA and create a new entry.
b. Insert the New Tablespaces (Data and Index) Tablespace , In this case PSAPBTABD & PSAPBTABI and save the entry.
2. Define a New Data Class
You must now define a data class for the memory area maintained under Section 1. Data classes are used to group together tables whose contents have matching logical attributes.
a. Go to Table DDART and create a new entry for Data Class.
b. This is required to create a new Data Class. Make the following entries, in this example
|
TABART |
Enter the Data Class Name |
|
DDCLASS |
SYS: System Data Class USR: User-defined Data Class CPT: Pool/Cluster data Class STD: Standard Data Class INT: Data Class used internally |
|
DARTEXT |
Short Description |
For this scenario USR was user as a parameter for DDCLASS
3. Define the Link between the Data Class and Memory Area
After the new data classes and the memory areas have been made known to the R/3 System, the link between these sizes must now be defined. You do this with entries in the following tables, TAORA and IAORA.
a. Make the following entries in TAORA Table, for example refer the table below
|
TABART |
Enter the Data Class Name |
|
TABSPACE |
Name of the Data Tablespace Ex: PSAPBTABD |
|
PCTINC |
0000 (SAP Recommended) |
|
OFREELIST |
001 (SAP Recommended) |
|
OFREEGROUP |
01 (SAP Recommended) |
|
OPCTFREE |
10 (SAP Recommended) |
|
OPCTUSED |
40 (SAP Recommended) |
b. The next step is to make entries in IAORA table.
|
TABART |
Enter the Data Class Name |
|
TABSPACE |
Name of the Index Tablespace Ex: PSAPBTABI |
|
PCTINC |
0000 (SAP Recommended) |
|
OFREELIST |
001 (SAP Recommended) |
|
OPCTFREE |
10 (SAP Recommended) |
4. Relocation of SAP Table
To change the Data Classes of the SAP Tables, the following steps have to be followed.
1. Go to the Table for which the Data Class needs to be changed.
2. Change the Data Class by navigating to SE12 –> Technical Settings , Save & activate.
This completes the Relocation of the SAP Table. Repeat the same process for all the SAP Tables which need to be changed.
Will it work for every DB or only for Oracle DB?
Thanks,
Peter
Peter