Book Image

Creating Universes with SAP BusinessObjects

By : Taha Mahmoud
Book Image

Creating Universes with SAP BusinessObjects

By: Taha Mahmoud

Overview of this book

Table of Contents (17 chapters)
Creating Universes with SAP BusinessObjects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Data Foundation object manipulation


In this section, we will get to know all the functions and features that we can apply using the pop-up menu that is displayed by right-clicking on any Data Foundation object. By the Data Foundation object, we mean a table, view, alias table, or derived table.

When you right-click on any table placed in Data Foundation, we will able to see a menu divided into four sections.

Insertion

This is the first section in this menu, and we can use it to insert the following:

  • An alias table based on the selected table

  • A derived table from the current selected table

  • A Data Foundation view from the current selected table/tables

The Insert menu and its options are shown in the following screenshot:

Note that if we select the Derived Table... option, it will create a derived table with the select statement that will display (Select *) all the columns in the selected table. Later on, we can edit the expression for the derived table and customize it as per our needs.

The second...