Interface Service performance improvements

Interface Services are updated to improve general performance for transferring transactional data from SCV. The interface query is modified to remove links to hierarchy tables based on hierarchy type (_H) and only link to the profile view tables (SC_V_) for the main table of the interface.

This applies to all standard Interface Services if the Type is Database and Data Entity is Scenario Value.

Example:

  • SPLS - SCV -Import Customer Orders. Removed these joins from the interface query:
    • and HL.hierarchy_type = 'LOCATION'
    • and HI.hierarchy_type = 'ITEM'

This feature is enabled after appending the base template (base.zip) and the supply planning template (spls.zip) for this version.

Note: By default, this feature is enabled. No additional role or privilege is required to access this feature.