Use
You can link a variant table to a database table. The link between a variant table and a database provides new capabilities for accessing and processing data. System performance is improved considerably, especially when accessing individual points in large tables (for example, a dependency selects a specific table entry).
You can also buffer a database table, which can improve system performance even more.
Prerequisites
To link a variant table to a database table, you need authorization C_LOVC_DBI in your user master record. This authorization can be restricted to tables within a certain name range.
Features
You have the following options:
2. Copy an existing variant table to a database table and link the variant table to the database table.
If you create a database table:
This means that changes in the test client, for example, do not affect the live client.
When defining database tables, make sure that each characteristic matches the database table field to which you assign it.
You create the link when maintaining the table structure.
The database table fields must be assigned to the characteristics of the table.
See also:
SAP Library BC – ABAP Dictionary,
Creating Tables