SAP IDT Building Data Foundation - SAP IDT

How to build a Data Foundation in SAP IDT?

A Data Foundation is build by creating it on a Local Project view. Right-click under Local Project → New → Data Foundation.

Build Data Foundation

Select either Single-source enabled or Multi-source enabled. Follow the wizard and select the connections.

Data Foundation is created as .dfx file and it starts the Data Foundation editor. Insert the tables and joins in Data Foundation editor.

How to insert Tables from the Connection in SAP IDT?

In connection pane, open and browse the tables in connection. The tables can be searched in the connection pane. Drag and drop the desired tables to add them to the Data Foundation master view.

Insert Tables Using Wizard

Tables can be also inserted using Insert + option in Data Foundation tool bar. SAP IDT facilitates in inserting tables, joins, keys, derived tables, etc.

Insert Tables

The insert option in the toolbar can be used to insert joins in Data Foundation or can be clicked on Edit Join such that a dialog box opens.

Double-click on Join to open edit Join dialog box. Detect option can be used to detect Join between columns.

Edit Join

By using the Detect option, Cardinality can be defined or can also open the Edit Join dialog box.

Detect Option

Open Edit Join

The derived tables, alias tables, parameters and prompts, LOVs can be added to be associated with prompts. Under aliases and contexts tab, click detect aliases and contexts to detect aliases and contexts automatically.

Aliases Context

Right-click on .dfx file and select Check Integrity to run an integrity check.

Check Integrity

The Data Foundation is saved by clicking on the Save Icon.

How to filter and insert Tables in SAP IDT?

A table in the connection can be filtered by selecting the connection for which filter is to be done and insert the tables. Click on the down arrow mark to select a table type. Select a particular table type by checking the option.

Select All/Unselect All option is used to select or unselect all the options in the dropdown.

Filter the Table

To insert the tables − Select Insert Tables from the Insert menu in the data foundation view. The "Insert Tables" dialog box lists the connections defined in the data foundation.

Insert Menu

To view the database tables referenced in connection, the connection can be expanded.

Expand the Connection

How to edit Table Properties in SAP IDT?

The table properties like name and description of a table can be edited in SAP IDT. The columns from the table display can be removed, the column data types can be edited and the primary keys can be changed.

Select the desired table to edit and right-click on the table header → Edit.

Editing Table Properties

In the next dialog box, edit table name, description and properties of column.

Edit Table

The table and the column properties will be updated by clicking OK.

How to change Data Types of a Column in SAP IDT?

The datatype of the columns in a table can be changed by selecting the desired table to be edited and right-click on the table header → Edit.

Change the Datatype

The data type of a column can be edited by clicking on the arrow mark in front of data type.

Edit the Datatype

As required the data type for each column is selected and click OK.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

SAP IDT Topics