Constraints synchronisation

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

Synchronizes the constraint 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_CONSTRAINT	IBP_SCV_CONSTRAINT	Header
IBP_SCV_CONSTRAINT	SZ_REG_CONSTRAINT_COLUMN	Detail

Note:

Records in the IBP header table are updated in the SCV header table.
The detail records for a specified header record are replaced.

Creates an index on SCV Inbox tables as follows:

If C_RC_TYPE = 0        (Primary Key)
CREATE NONCLUSTERED INDEX <current constraint>_IDX
    ON <current table>
    (<PK columns> ASC)

Else if C_RC_TYPE = 1       (Business Key)
CREATE NONCLUSTERED INDEX <current constraint>_IDX 
    ON <current table>
    (<BK columns> ASC)

Else if C_RC_TYPE = 2   (Hash Key)
    No indexes are created for HK constraints.

Else if C_RC_TYPE = 3   (Foreign Key)
    No indexes are created for FK constraints.

Else if C_RC_TYPE = 4   (Export/Publish Horizon Key)
    No indexes are created for EK constraints.

Else if C_RC_TYPE = 5   (Refresh Key)
    No indexes are created for RK constraints.

Else if C_RC_TYPE = 6   (Change Key)
    No indexes are created for CK constraints.

Else if C_RC_TYPE = 7   (Order number Key)
    No indexes are created for OK constraints.

Else if C_RC_TYPE = 8   (Unique Key)
    No indexes are created for UK constraints.

Creates an index on SCV Core and SCV Extension tables as follows:

If C_RC_TYPE = 0        (Primary Key)
CREATE UNIQUE CLUSTERED INDEX <current constraint>_IDX  
    ON <current table>                                          // ex: SC_ITEM
    (<PK columns> ASC)
    If the parent entity is extended 
        CREATE UNIQUE CLUSTERED INDEX <current constraint>_IDX  
            ON <extension table>                                // ex: SC_EXT_ITEM
            (<PK columns> ASC)

Else if C_RC_TYPE = 1       (Business Key)
CREATE UNIQUE NONCLUSTERED INDEX <current constraint>_IDX 
    ON <current table>                                          // ex: SC_ITEM
    (<BK columns> ASC,
     ID ASC)
    If the parent entity is extended 
        CREATE UNIQUE NONCLUSTERED INDEX <current constraint>_IDX  
            ON <extension table>                                // ex: SC_EXT_ITEM
            (<BK columns> ASC)

Else if C_RC_TYPE = 2   (Hash Key)
    No indexes are created for HK constraints.

Else if C_RC_TYPE = 3   (Foreign Key)
    No indexes are created for FK constraints.

Else if C_RC_TYPE = 4   (Export/Publish Horizon Key)
    No indexes are created for EK constraints.

Else if C_RC_TYPE = 5   (Refresh Key)
    No indexes are created for RK constraints.

Else if C_RC_TYPE = 6   (Change Key)
    No indexes are created for CK constraints.

Else if C_RC_TYPE = 7   (Order number Key)
    No indexes are created for OK constraints.

Else if C_RC_TYPE = 8   (Unique Key)
    No indexes are created for UK constraints.

Creates an index on SCV Outbox tables as follows:

No indexes are created from constraints on SCV Outbox tables.

Creates an index on SCV Staging tables as follows:

No indexes are created from constraints on SCV Staging tables.

Creates an index on SCV Planning Configuration tables as follows:

If C_RC_TYPE = 0        (Primary Key)
CREATE NONCLUSTERED INDEX <current constraint>_IDX
    ON <current table>
    (<PK columns> ASC)

Else if C_RC_TYPE = 1       (Business Key)
CREATE NONCLUSTERED INDEX <current constraint>_IDX 
    ON <current table>
    (<BK columns> ASC)

Else if C_RC_TYPE = 2   (Hash Key)
    No indexes are created for HK constraints.

Else if C_RC_TYPE = 3   (Foreign Key)
    No indexes are created for FK constraints.

Else if C_RC_TYPE = 4   (Export/Publish Horizon Key)
    No indexes are created for EK constraints.

Else if C_RC_TYPE = 5   (Refresh Key)
    No indexes are created for RK constraints.

Else if C_RC_TYPE = 6   (Change Key)
    No indexes are created for CK constraints.

Else if C_RC_TYPE = 7   (Order number Key)
    No indexes are created for OK constraints.

Else if C_RC_TYPE = 8   (Unique Key)
    No indexes are created for UK constraints.