Describing General Master Data Types

The master data types of customers, locations, sources of supply, and resources, are shown in the following figure, General Master Data Types.

Simple foundational master types include products, customers, resources, and planning unit.

Products are produced, transported, and stored in the supply chain network.

The product ID within SAP Integrated Supply Planning (IBP) for Supply Chain corresponds to a material number in SAP ERP or SAP S/4 HANA.

The product master data type (MDT) has the following fields:

• PRDDESCR

• PRDFAMILY

• PRDID

• PRDSERIES

• PRDSUBFAMILY

• UOMID

• UOMDESCR

Only PRDID is required. PRDSUBFAMILY, PRDFAMILY, and PRDSERIES are examples of optional attributes for aggregation, independent of the supply chain network structure.

Products are sold to and shipped to customers.

Choosing how to represent the customer for different macro processes supported by SAP IBP, such demand, supply and response is an important design decision.

Generally speaking, supply customer is a virtual entity or a customer grouping that is often associated with the location, rather than with the actual customer account.

By contrast, the customer ID in SAP IBP Order-Based corresponds to the customer number in SAP ERP or SAP S/4 HANA.

Only CUSTID is a key.

A location is a logical and often also a physical place where products are stored, produced, shipped to, or shipped from (by a transport).

In S&OP, suppliers can be modeled as locations, with type "V".

There are four type of resources that can be modeled in SAP IBP.

In SAPIBP1 this master data type has 3 attributes: RESID (key), RESTYPE and Resource Description.

Production resources model a production or assembly process. Their capacity is consumed per produced or assembled unit of product.

Handling resources apply to all goods receipts at a location in the sense that each arriving unit of a product consumes a certain capacity unit of the resource.

Storage resources model capacity restrictions in various dimensions, for example, limited volume capacity in a warehouse. The capacity of a storage resource is consumed when specific products are stored in it.

Transportation resources model capacity requirements for transports (location source of supply). Their capacity is consumed with each unit that is transported.

This master data type (consisting of just one key attribute Planning Unit) describes subnetworks, that are used to divide the overall supply chain network. Division can be based on responsibility of a planner, or necessity to plan in a separate planning run.

Examples of general compound master data types are customer product, location product, and resource location.

The customer product master data type may have the following fields:

• CUSTID

• MARKETSEGMENT

• PRDID

Only CUSTID and PRDID are mandatory.

For example, MARKETSEGMENT is an attribute not of customer nor product individually, but of the combination thereof.

This master data type is one of the most important in supply planning. It's attributes that are used predominantly by supply planning and inventory optimization algorithms are not describing location nor product individually, but their combination. The location product master data type may have the following fields:

• FROZENHORIZON

• LOCID

• LOTSIZEPOLICY

• PLUNITID

• PRDID

Only PRDID and LOCID are mandatory.

Resource location models capacity supply as time-independent or time-dependent.

If the Capacity Supply Is Time-Series field is marked as X, then the capacity supply key figure is used.

Constraint type (CONSTRAINTTYPE) identifies whether the resource is finite or infinite. If it is left blank, it’s infinite. ‘F’ stands for finite.