DDM Mapping for Model Building

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

DDM Mapping for Model Building

Model building uses the recipe you define to take data from tables in the Decision Data Model and generate a model for use in Modeler. The following table provides the Modeler target tables and the DDM tables that can be used to populate the model. In some cases, there are multiple DDM tables that can be used for a single model table. For Policies & Constraints, the Defaults column indicates which table is automatically selected for capabilities and costs. You can select alternate tables as needed. The recipe definition determines which DDM table is the source as listed in the Notes.

In addition, not all Modeler tables are required for each use case, as called out in the Use case column.

For more detailed information about DDM mapping for model building, see DDM Model Building Mapping.xlsx.

Modeler table	DDM table	Defaults	Use case	Notes
Customers	location_dimension		Greenfield Analysis Network Optimization	Customer Location Type setting determines which are Customers vs Sites.
Sites	location_dimension		Greenfield Analysis Network Optimization
Products	product_dimension		Greenfield Analysis Network Optimization
Modes	transportation_mode		Network Optimization
Customer Orders	orders_full	Default	Greenfield Network Optimization	Transaction Table determines which DDM table is used.
	shipment_full
	demand_forecast	Can also be combined with orders_full or shipment_full
Production Policies	orders_full	Basic default	Network Optimization	Policies & Constraints > Capabilities determines which DDM table is used to create policies. Policies & Constraints > Costs identify the DDM table source for costs. Production Location Type determines which Sites are used.
	shipment_full
	production_policies
	production_history	Advanced default Advanced cost default
Customer Sourcing Policies	orders_full	Basic default Advanced default Advanced cost default	Network Optimization	Policies & Constraints > Capabilities determines which DDM table is used to create policies. Policies & Constraints > Costs identify the DDM table source for costs.
	shipment_full
	sourcing_policies
Site Sourcing Policies	orders_full	Basic default Advanced default Advanced cost default	Network Optimization	Policies & Constraints > Capabilities determines which DDM table is used to create policies. Policies & Constraints > Costs identify the DDM table source for costs.
	shipment_full
	sourcing_policies
Transportation Policies	orders_full	Basic default Advanced default	Network Optimization	Policies & Constraints > Capabilities determines which DDM table is used to create policies. Policies & Constraints > Costs identify the DDM table source for costs.
	shipment_full
	shipment_lanes
	shipment_headers	Advanced cost default
	shipment_cost_matrix	Used for costs
Inventory Policies	orders_full	Basic default	Network Optimization	Policies & Constraints > Capabilities determines which DDM table is used to create policies. Policies & Constraints > Costs identify the DDM table source for costs.
	shipment_full
	inventory_policies	Advanced cost default
	inventory_transaction	Advanced default
	inventory_position
Flow Constraints	orders_full	Basic default Advanced default	Network Optimization	Transaction Table determines which DDM table is used
Flow Constraints	shipment_full		Network Optimization	Transaction Table determines which DDM table is used