Procedure documentation Linking a Variant Table to a Database Table Locate the document in its SAP Library structure

Use

You link a variant table to a database table by maintaining the basic data of the table structure.

Prerequisites

You have created a database table in the ABAP Dictionary.

To link a variant table to a database table, you need authorization C_LOVC_DBI in your user master record. This authorization must apply to the name range of the table.

Procedure

1. In the basic data of the table structure, enter the name of the database table.

You see the Link active indicator.

Note 

You can only select this indicator once you have assigned characteristics to the table.

3. Select the indicator.

4. Choose Goto ® Field Assignments, and assign the characteristics to the fields of the database table.

5. Save the table.

Note 

To log the user that changed the table and the date of the link to the database table, choose Extras ® Administrative data.

Result

You can use the table in dependencies. When the system accesses a table it goes directly to the database, so it can return a result more quickly.

If the database is new and does not contain any data yet, copy the contents of the variant table to the database table.

Leaving content frame