Ads

What is Database Table in SAP ABAP

What is Database Table in SAP ABAP


Table is a most important Object in SAP,whether you are Functional or Technical ABAP Consultant ,first basic thing is ,you must have deep knowledge on Database Table and its structure and Table technical Settings.We are creating Database Table in SE11(Data Dictionary)

You can define Tables independently of the database in the ABAP Dictionary. The fields of the table are defined with their data types and lengths(Domain) and Description(Data Element).


When you activate the table, the system automatically generates a physical table definition in the database for the table definition stored in the ABAP Dictionary. The system translates the table definition from the ABAP Dictionary to a definition of the particular database. 

What is Database Table in SAP ABAP



Table Components

Domain is a Data Type and Length of  Table Field.

Data Element is a combination of Domain + Table Field Description.

Table Fields:
Table fields define the field names and data types of the fields contained in the table

Foreign keys define the relationships between the table and other tables.

Technical settings control the creation of the table in the database.

To speed up data selection, secondary indexes can be created for the table.

Possible Changes in Data Base Table

To do the changes in a table, choose an appropriate procedure from the list below:
Adding an Append Structure 
• Changing the Data Type, Field Length and Decimal Places of Existing Fields 
• Changing the Table Category 
• Moving Fields 
• Copy Fields from Another Table 
• Deleting Tables 
• Inserting an Include 
• Inserting New Fields 
• Deleting Existing Fields 

Database Table in SAP ABAP, Database Table,SAP Table,SAP Database Table,Database Table.

Comments

Popular posts from this blog

BADI Interview Questions in SAP ABAP

Sample SAP ABAP Programming Examples for Practice

Module Pool Programming Interview Questions and Answers in SAP ABAP

Step by Step tutorial on BDC Session Method Program in SAP ABAP

SAP ABAP Interview Questions and Answers for 10 Years Experienced