A Data Foundation is build by creating it on a Local Project view. Right-click under Local Project → New → 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.
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.
Tables can be also inserted using Insert + option in Data Foundation tool bar. SAP IDT facilitates in inserting tables, joins, keys, derived tables, etc.
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.
By using the Detect option, Cardinality can be defined or can also open the Edit Join dialog box.
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.
Right-click on .dfx file and select Check Integrity to run an integrity check.
The Data Foundation is saved by clicking on the Save Icon.
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.
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.
To view the database tables referenced in connection, the connection can be expanded.
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.
In the next dialog box, edit table name, description and properties of column.
The table and the column properties will be updated by clicking OK.
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.
The data type of a column can be edited by clicking on the arrow mark in front of data type.
As required the data type for each column is selected and click OK.
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.