Table Maintenance in SAP – A Step by Step Guide

1. Step 1: Create & Maintain Table (SE11)
2. Screen 101: ABAP Dictionary: Initial Screen

Screen 102: Maintain Table -> Delivery and Maintenance

Screen 103: Maintain Table -> Fields

1. [] SE11: Enter Table Name -> Create
2. Enter Table Description (Mandatory Field)
3. Select Delivery Class
4. Set maintenance level
5. Enter Fields, Assign Data Elements
6. Save Entries
7. Check Inconsistencies
8. Activate Table
9. Go To Technical Settings (SCREEN 104)

Delivery Class: The delivery class controls the transport of table data wheninstalling or upgrading, in a client copy and when transporting between customersystems. The delivery class is also used in the extended tablemaintenance.

There are the following delivery classes:

A: Application table (master and transaction data).

C: Customer table, data is maintained by the customer only.

L: Table for storing temporary data.

G: Customer table. The customer namespace must be defined in table TRESC. (UseReport RDDKOR54 here).

E: System table with its own namespaces for customer entries.

S: System table, data changes have the same status as program changes.

W: System table (e.g. table of the development environment) whosedata is transported with its own transport objects (e.g. R3TR PROG, R3TR TABL,etc.).

Data Browser/Table View Maint.: This indicator specifies whether it is possible to display/maintain a table or view using the maintenance tools Data Browser (transaction SE16) and table view maintenance (transactionsSM30 and SM31).

MANDT field is mandatory for Client dependant tables

Technical Settings: The technical settings control, for example, table buffering.

Indexes: To speed up data selection, you can create secondary indexes for the table

Append Structure: Append structures are used for enhancements that are not included in the standard.

Screen 104: Maintain Technical Settings

1. Select Data Class (Mandatory) [APPL0]
2. Select Size Category (Table size - No. of records - Mandatory) [1 to 6]
3. Specify Buffering [allowed / not allowed]
4. Save
5. Check Inconsistencies
6. Activate & Go Back to “Maintain Table Screen”

Data Class: The data class defines the physical area of the database (for ORACLEthe TABLESPACE) in which your table is logically stored. If you choose a dataclass correctly, your table will automatically be assigned to the correct areawhen 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

Size category: The size category determines the probable space requirement for a table in the database.

Buffering: The buffering status specifies whether or not a table may be buffered.Screen 105: Maintain Table

Screen 105: Maintain Table

Screen 106: Maintain Enhancement Category (ECC 6.0 onwards)

1. -> Extras -> Enhancement Category
2. Select Enhancement Category

Enhancement Category: Structures and tables that were defined by SAP in the ABAPDictionary can be enhanced subsequently by customers using Customizing includesor append structures. The enhancements do not only refer to structures/ tablesthemselves, but also to dependent structures that adopt the enhancement as aninclude or referenced structure. Append structures that only take effect at theend of the original structure can also cause shifts - in the case of dependentstructures - even within these structures.

Screen 107: Maintain Table -> Table Maintenance Generator

In this screen go to utilities menu and select Table Mai8ntenence generator

Screen 108: Generate Table Maintenance Dialog: Generation Environment

1. -> Utilities -> Table Maintenance Generator OR [] SE54
2. Specify Authorization Group [&NC&]
3. Select Maintenance type [One Step/Two Step]
4. Mention Screen Numbers [1/2]
5. Save & Go Back

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

Step 2: Generate Table Maintenance (SE54)

Screen 201: Generate Table Maintenance Dialog: Initial Table/View Screen

Screen 202: Generate Table Maintenance Dialog: Initial Table/View Screen

1. Enter Table/View name
2. -> Edit View Cluster
3. -> Create View

The Table Maintenance Generator: Used to a create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator.

Screen 203: Change View “Header Entry”: Details

Screen 204: Change View “Object Structure”: Overview

1. -> Header Entry -> Enter Short text -> Activate View
2. -> Object Structure -> Enter Table name & description
3. -> Field-dependence -> Generate -> Header entry -> Activate View

Step 3: Create & Maintain Transaction (SE93)
Screen 301: Maintain Transaction

Screen 302: Create Transaction

1. [] SE93 Enter Transaction name -> Create
2. Enter Short text
3. -> Transaction with parameters
   

Why Select “Transaction with parameters”? Parameter transactions allow youto pre-assign values to the fields on the initial screen.

If you supply all of the necessary entries for the initial screen in this way, you can suppressthe screen when the transaction is executed.

Screen 303: Create Parameter Transaction

1. Enter Transaction text
2. Enter default transaction [SM34]
3. -> Skip Initial Screen
4. Enter Names of Screen fields and values [VCLDIR-VCLNAME = SHOW = 'X']
   

And we are DONE! Maintain your Table/View
Screen 401: Change View “View description”: Overview

Screen 402: New Entries: Overview of Added Entries

1. -> New Entries
2. Go on adding new entries