Basics Of ABAP : Creating tables

Creation of actual table

Parameters to be passed for creation of table:

Short description: Mandatory field.

Delivery class: As per User Requirement

Table fields: Specify whether primary key. In this case it is mandatory to enter data element.

Data class: Establishes the physical area of the database.

Size category: Allows you to specify estimated space requirement for the table.

Further down under buffering square box, the system allows specifying whether table is going to be buffered. When a table is buffered, it is loaded into the table buffer from the application server memory and it will remain there until you switch off or reboot system.

If the table is to be buffered, you need to specify the type of buffering. Full is for entire table while partial is for only those records which are being accessed.

Once the table is created, it has to be generated or activated to be able to access by other objects like programs.

Here are the steps to create transparent tables.

1. Execute tcode se11, give a table name ztable1 and click CREATE.

2. Give the table a description And  Select Delivery Class To A (Application Table), Data Browser into Display/Maintenance Allowed.

3.  Click on the Fields tab and begin to create your field names here. If you’re creating a table that will be referenced to another table (A relational tables) you need to create data element using the same data type domain, this way you can link between these fields as the key. (Primary and foreign key), you can’t link between fields from two or more tables that don’t have the same domain.

4. Click on the technical settings tab, select APPL0 (master data, transparent table) for the data class, and 1 as the size category.

5. Click Extras > Enhancement Category and select the table can be enhanced.

6.  Save and activate.