Override SCV data

User-defined Core tables can now be extended.

Generated extension views and profile views contain separate columns for imported values, manually specified extension values and actual/result values.

For example:

  • SC_ITEM.base_uom: Stores the imported base unit value for the item.
  • SC_EXT_ITEM.xs_base_uom: Stores the manually specified base unit value for the item.
  • SC_V_EXT_ITEM.base_uom: Mapped to SC_ITEM.base_uom; stores the imported value.
  • SC_V_EXT_ITEM.xs_base_uom: Mapped to SC_EXT_ITEM.xs_base_uom; stores the manually specified value.
  • SC_V_EXT_ITEM.res_base_uom: Mapped to SC_EXT_ITEM.xs_base_uom or SC_ITEM.base_uom; returns the manually specified value if the value is available, else the imported value.

All system-defined master data tables in SCV Core are extended by default. The corresponding datasheets for extension data and views are added/updated accordingly.

Note: 
  • By default, this feature is enabled. The core extensions and datasheets are available after loading the base template (base.zip) for this release.
  • You are not required any new role or privilege access to use this feature.