Evaluating with a Costing Sheet

Objective

After completing this lesson, you will be able to configure a valuation strategy with a costing sheet

Valuation Strategy with a Costing Sheet

Diagram showing cost calculation process in sales order billing. Sales order billing connects to Costing Sheet via Valuation Strategy, which factors in special handling, packaging conditions. Icons: CO-PA, SD.

Costing sheets are used to access or calculate special values. They are central components of prime importance in the condition technique. This is a method that the system can use throughout the SAP system to perform calculations.

Costing sheets consist of a sequence of user-defined condition types. Each user-defined condition type accesses a value or performs a specific calculation, as dictated by the definitions of the condition types. Each condition type is mapped to a value field in the operating concern.

Condition Types: Condition Records

Image showing the valuation strategy process of an application, specifying its costing sheet ACT001 and quantity field VV1QT, detailed with condition type OUPA and its relation to a condition table including plant and amount details.

A condition type represents a step in a costing sheet.

The calculation that the system performs in a step depends on the following control indicators:

  • Condition category:

    The condition category classifies condition types according to predefined categories. These include E for cash discount, and K for base amount excluding tax.

    Calculation types that take over the amount from the value field have the condition category K. Condition types that have the percentage value to calculate surcharges or reduction have the condition category " " (blank).

    Note

    Condition types that select the value from the value field to use the amount for further calculations have the condition category K . For example, the condition type RVEN selects the revenue from the value field VV010. Additionally, the condition type COGS takes the cost of goods sold from the value field VV140.

    In the training system, on the costing sheet ACT001, both condition types are used to calculate the commission.

  • Calculation type:

    The calculation type determines how the system calculates prices, reductions, or surcharges for a condition type. For example, the calculation type specifies that a sales deduction is dependent on the quantity sold or a value scale.

  • Condition class:

    The condition class divides condition types into deductions, or additions and prices. Condition types with the condition category K usually have the condition class B (prices), such as the revenue amount or cost of goods sold (S—Price).

    However, you can also take over an amount that you want to use as a discount or surcharge.

    The scale basis determines how the system interprets the amount as a value or a quantity.

Valuation Using Costing Sheet: Customizing

Diagram showing a costing sheet with steps, condition types, definitions, ranges, and value fields. Steps are numbered from 10 to 130. Condition types include Revenue, Discount, Net revenue, etc. Various value fields are listed.

Base condition types form the basis for calculations. They signify the value fields that are populated through other means. These condition types must have a condition category K, a calculation rule B, and a condition class B on their master record.

Calculation condition types perform calculations on the lines in the costing sheets that represent the subtotals of amounts, such as base amounts. These condition types actually populate the value fields with values. Note that condition type definitions can vary.

A calculation condition type is assigned an access sequence with corresponding condition records. The condition records contain deductions, additions, or absolute values that refer to specific combinations of characteristic values.

Customizing Monitor Valuation Analysis

Screenshot showing SAP Valuation Analysis Detail screen showing Valuation Method (VVIQT) and Value Field Assignments with various cost and revenue fields. Highlighted sections include the Valuation Method and Value Field Assignment.

The value field analysis function enables you to analyze all the flows of actual data to CO-PA. You can find inconsistencies by looking at the individual value fields. The Customizing Monitor Valuation Analysis shows the value flows that the value field is involved in, and the condition types or cost elements from which the value field inherits its values.

You can analyze the following actual value flows:

  • Transfer of billing documents and incoming sales orders from sales order management.

  • Direct postings from Financial Accounting (FI) and operations.

  • Order and project settlement from overhead cost orders and project system.

  • Cost center assessment from cost center accounting (CO-OM-CCA).

  • External data transfer.

Analysis of Valuation

Screenshot showing software interface related to valuation strategies in an ERP system, highlighting valuation methods, costing sheets, and simulation options for billing and plan data.

Valuation analysis is available when entering plan or actual data. Note that you can check valuation by simulating the entry of single line items. You can specify different valuation points in time and, in this way, check different valuation strategies.

To analyze the valuation errors during billing document transfer, execute a simulation of previously transferred billing documents, and then analyze the results of your valuation strategies.

Configuration of a Valuation Using Costing Sheets

Business Example

You want to use the option to calculate additional cost in COPA costing-based using costing sheets. Determine the estimated costs of packaging the finished products, which is 3.00 for each unit.

The true costs for packaging are not known at the time of invoicing sales orders. Such costs are posted on logistics cost centers. You want to include them in CO-PA to evaluate profitability.

Use valuation to configure the system to calculate the estimated values for packaging supplies at the time an invoice is billed.

Simulate a Line Item and Check the Valuation

Business Example

You want to verify the valuation using a costing sheet. In the previous exercise you did check how COPA calculate the cost for packaging. Now you want to test the calculation.

Task 1: Verify a Costing Sheet

To verify that the costing sheet has been defined correctly, enter another line item in costing-based CO-PA, and perform the valuation. Determine the value of Dispatch Packaging.

Task 2: Create a Pricing Report

Analyze Configuration Using the Customizing Monitor

Business Example

You want to verify the functions available in the App. Customizing Monitor - Organizational Structures KECM. You are interested in the overview of valuation as well as the Where used list.

You want to check the valuation strategy for record type F and record type A, point of valuation 01 - Realtime valuation of actual data.

  • Which valuation strategy is used for the record types?
  • What are the valuation methods that are used?
  • What CO-PA quantity field is used?
  • What condition type the value fields VV010 is assigned to?
  • What is the definition of the condition type?
  • Where is the BRSCH characteristic used in COPA?

Summary

  • Costing sheets perform calculations using user-defined condition types.

  • Condition types are mapped to value fields in the operating concern.

  • Condition types include categories, calculation types, and condition classes.

  • Customizing Monitor provides an overview of valuation steps and analysis.