Database views synchronisation

You can synchronize database view definitions from the IBP database to SCV. The Sync SCV Configuration program performs these actions on each database view definition in the IBP_SCV_DATABASE_VIEW table as follows:

Synchronizes the database view definition from IBP tables to SCV tables.

This table lists the entities that are available in the IBP and SCV tables:


IBP Table	SCV Table	Level
IBP_SCV_DATABASE_VIEW	SZ_VIEW	Header

Note: Records in the IBP header table are updated in the SCV header table.

Processes each database view definition in the IBP_SCV_DATABASE_VIEW table as follows:
- Determines if the user definition or the system definition must be used.
```
If C_IS_SYSTEM = "F" OR C_IS_OVERRIDE = "T" Then
    <current view definition> = C_USER_DEFINITION
Else 
    <current view definition> = C_SYSTEM_DEFINITION
```
- Creates the view in the database as follows:
```
If <current view> exists in the SCV database
    DROP <current view>

CREATE VIEW <current view> AS
    <current view definition>    
```
- Creates the next database view in the IBP_SCV_DATABASE_VIEW table if the creation of the previous view fails.
- Repeats the above actions to manage dependencies between view definitions.