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.
