Sourcing Process Constraints

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Sourcing Process Constraints

Internal Table Name: SourcingProcessConstraints

Sourcing Process Constraints are limitations placed on the Sourcing Processes that must be met for a solution to be considered feasible. You control the scope of the constraint (periods, sites, products and processes) and the type of constraint (such as a minimum or maximum).

Expression

Technology: NO

Table: SourcingProcessConstraints

Internal Name: ExpressionName

Type: Short Text (100)

This is an optional name for the Sourcing Process Constraint. You can then use the Inventory Process Constraint in:

an Expression Constraint by specifying the Expression for either the Expression 1 or Expression 2 value. This enables you to combine constraints.
an Expression Based Cost by using this value in the Expression field. This enables you to defined fixed and variable cost components that are incurred as a result of the constraint.

Period

Technology: NO

Table: SourcingProcessConstraints

Internal Name: PeriodName

Type: Short Text (50)

One of (ALL_Periods) (All), (ALL_Periods) (Each), period name, period group.

Select the period which the constraint will apply to. If there are no Periods specified in the model, you can select (ALL_Periods) (All) to apply the constraint to the planning horizon.

In a multi-period model, if you select no value for Period, it will behave the same as if you select (ALL_Periods) (All) and apply the constraint across the planning horizon. In order to ensure the correct behavior, Coupa recommends that you select the specific period or, when using (ALL_Periods) or another period filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full horizon/group
(Each) to apply the constraint per period

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Source

Technology: NO

Table: SourcingProcessConstraints

Internal Name: SourceName

Type: Short Text (100)

One of (ALL_Sites), site name, site group.

Select the source site at which this sourcing process constraint applies. When this field is set to (ALL_Sites), the constraint applies to all sites. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Destination

Technology: NO

Table: SourcingProcessConstraints

Internal Name: DestinationName

Type: Short Text (100)

One of (ALL_Sites), (ALL_Customers), site name, site group, customer name, customer group.

Select the destination site at which this sourcing process constraint applies. When this field is set to (ALL_Sites), the constraint applies to all sites; when set to (ALL_Customers), it applies to all Customers. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Product

Technology: NO

Table: SourcingProcessConstraints

Internal Name: ProductName

Type: Short Text (100)

One of (ALL_Product), product name, product group.

Select the product for which this sourcing process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Process

Technology: NO

Table: SourcingProcessConstraints

Internal Name: ProcessName

Type: Short Text (100)

One of (ALL_SourcingProcesses), sourcing process name, sourcing process group.

Select the process for which this sourcing process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Process Step

Technology: NO

Table: SourcingProcessConstraints

Internal Name: StepName

Type: Short Text (100)

One of (ALL_SourcingProcessSteps), (None), sourcing process step name, sourcing process step group.

Select the process step for which this sourcing process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Next Process Step

Technology: NO

Table: SourcingProcessConstraints

Internal Name: NextStepName

Type: Short Text (100)

One of (ALL_SourcingProcessSteps), (None), sourcing process step name, sourcing process step group.

Select the next process step for which this sourcing process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Work Center

Technology: NO

Table: SourcingProcessConstraints

Internal Name: WorkCenter

Type: Short Text (100)

One of (ALL_WorkCenters), work center name, work center group.

Select the Work Center or Work Center group that applies to the Sourcing Process. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Work Resource

Technology: NO

Table: SourcingProcessConstraints

Internal Name: WorkResource

Type: Short Text (100)

One of (ALL_WorkResources), work resource name, work resource group.

Select the Work Resource or Work Resource group that applies to the Sourcing Process. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Constraint Value

Technology: NO

Table: SourcingProcessConstraints

Internal Name: Requirement

Type: Short Text (100)

Enter the amount required for the period-source-destination-product-process-process step-next step name combination. **Enter a value, then optionally select a quantity, weight, volume, or time unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Constraint Type

Technology: NO

Table: SourcingProcessConstraints

Internal Name: RequirementType

Type: Short Text (25)

One of Min, Cond Min, Max, Fixed, Define.

Choose the constraint type. This defines how the Constraint Value is used.

Min – At least X is required.
Max – At most X is allowed.
Fixed – X is required.
Cond Min – Either at least X is required or there must be none at all.
Define – Network Optimization does not use the Constraint Value to satisfy the constraint. Instead, the constraint value is specified in the Expression Constraint. See Considerations for grouped constraints for additional information.

Constraint Period

Technology: NO

Table: SourcingProcessConstraints

Internal Name: RequirementPeriod

Type: Short Text (50)

One of Period Length, Day, Week, Month (30 Day), Quarter (91 Day), Year, Horizon.

Choose the period over which the Constraint Value is to be established. When this field is left blank the horizon of the optimization will be used as the Constraint Period.

Status

Technology: NO

Table: SourcingProcessConstraints

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

Specify whether or not to include the specific constraint in the model.

Default: Include

Notes

Technology: NO

Table: SourcingProcessConstraints

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the sourcing process constraint.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No