Database Tables in DDIC

 In SAP ABAP, Database Tables are a fundamental component for storing and organizing data in a structured manner. These tables are defined in the ABAP Data Dictionary (DDIC) using transaction code SE11. The DDIC is a central repository for all data definitions in SAP ABAP, including Database Tables.

Each Database Table is defined with a name, description, and fields that determine the table's structure. The fields are defined with a data type, length, and other properties that specify how the data is stored. Data Types can be elementary, like numbers and characters, or structured, like Structures and Table Types.

Database Tables are classified based on their usage. The classifications include transparent, pooled, and clustered tables. Transparent tables are used to store application data, while pooled and clustered tables are used to store system data and can only be accessed by SAP System Programs.

To maintain data integrity, Database Tables can have various constraints, such as Primary Keys, Foreign Keys, and Check Constraints. Primary Keys are used to uniquely identify rows in a table, while Foreign Keys define relationships between tables. Check Constraints are used to validate data stored in a table.

Database Tables can be accessed and modified using SQL statements or ABAP programming. They are used in various SAP application components, such as SAP ERP, SAP CRM, and SAP BW, and play a critical role in the functioning of the SAP system.

Creation of Database Table - 

1. Open the ABAP Development Workbench using the transaction code SE80.
2. Navigate to the ABAP Dictionary by selecting Tools → ABAP Dictionary or using the transaction code SE11.
3. In the ABAP Dictionary screen, select "Database table" and click on the "Create" button.
4. Enter a unique name for the table and select the "Delivery and maintenance" tab. Ensure that "Display/Maintenance Allowed" is selected and save the table.
5. Define the fields of the table by clicking on the "Fields" tab and adding the required fields along with their data types, lengths, and attributes.
6. Specify the Key Fields of the table by selecting the "Key" checkbox next to the fields.
7. Add any additional properties for the table, such as Texts and Documentation.
8. Once all the fields and properties are defined, save the table.
9. Activate the table by selecting "Utilities" from the menu and clicking on the "Activate" option.
10. Following these steps will create and activate a Database Table in SAP ABAP. The table can then be accessed and utilized by various SAP programs and applications.

 Refer to the below video for the complete steps for table creation and activation 

In Conclusion , Database Tables in ABAP are an essential component for storing and organizing data. They are defined in the ABAP Data Dictionary, and fields are defined with a data type, length, and other properties. Database Tables can be classified as transparent, pooled, or clustered and have various constraints to maintain data integrity. They are accessed and modified using SQL statements or ABAP programming and are used in various SAP application components.