# SAP CO-PA Value Field Mapping Worksheet: Conditions to Value Fields

> Source: https://netray.co/tools/sap-co-pa-value-field-mapping-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Map each CO-PA value field to its source condition or cost, set the sign, and test the contribution margin result.

## Category

sap

## Erp

SAP ECC and S/4HANA

## Audience

- SAP FICO consultant
- SAP CO-PA specialist
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Value field

**Key:** vf

**Type:** text

#### Description

**Key:** descr

**Type:** text

#### Source type

**Key:** source

**Type:** select

**Options:**

- Billing condition
- Cost of goods sold
- Variance
- Overhead
- Settlement
- Quantity

#### Source reference

**Key:** ref

**Type:** text

#### Sign (+1 or -1)

**Key:** sign

**Type:** number

#### Sample amount

**Key:** amount

**Type:** number

**Format:** currency

#### Signed result

**Key:** signed

**Type:** number

**Expr:** sign * amount

**Format:** currency

**Rows:**

**Vf:** VV100

**Descr:** Gross revenue

**Source:** Billing condition

**Ref:** PR00

**Sign:** 1

**Amount:** 100000

**Vf:** VV110

**Descr:** Customer discount

**Source:** Billing condition

**Ref:** K007

**Sign:** -1

**Amount:** 6500

**Vf:** VV120

**Descr:** Freight revenue

**Source:** Billing condition

**Ref:** KF00

**Sign:** 1

**Amount:** 2200

**Vf:** VV200

**Descr:** Cost of goods sold at standard

**Source:** Cost of goods sold

**Ref:** VPRS

**Sign:** -1

**Amount:** 61000

**Vf:** VV210

**Descr:** Production variances

**Source:** Variance

**Ref:** Order variance settlement

**Sign:** -1

**Amount:** 1800

**Vf:** VV300

**Descr:** Fixed overhead surcharge

**Source:** Overhead

**Ref:** Costing sheet

**Sign:** -1

**Amount:** 4300

**Totals:**

#### Contribution margin

**Key:** signed

**Agg:** sum

**Format:** currency

**Summary:**

#### Revenue (sum of signed results)

**Key:** rev

**Expr:** sum_signed

**Format:** currency

#### Value fields mapped

**Key:** rows

**Expr:** count

**Format:** integer

**Notes:** Costing-based CO-PA stores value fields per operating concern; names must start with VV for amounts. Condition types such as PR00, K007, KF00 and VPRS are common SAP SD delivered keys, but check your own pricing procedure. Assignment is maintained in KE4I (conditions) and in the PA transfer structure for costs.

## Content

**Intro:** In costing-based profitability analysis, every number that appears in a CO-PA report comes from a value field. This worksheet records the design decision for each one: where it comes from, the sign it takes and what it adds to the margin. It is built to sit in a blueprint before configuration starts.

**Sections:**

#### How to use the worksheet

**Body:** List each planned value field with a short description, the type of source (billing condition, cost of goods sold, variance, overhead or settlement), the exact condition type or cost element, and a sign. Enter a sample amount to see the signed result and the contribution margin total. If the margin is wrong in the test, your sign or source is probably wrong. Export to Excel for the design workshop.

#### How CO-PA gets the data

**Body:** Value fields are filled when billing documents are posted (SD conditions mapped in KE4I), when cost of goods sold is determined (condition VPRS or a CO-PA costing run), and when orders and overheads are settled into CO-PA with a settlement profile. The transfer structure for settlement maps cost elements or origins to value fields. In S/4HANA, margin analysis uses the Universal Journal and the account-based model, with costing-based available as an additional view.

#### Design guidance

**Body:** Keep value fields at a level that finance actually uses: revenue, deductions, COGS, variances, freight and a few overheads. Splitting cost into dozens of fields makes reports slow and hard to read. Plan quantity fields as well (sales quantity, weight). Decide early which fields roll up to contribution margin 1 and which to margin 2, as these groupings are reports and not fields.

#### Common mistakes

**Body:** Mapping the same condition type to two value fields, so revenue is counted twice. Forgetting to map freight or rebate conditions, so they are missing from margin. Mixing sign conventions between SD and CO sources. Adding a field after go-live and not reposting history. Using value fields for data that belongs in characteristics.

**Cta:** If you want to test a CO-PA design against actual billing and settlement data before you configure it, Netray can help build a read-only analysis of your current margin structure.

**Faq:**

#### What is a value field in CO-PA?

**Answer:** A value field is an amount or quantity column in the operating concern, such as revenue or cost of goods sold. Together with characteristics like customer or product, it forms the data that profitability reports are built on.

#### Do value fields exist in account-based CO-PA?

**Answer:** Account-based CO-PA reads from G/L accounts and cost elements and does not use value fields. They exist in costing-based CO-PA, which stores values per operating concern and supports non-account views such as valuation at different costs.

#### Where do I map billing conditions to value fields?

**Answer:** Condition types are assigned to value fields in transaction KE4I, which uses the pricing procedure condition types. Settlement of orders into CO-PA uses a different mapping through the PA transfer structure.

#### Why does my margin differ from the G/L?

**Answer:** Costing-based CO-PA values at standard or other costs and includes statistical items, so it does not need to equal the P&L accounts. Reconciliation reports compare the two and explain the difference by category.

## Search terms

sap co-pa value field mapping, copa value fields, sap profitability analysis design template, ke4i assign condition types to value fields, sap costing based copa value fields, sap co-pa contribution margin, co-pa vv value fields, sap copa blueprint template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json