Tables
Tables
Table Fields
Reference Fields and Reference Tables
Includes
Named Includes
Foreign Keys
Generic and Constant Foreign Keys
Semantic Attributes of Foreign Keys
Cardinality
Type of Foreign Key Fields
Text Tables
Multi-Structured Foreign Keys
Technical Settings
Data Class
Size Category
Buffering Permission
Buffering Types
Full Buffering
Generic Buffering
Single-Record Buffering
Logging
Converting Pooled Tables to Transparent Tables
Buffering Database Tables
Local Buffer Synchronization
Example for Buffer Synchronization
Which Tables should be Buffered?
Which Accesses Proceed Directly to the Database?
How are Table Buffers Implemented Technically?
Single-Record Table Buffers
Generic and Full Table Buffers
How can you Analyze the Buffer Quality?
Indexes
What to Keep in Mind for Secondary Indexes
How to Check if an Index is Used
Unique Indexes
Index IDs
Extension Index
Append Structures
Customizing Includes
Creating Tables
Creating Foreign Keys
Maintaining Technical Settings
Creating Secondary Indexes
Delivery Class
Activation Type
Making Changes to Tables
Adding an Append Structure
Inserting an Include
Inserting New Fields
Initial Values
Deleting Existing Field
Changing Data Types and Lengths of Existing Fields
Changing the Table Category
Moving Fields
Copying Fields from Another Table
Copying Fields from an Entity Type
Deleting Tables