Collect

Advanced View Builder H

Advanced View Builder V

Use this page to Build Advanced Views and Create Collect Target Views for Master Data Management.

To access this page, select Collect > Tools > Advanced View Builder in Navigation pane.

Field

Description

Build View

Click to create views in the database listed in the Database for View field. Views have the same name as the tables provided in the database listed in the Database for Tables field. SAP Client and SAP Language are added to Where clause when those columns are found in the source table.

DATABASE FOR VIEWS

Displays target database where new rules will be created.

NOTE: The view selected from this list box cannot be the same view selected for DATABASE FOR TABLES. The view selected for DATABASE FOR VIEWS is removed as an option from the DATABASE FOR TABLES list box.

DATABASE FOR TABLES

Displays source database used to create views.

NOTE: The view selected from this list box cannot be the same view selected for DATABASE FOR VIEWS. The view selected for DATABASE FOR TABLES is removed as an option from the DATABASE FOR VIEWS list box.

TRANSFORM PARAM TABLE

If enabled, the table is a view or a table in Database For Views database, and SQL joins are created in the view, linking Transform Param to the source table.

SAP CLIENT

Displays name of the client within the SAP instance that is added to the Where clause.  When Transform Param Table is enabled, the SAP Client field is ignored

LANGUAGE

Displays default language of SAP instance that is added to the Where clause. Displays name of client name within SAP instance.  When Transform Param Table is enabled, the Language field is ignored

GROUP FOR VIEWS

Displays group; views are built for all active tables in the group.

GENERATED

Displays date and time when view was built.

Advanced View Builder V

Advanced View Builder H

Use this page to Build Advanced Views.

Field

Description

Database For Views

Displays target database where new rules will be created.

NOTE: The view selected from this list box cannot be the same view selected for DATABASE FOR TABLES. The view selected for DATABASE FOR VIEWS is removed as an option from the DATABASE FOR TABLES list box.

Database For Tables

Displays source database used to create views.

NOTE: The view selected from this list box cannot be the same view selected for DATABASE FOR VIEWS. The view selected for DATABASE FOR TABLES is removed as an option from the DATABASE FOR VIEWS list box.

Description

Displays brief description of the view, e.g., the function of the view.

Transform Param Table

If enabled, the table is a view or a table in the Database For Views database, and SQL joins are created in the view, linking Transform Param to the source table.

SAP Client

Displays the name of client within the SAP instance that is added to the Where clause.  When Transform Param Table is enabled, SAP Client is ignored

Language

Displays default language of SAP instance that is added to the Where clause. When Transform Param Table is enabled, Language is ignored

Group For Views

Displays group; views are built for all active tables in the group.

Generated

Displays date and time when view was built.

View Built Count

Displays number of views built.