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

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