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.
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
Post a Comment