Improved support for User Data overrides in SCV

All system-defined master data entities are now extended by default. This feature allows users to override imported values or specify missing values for master data without having to customize views or interface services.

The generated extension and profile views in the SCV database now contain these new columns:

  • <column_name>: Imported data column
  • xs_<column_name>: Extension/user override column
  • res_<column_name> = Calculated column COALESCE(xs_<column_name>, <column_name>)
The res_* columns already select the user override value when available; in future releases of SCP, application views and interface services are updated gradually to read from these pre-calculated res_* columns.
Note: This feature is available on upgrade. You are not required a new role or privilege access to use this feature.