Defining the Quantity Structure

Objectives

After completing this lesson, you will be able to:
  • Manage a bill of materials
  • Explain Recipes and Routings
  • Display a work center
  • Discuss the integration between routings, cost center masterdata, and work centers
  • Explain production versions

Material Cost Estimates with Quantity Structures

The diagram describes the costing result structure for material cost estimates with quantity.

The results of a cost estimate created with quantity structure are identical to the results of a cost estimate created without quantity structure. The only difference is the origin of the information. The valuation principles explained in earlier units also apply here. The term quantity structure refers to the use of production master data, such as BOM, routing, and recipe.

The results are identical from the following costing points of view:

  • Cost component split
  • Itemization
  • Costed multilevel BOM

It is only the method by which you obtain the costing results that differs. Material costing with quantity structure can determine the product structure and production plans as entered in logistics, and convert them to structures of the itemization and the cost component split.

Bills of Material

The graphic is a table displaying a Product BOM, listing items with their material numbers, descriptions, quantities, and unit of measure.

Each assembly level of a multilevel BOM is maintained independently, and the system automatically constructs the multilevel structure. This is important to understand for knowing how to access and maintain a BOM.

The BOM is a directory for a material and its constituent parts, containing information such as the name, reference number, quantity, and unit of measure.

Uses of BOMs are as follows:

  • Material requirements planning for procuring parts
  • Production for staging parts
  • Costing for calculating material costs

BOM: Example

The graphic is a hierarchical structure showing material number T-FL100 at the top, branching into multiple levels with different material numbers and categories (F - finished product, S - semi-finished product, R - raw material) across Costing Levels 1, 2, 3, and 4.

The costing level controls the sequence for costing the materials within the BOM. The costing levels were developed to support multilevel unit costing. Raw materials are always procured externally and then processed. A material master record of this type contains purchasing data, but not sales data since they cannot be sold. The system automatically assigns materials to the appropriate costing level within a cost estimate based on their use in a the product structure. For the items of the cost estimate that are not part of the BOM, the system automatically assigns the costing level 0. If you use a single product in multiple BOMs, the system can only assign it to a single costing level.

The system automatically determines costing levels when you create a cost estimate.

Assigning materials to costing levels ensures that the system performs costing in the correct sequence, raw materials and purchased parts, followed by semi-finished products, followed by finished products.

The screenshot shows a BOM Usage table.

The BOM Usage has settings that affect costing. In the preceding figure, usage #1 allows costing. The symbols in the BOM Usage work as follows:

  • + Costing relevancy required
  • . Costing relevancy
  • - Costing not allowed

BOM: Header

The graphic describes various BOM headers, including BOM usage, BOM status, validity period, and alternative BOM.

BOM usage and status indicators are used to locate an appropriate BOM for preparing a cost estimate. The usage indicator is a long-term setting that identifies the applications that may use the BOM. The status indicator can represent the current availability of a BOM. For example, when a BOM is still under construction by engineering, it is not yet available for MRP, costing, or production control.

Note

For a BOM that is relevant for cost estimate planning only, you should select usage indicator 6. The status indicator must be set to released for a BOM to be used in cost estimate planning.

The system generates alternative BOMs when you create multiple BOMs for a material that contains the same usage and status indicators. If you desire the use of a specific alternative for cost planning, then you should identify the alternative number directly in the costing view of the material master.

The BOM header contains information that applies to all items in the BOM. The BOM must be valid for costing for the BOM to be read for a cost estimate.

The following fields in the BOM header are relevant to costing:

  • BOM usage:

    For example, BOMs in use exclusively for engineering or costing purposes.

    When you view the BOM usage options in a drop-down, you will see BOM usage 1 - Production as well as 6 - Costing. Either one is relevant for costing. For each usage there are symbols that control the usage:

    • + = Must - Costing Relavancy Required
    • . = Can be Used - Costing Relavancy Optional
    • - = Can't be Used
  • BOM status:

    You can use the BOM status to control what the BOM can be used for in various other organizational areas (for example, engineering, costing, MRP).

  • Alternative BOM:

    Alternative BOMs describe different product structures that create a product with the same properties. For example, in BOM A, the product uses sheet metal A, while in BOM B, the same product uses sheet metal B. The resulting product is the same.

  • Lot size range:

    A BOM can be defined as valid for only a limited range of lot sizes, for example 1 to 1,000 units. You can then create an alternative BOM for lot sizes exceeding 1,000 units.

BOM: Item

The diagram specifies various BOM items such as quantity, item category (L, N, R), validity period, fixed quantity indicator, planned scrap, relevancy to costing indicator, and bulk materials - not relevant to costing.

BOM Item Categories:

  • D Document item

  • I PM structure element

  • K Class item

  • L Stock item

  • N Non-stock item

  • R Variable Size Item

  • T Text item

Various item categories that are used within the itemization for controlling. The costing relevancy indicator is only relevant for cost planning, not actual costing. This is a useful indicator in an either/or situation, that is, you can use either material x or material y, but not both. The validity indicator is useful for recognizing component changes based on a specific validity date (using Engineering Change Management). By default, items marked as bulk components are not included in cost planning, because it is expected that they will be issued to an overhead cost center. However, there is a user exit to allow bulk items to be included in cost planning. The following fields are relevant for the BOM items:

  • Item category:

    This categorization allows you to process data that is relevant to the individual items in a BOM. The item category is used to control field selection, default values for BOM maintenance, triggering of specific system activities, and so on. Some examples of item categories are as follows:

    • Category L indicates a stock item. Valuation in accordance with material valuation strategy or separate cost estimate.

    • Category N is a non-stock item.

    • Category R is a variable-size item. Valuation in accordance with material valuation strategy or separate cost estimate.

  • Fixed quantity indicator:

    Setting this indicator shows that the component quantity is always the same regardless of lot size. It applies mainly to unavoidable material loss at the start of the production process.

    Fixed quantity is not allowed for the following items:

    • Alternative items

    • Co-products

  • Planned scrap:

    Planned scrap is used in material requirements planning (MRP) to determine the quantities of materials required. When exploding the bill of material (BOM), the system increases the required quantities of the components by the calculated scrap quantity. For example, if you set a planned scrap value of 4% and the BOM requires 100 pieces of a component, the system will calculate that 104 pieces will be required for the assembly.

  • Relevancy to costing indicator:

    If you do not select this indicator, the system ignores the BOM item in the material cost estimate. For standard cost estimates, modified standard cost estimates, and current cost estimates, you only need to decide whether or not the item will be costed.

    For inventory costing, you can link relevancy to costing indicators to factors for the fixed and variable costs so that the item values can be adjusted by the system depending on the valuation variant used in costing. You do this in Customizing for Product Cost Controlling. For example, a BOM item or operation has the indicator for relevancy to costing A, which you have linked in Customizing for Product Cost Controlling to a fixed factor of 0.8 and a variable factor of 0.7. The BOM item or operation will be costed in inventory costing at 80% of the fixed costs and 70% of the variable costs.

    The settings in the BOM usage and BOM item categories enable you to specify whether this field has a default value and whether you can change this value when you maintain the BOM.

  • Bulk material:

    You usually post bulk material, as consumption at production cost centers, as soon as it is procured. Because it is usually posted, the cost estimate in the standard system does not include the bulk material. A user exit is available if you need to cost bulk materials.

BOM: Non-Stock Materials

The graphic depicts a Bill of Materials (BOM) for a Forklift FL-100, highlighting non-stock item category 'N' for item 15, with purchasing data including a price of 50 USD per unit and cost element 400000.

Non-stock materials have item category N. They have a material master or they can be listed only by a description. If the material is identified as a material master, the costing information can be determined from the accounting view. If the material is only listed by a description, the user must define the unit of measure and the purchasing data and must include a price, the pricing unit and the cost element.

Business scenarios that may use this item category include:

  • Due to material storage requirements, it may not be possible to stock some items prior to the production requirement.

  • Some items may have an extremely short shelf life, and to deliver prior to immediate need would risk expiration of the product.

  • You may specify that certain components are only used for a unique requirement, such as in an engineer-to-order environment.

Non-stock materials are materials that are not kept in inventory. You always procure them externally and assign them directly to the order.

Non-stock materials have either no material master or are maintained with a non-stock material master.

For non-stock materials without a material master, you enter the data that is relevant to costing directly in the BOM item. For non-stock materials with a material master, you cannot manually change the prices. The material is valuated in accordance with the strategy specified in the costing variant. The price shown in the BOM might not be the same as the price in the cost estimate that you select depending on the valuation strategy.

Manage a Bill of Material

Master Recipes

The graphic illustrates a Master Recipe structure, showing the assignment of materials to the recipe header and the assignment of individual components from the BOM to specific operations and phases in the production process.

You can display a recipe by searching for the Display Master Recipe app and using material T-SPC1##.

The Production Planning Process Industries (PP-PI) equivalent of a BOM and routing is a recipe. It contains both the operations and materials list within one master record. Also, within PP-PI, you refer to work centers as resources. A recipe can produce many different products simultaneously. Products produced simultaneously are called co-products and by-products.

The process industry uses a master recipe instead of a routing.

The production version in the material master defines a fixed and unique link between an alternative of the recipe group and an alternative of a multiple BOM.

You can include the master recipe in customizing for the quantity structure control in order to access the recipe in the cost estimate. However, this can be overridden for materials in the material master or for costing in the costing request screen.

Routings

The graphic defines routing as a sequence of production steps with an example showing operations like staging, preassembly, final assembly, checking, and delivery, which are performed at work centers.

The routing identifies the following three essential elements regarding the manufacturing process:

  • Work center

  • Planned duration you expect for each operation, such as labor, setup, processing

  • Controlling activity you expect to be assigned to the operation

A routing describes a sequence of production steps. It is one of the factors determining production costs.

A routing consists of one or more operations.

Each operation contains information about the work center, production resources and tools, material assignments, operation texts, and standard values (how long, how much).

You can use rate routings and recipes for repetitive manufacturing and process manufacturing.

Routing: Header

The graphic lists elements of a Routing Header, including task list group, group counter, assignment of materials, usage, routing status, lot-size range, and validity period.

The routing header has the following settings that are different to those of the BOM header:

  • Assignment of materials:

    A routing can contain multiple materials that utilize the same production process.

  • Usage:

    You use task list usage to assign routings to various work areas. This way, you can create several routings to produce one plant material. These routings are differentiated in your task list usage.

  • Routing status:

    You use this status to indicate the processing stage of a plan. For example, you can indicate whether a plan is still at the creation stage or whether you have already released it.

You can use some of the fields in the routing similarly to the BOM. Although the usage and status indicators are configured differently to the BOM usage and status indicators, they have similar functions. The system assigns a task list group, which is a number (similar to a document number), to a routing. It is possible to create a routing without reference to a material. This is useful if you produce many different products the same way, but have minor variations in the BOM. Rather than create a material specific routing for each item, it is possible to create a reference routing, and then assign that routing to the materials concerned using the group.

The group counter is similar to the BOM alternative and designates an alternative manufacturing method for producing an item. This is very common in repetitive manufacturing, when you can assemble a product on different assembly lines that have some variation in either standard values or activities and different work centers. It may be necessary to create a costing-specific routing when a ‘blended’ standard is required. In such a case, a usage indicator specific for costing can be chosen.

Routing: Operations

The graphic outlines key aspects of Operations, including work center, control key, relevance to costing, units of measure for operation/routing, base quantity, standard values like setup and machine time, scrap, operation relevant to costing, and assignment of activity types or business processes.

For the operations, the assignment of the work center, where the work is being performed and provides the production link to controlling through the cost center. You can use the control key to determine the costing indicator, external processing, and the shop floor interaction that is expected, such as confirmation requirements. Not all operations are relevant to costing. Some may just be instructional operations, such as issue material.

The material handling costs could be part of overhead, or they may be a separate cost center/activity type, depending on customer requirements. The standard values represent the expected duration time for each activity. Multiplying this time with the cost center/activity type rate provides the cost for the operation.

The control key indicates if an operation is relevant to costing. If the control key assigned indicates that the operation is relevant to costing, you can use the relevancy to costing indicator to override the control key.

You can overwrite the standard values of the work center in the routing. By deselecting the reference indicator in the work center, you can assign activity types/business process. Linking the standard times with the activity types is done by using the formulas in the work center.

Note

You can use groups, for instance, to identify two routings that have different production steps for one material. In combination with the group counter, the task list group uniquely identifies a task list.

Optional: Work with Routings

Work Centers

The graphic defines a work center as a physical location for performing operations and provides examples including an individual work center (Lathe 17), work center group (Turnery), production line (Line 9), individual employee (B. Moore), and personnel group (Pool 12).

Work centers can represent machines, individual people, or an assembly team. It indicates a location, object, person, or group of people that needs some type of work planning and management.

You can use work centers in plans such as routings, networks, inspection plans, maintenance task lists, and rough-cut planning profiles.

You define work centers with reference to a plant. You assign work centers to cost centers.

Use of Work Center and Routing

The graphic illustrates the use of work centers and routing in production/assembly (including periods, control data, texts, producton resources, material, and quality assurance), scheduling (from start date to end date), capacity planning (machine and personnel capacity), and costing (covering production costs and overhead).

You can adapt routing or work center to production/assembly, scheduling, capacity planning, and costing. They are used as basic data by many applications.

Work Center: Fields

The graphic outlines fields related to a Work Center, including basic data (standard value key, rule for standard value maintenance , performance efficiency rate), default values (control key), and links to cost centers or business processes (cost center/business process, activity types and formula key).
Work Center Category:

The work center category determines which data you can maintain in the work center and which values are proposed.

Standard value key:

The standard value key determines how many default values you can maintain (maximum of six), and assigns a meaning (such as setup time, machine time, or labor time) and a dimension (such as minutes) to the standard values.

Standard values are used in formulas to calculate the execution time, the capacity requirements and the production costs.

Efficiency Rate:

The performance efficiency rate is the relationship between the predefined target time and the actual time. You can use the efficiency rate key in costing to correct the default values.

You can define default values for the routing or master recipe in the work center or resource respectively. If you assign an operation in the routing or a phase in the master recipe to this work center or resource then these default values are transferred to the operation or phase.

The following default values are relevant to costing:

  • Control key:

    The control key specifies the following:

    • Whether the operation or the phase are included in the costing

    • Whether the operation or the phase are processed internally or externally

    • Whether they are confirmed and in what form

  • Reference indicator:

    Setting this indicator prevents the control key from being changed in the routing.

The most important definition within a work center is the standard value key. This controls how you can plan and measure activities for a work center. You can configure the standard value key to allow up to six measurable standard values and activities that you can plan for a work center.

Of critical importance to controlling, is the assignment of the work center to a cost center (or business process). This provides the cost link for the work center. You can assign a work center to one cost center only at any one time. Based on the standard values that the system allows for a work center, you can define up to six activity types for the work center. These activity types will, by default, be copied to the routing you assign the work center to.

You can define a seventh activity type for the work center for the sole purpose of applying additional costs for production. This can provide a method of applying an indirect cost allocation, using a formula that you can define in configuration. The benefit of this vs. the overhead costing sheet is that this allocation can be based on the output quantity of the operation. This is not possible when using the costing sheet, since the costing sheet is based on input quantity and costs. The seventh activity type does not apply to PP-PI work centers/resources, though it is normally the only standard value that you use for Project Systems work centers.

Optional: Manage Work Centers

Cost Centers and Activity Types

The diagram illustrates the creation of activity types and planning activity type's prices in the cost centers.

The activity type classifies the activities that one or several cost centers perform within a company.

If a cost center provides activities for other cost centers, orders, processes, or similar, the resources of this cost center are being used by other cost centers. The costs of these resources need to be allocated to the receivers of the activity. Activity types serve as tracing factors for this cost allocation.

In an internal activity allocation, you enter the quantity of the activity, for example, the number of consulting hours, into the SAP S/4HANA application (manually or automatically). The system calculates the associated cost based on the activity price and generates a debit to the receiver and a credit to the sender for both the quantity and the costs. The internal activity allocation is carried out using secondary cost elements, which you enter in the activity type master data.

You can restrict the use of the activity type to certain types of cost centers by entering the allowed cost center categories in the activity type master record. You can enter up to eight allowed cost center categories, or leave the assignments "unrestricted" by entering an asterisk (*).

The activity type category is used to determine whether and how an activity type is recorded and allocated. For example, you can allow some activities to be allocated directly, but specify for others that they are either not allocated or allocated only indirectly.

Relationship Between Cost Center and Activity Type

The graphic shows an Activity Output/Price Planning table for the year 202019, detailing a Senior Consultant activity type with a price of 300 and price unit of 00001 for cost center 11100 Consultant FI/CO over periods 1 to 12.

To enable internal activity allocation, you need to specify which cost centers provide which activity types at what price. You do this in the SAP S/4HANA application by planning the activity output and prices for a cost center. To enable this, the SAP S/4HANA application provides a number of options.

For direct activity allocation, you enter the quantity of the activity to be allocated manually. In order for you to perform a cost allocation and an activity allocation, the SAP S/4HANA application has to valuate the allocated activity amount using the sender’s price for this activity type. For a direct activity allocation, you can use the planned price for the cost center/activity type combination.

You can enter the planned price either manually or let the system calculate it automatically within planning. To manually set the price, you must set the plan price indicator in the activity type master record to the value 3 (manual entry, indirect allocation). You can use this procedure if your price calculation is not complex, for example, this depends on the prices of external suppliers and not on the costs of the cost center.

Routing, Work Center, and Cost Center Integration

The graphic demonstrates the integration of routing, work center.

To calculate production costs, the routing is used to determine work centers, which are assigned to one specific cost center. For each operation, the routing must specify where the work is to be performed (work center), what production activities will be performed, and the duration of those activities. Using activity type planning, controlling must provide a price to charge to the cost center when this activity is performed. The activity types that are used for costing must be planned for the cost center, while the actual duration of the activity is defined in the routing. The formula determines how the total execution time for the standard value should be calculated, that is setup (lot size quantity independent) versus machine time (lot size quantity dependent).

You can create production costs by combining data from production planning with Cost Center Accounting and Activity-Based Costing.

The routing is assigned to a work center. Therefore, the routing describes the quantity of an activity and the location of the operations. The work center describes where you perform an operation.

The work center is linked to a cost center to charge the activity costs.

You can calculate the planned activity prices for the work center through the link to a cost center and the activity type planning for the cost center.

Formulas in Work Centers

The diagram illustrates the relationship between routing, work center operations, and activity types, using formulas to calculate setup, machine, and labor times.

You use formulas in the work center to calculate the following data in costing, scheduling, and capacity planning:

  • Costs
  • Execution times for production orders
  • Internal processing times for networks and maintenance orders
  • Capacity requirements

Specifically for costs, in production orders each of up to six standard values in a work center can be assigned an activity type and a formula with which the costs of the operations conducted in the work center are calculated.

In the SAP system you can use predefined SAP formulas and define your own formulas. You can create formulas in customizing for work centers under define formulas for work centers.

Costing Result

The graphic explains costing results by showing how activity types for setup, machine, and labor are calculated with formulas applied to determine the final resource, quantities and costs for a given lot size.

The system calculates the costs by multiplying the quantity by the price. The quantity comes from the standard values for the operation and is modified by the performance efficiency rate and any relevant formulas.

In the itemization for the cost estimate, the system displays an internal activity for the cost center or activity type. The system saves the assignment to the operation and work center in the itemization.

Production Versions

The graphic showcases different production versions based on lot-size ranges (0-100, 101-200, and 201-1000 pieces), including information on task list combinations, group counter and alternative BOM, description of various production technologies, and restrictions of product versions: lot-size range and validity period.

Production versions are mandatory. They define a unique combination of routing, BOM, and lot size.

A production version determines which alternative BOM is used together with which task list/master recipe to produce a material or create a master production schedule. For one material, you can have several production versions for various validity periods and lot-size ranges.

You maintain production versions in the MRP view 4 and costing view 1 in the material master.

Summary

  • Understand how BOMs, routings, and work centers determine material and production costs in SAP S/4HANA.
  • Learn to manage BOMs for accurate material cost estimation and production planning.
  • Explore the integration of routings, cost centers, and work centers for effective cost control.
  • Discover how production versions uniquely link BOMs and routings for specific lot sizes.
  • Recognize the importance of work centers in linking production activities to cost centers.