You are currently viewing Tables in SAP-ABAP

The table is a data structure that is used to store information or data in the form of rows and columns.  We can store N no. of records in a database table. Before we start discussing steps of the creation of a table in SAP System, we should have knowledge of various table fields.

Types of Table Fields:-

Field: – This defines the field name or column name of table.

Key Flag: – This defines whether the field is a key field or not when it has been checked it acts as key field and when it is unchecked it acts as normal field.

Data Element: – Data Element defines the type of field or column with a field label.

Data Type: – Data Type defines the data type of field i.e. it is of character type or numeric type.

Length: – Define the length of a field i.e. how many characters can be store in a field.

Decimal: – Defines the no. of digits permissible after decimal point in a number. It is used only in numeric data types.

Short Description: – Gives a small information about table field.

You can create table in SAP system by using T-Code: – SE11.

Steps to create a Table in SAP System: –

Step 1:- Open t-code SE11 as shown in below figure.

 

Step 2: – Select the option Database Table and type the table name in textbox and then click on create button.

Step 3: – Now, Choose the Delivery Class by on placing cursor in textbox as shown in Red box in fig. and then click on small white box icon in below fig.

 

Step 4: – Now, Choose the Delivery Class from the popup and then Press Enter Key.

Step 5: – Now, choose Display and Maintenance type allowed or not after table creation.

 

Step 6: – Open the Fields Tab and then add your fields with data element according to your requirement.

Step 7: – Open Currency/Quantity Fields tab and give reference table and reference field if required.

Step 8: – Now open the technical settings and then choose data class.

 

Step 9: – Choose Size Category i.e. expected no. of data records.

Now go back and then press Ctrl + S key to save and press Ctrl + F3 key to activate the table. Hence, your database table has been created.

 

Dinesh Kumar Bansal

Dinesh Kumar Bansal is an Indian Software Developer, who is working on ASP.Net, MS-SQL, SAP-ABAP technologies from last one year. His Basic Principle of developing software is, “You have to clear about, what do you want to do, how can it be done”. He always says that development can be done with a cool & fresh mind.

Leave a Reply