SAP IDT - Qualifiers & Owners

In Data Foundation, you can also change qualifiers and owners name of standard tables. To change the name, go to Data Foundation editor by clicking on .dfx file in Local Project View.

Right-click on the table header in Data Foundation editor → Change Qualifier and Owners.

 In the "Change Qualifier/Owner" dialog box, click the browse button in the Qualifier field and select a new qualifier. If the qualifier name is delimited by default, the Delimit option is selected. To override the default delimitation, select or unselect Delimit.

In the "Change Qualifier/Owner" dialog box, click the browse button in the Qualifier field and select a new qualifier. If the qualifier name is delimited by default, the Delimit option is selected. To override the default delimitation, select or unselect Delimit.

Defining Table Keys

There are two types of keys in a table in Data Foundation layer −

Primary Key − Unique and only one primary key in a table.

Foreign Key − It is used to match a unique value in other table.

To define a key, go to Data Foundation Editor. Select Table → Click Detect → Detect Key.

You can also define a column as primary key or foreign key by selecting the particular column in a table → Right-click → Set as Key → Primary/Foreign Key.