Database Table
Tables are defined in Data dictionary and their Physical storage is in Database.
Types of SAP Tables:
Transparent Table:
Transparent tables directly mirror their structure in the underlying database. They store application data and are often used for master data or transactional records. Changes to transparent tables directly affect the database schema.
Pool Table:
Pool tables are logical tables that group together transparent tables with similar characteristics or usage. They provide a higher level of abstraction, simplifying data management for related entities.
Cluster Table:
Cluster tables store data from multiple transparent tables with identical key fields. This clustering helps optimize data storage and retrieval operations, particularly for related data sets frequently accessed together.
Data Dictionary and Database: Tables in SAP are defined within the Data Dictionary (DDIC), which serves as a centralized repository for metadata and data definitions. While the DDIC defines the structure and properties of tables, the actual storage and manipulation of table data occur in the underlying database.
Table creation:
Step 1: Enter transaction code “SE11” in the SAP command field and press enter to continue.
Step 2: On the initial screen, select the database table option and enter the name of the database table that you want to be created. After updating name click on create button. Here we are creating ZTEST_EMP table.
Database Table: ZTEST_EMP
Step 3: On the next screen, update the following data. By default delivery and maintenance tab is selected.
1. Short Description: Update the short description of the database table.
2. Delivery Class: Update the delivery class from the list, you can get the list be clicking the search option (F4).
3. Data Browser/ Table View Maintain: Select the display/maintenance allowed from the drop down list.
Step 4: Select field tab and update the following data.
Field: Update the field name in the field column (16 characters)
Key: Select the key option if you want the field as table key.
Data Element: Update the data element key from the list.
Comentarios