Collect
Advanced View Builder H
Use this page to Build Advanced Views
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
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. |
