Business View

 A business view is a selection of data items from one or more tables.

 

Table Joins

A table join combines data from individual rows of joined tables. Types of joins are:

 

1.    Simple Join: This includes only rows that match both the primary and secondary tables.

2.    Right Outer Join: This includes rows common to both the tables and unmatched rows from secondary table.

3.    Left Outer Join: This includes rows common to both the tables and unmatched rows from primary table.

4.    Sql 92 left outer join: This includes rows common to both the tables and unmatched rows form primary and null values in the secondary tables.

Adding a business view

1.    On OMW click 'ADD'.

2.    On Add One world object to project, choose business view option and then click OK.

3.    On Add object complete all the fields like Object name, Description, Product code, System code, Object use and click OK.

Naming convention

The naming convention is VZZZZZZZZA.

V is business view name

ZZZZZZZZ is character of primary table

A is letter to generate view

 

Working with business view

 It has 4 windows

· Table Join: It defines the tables over which you create the business view.

· Available Tables: It locates tables for selecting and moving to the table joins view.

· Selected columns: It lists the data items from your tables that are included in your business view.

· Properties: we can get all the properties of the object.