![SAP IDT Tutorial](/sap_idt/images/sap-idt-mini-logo.jpg)
- SAP IDT Tutorial
- SAP IDT – Home
- SAP IDT – Overview & User Interface
- SAP IDT – Resources
- SAP IDT – Creating Universe
- SAP IDT – .unv Universe Introduction
- Dealing With Published Universes
- SAP IDT – Projects
- SAP IDT – Managing Connections
- Managing Resources In Repository
- SAP IDT – Data Foundation Layer
- SAP IDT – Building Data Foundation
- SAP IDT – Qualifiers & Owners
- SAP IDT – Joins In Data Foundation
- SAP IDT – Business Layer
- SAP IDT – Business Layer Properties
- SAP IDT – Folders In Business Layer
- SAP IDT – Business Layer View
- Building Query In Query Panel
- Dependency Among Resources
- SAP IDT – Publishing
- SAP IDT – Security
- Running Query Published Universe
- SAP IDT – Format Editor Overview
- SAP IDT Useful Resources
- SAP IDT - Questions Answers
- SAP IDT - Quick Guide
- SAP IDT - Useful Resources
- SAP IDT - Discussion
SAP IDT - Data Foundation Layer
A Data Foundation contains one or more tables and joins from one or more relational databases that forms the design of Business Layer. A relational connection is used to design Data Foundation layer. You can add various other objects at Data Foundation that enhances the capabilities like - Derived tables, custom calculations, context, LOVs, etc.
It is also possible to design multiple Business Layers on a single Data Foundation thus allowing you to build multiple Universes on single Data Foundation Layer.
Types of Data Foundation
In Information Design Tool, you can build Data Foundation that is – Single-source enabled or multi-source enabled.
Single-source Data Foundation supports a single Relational connection. Single Source Data Foundation supports a local or a secured connection so the Universe designed on this can be maintained locally or can be published to the Repository.
Multi-source enabled Data Foundation supports one or more relational connections. Connections can be added when you design the Data Foundation or can be added later. Multi-source enabled Data Foundation is designed on secured connections published in a Repository.
![Types of Data Foundation](/sap_idt/images/types_of_data_foundation.jpg)
Data Foundation Editor
A Data Foundation editor is divided into multiple panes −
- View Pane
- Properties Pane
- Browsing pane
The Data Foundation view pane contains tables and joins. Master contains tables and joins that are connected with each other in a logical manner.
![Data Foundation view pane](/sap_idt/images/data_foundation_view_pain.jpg)
Properties pane defines properties of each object. To check the properties, you have to select any object in the Master tab.
![Master Tab](/sap_idt/images/master_tab.jpg)
Using the browsing pane, you can work on different elements in data foundation like connections, Data Foundation, Aliases and Contexts, LOVs and parameters.
![Browsing Pane](/sap_idt/images/browsing_pane.jpg)
You can also perform a search in Data Foundation. To perform a search, click the icon.
![Search in Data Foundation](/sap_idt/images/search_in_data_foundation.jpg)