Skip to Content

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.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply