Main menu
Member section cover

BLOG

ERPCorp SAP FICO Blog

Font size: +

Updating CO-PA Quantity Fields

SAP Press Salehttps://shrsl.com/43z0d

 

Updating Quantity Fields in CO-PA

By Paul Ovigele

99 Paul Ovigele Headshot

Table of Contents

  1. Assigning Quantity fields from Sales Documents

  2. Assigning Quantity Fields from Manufacturing Orders

  3. Assigning Quantity Fields from FI Documents 

 

When you are using SAP Controlling Profitability Analysis (CO-PA) you know that mapping objects to value fields is the key to ensuring that the reports are complete and accurate. The normal scenario is to assign amount fields such as sales conditions, general ledger accounts and production variances.

However, it is also important to map quantity fields such as sales and production quantities to value fields (which are set up with a “quantity” attribute in transaction KEA6). Most sales and contribution margin reports contain these quantity values (for example Net Weight of products sold) in order provide the appropriate context for the reported revenue and cost of sales figures.

There are three main areas where you can make assignments to quantity fields in CO-PA.

 

Join us at SAP Controlling Financials Conference:

Meet Paul Ovigele and other SAP expert speakers in-person:

Use coupon code: JJ100 and save $100: click here

 Conf CTA

 

1. Assigning Quantity fields from Sales Documents

This is the most common assignment, because most of the postings in CO-PA come from sales documents. You will therefore want to map the sales quantity that led to the revenue postings from billing documents or sales orders (if you have activated Transfer of Incoming Sales Orders using transaction KEKF) by going to transaction KE4M or by accessing the following configuration menu path:

Controlling • Profitability Analysis • Flows of Actual Values • Transfer of Incoming Sales Orders • Assign Quantity Fields or Controlling • Profitability Analysis • Flows of Actual Values • Transfer of Billing Documents • Assign Quantity Fields

In the next screen, click on New Entries and enter the sales quantity fields and the corresponding value fields that you want to map them to as shown in Figure 1. 

 

 

 

 

 

 

 

 

Figure 1 Assign SD Qty Fields to CO-PA Qty Fields


Anytime you post a sales document, the sales quantities will be updated in CO-PA.

Watch Paul Ovigele's S/4HANA Keynote at SAP Controlling Conference:

 

 
 

2. Assigning Quantity Fields from Manufacturing Orders

When you produce a product using production orders, process orders, product cost collectors, etc., you can transfer the quantity produced to CO-PA by going to transaction KEI1 or via configuration menu path:

Controlling • Profitability Analysis • Flows of Actual Values • Settlement of Production Variances • Define PA Transfer Structure for Variance Settlement

Click on the relevant PA Transfer Structure (which is assigned to the settlement structure of the order type) and double-click on the “Assignment Lines” folder. Then enter an assignment number, a description and click on the “Qty billed/delivered” checkbox as shown in Figure 2.


Figure 2 Define PA Transfer Structure

Then double-click on the “Value Fields” folder and select “Quantity Field”; enter “3” in the “Fixed/Variable” column and enter the relevant quantity value field as shown in Figure 3.


Figure 3  Quanity Fields

Anytime you settle the manufacturing order which has been delivered or technically complete, the quantity of the order will be passed to CO.

 

To learn more about SAP FICO topics: become a member click here:

 erp book 2

 

3. Assigning Quantity Fields from FI Documents

There are times when you need to post manual FI documents to CO-PA (for example, using transaction FB50 or FB70) and you want the quantities that you enter in this transaction to flow to CO-PA (note, you would need to enter the relevant quantity and unit of measure in the “Qty” and “Base Unit of Meas.” Columns of these transactions). You can do this by going to transaction KEI1 or via the configuration menu path:

Controlling • Profitability Analysis • Flows of Actual Values • Direct Posting from FI/MM • Maintain PA Transfer Structure for FI Postings

Highlight the relevant PA transfer structure (configured in Transaction KEVG6) and double-click on the “Assignment Lines” folder. It is most likely that you have already assigned the relevant cost elements to the “Amount” value fields. Therefore you simply need to select the assignment line that contain the cost elements and double-click on the “Value Fields” folder. Then select “Quantity Field”; enter “3” in the “Fixed/Variable” column and enter the relevant quantity value field as shown in Figure 4.


Figure 4 Define PA Transfer Structure

Anytime you make a posting to the relevant general ledger account and enter a quantity and unit of measure, this quantity will be passed to CO-PA.

 

Glossary

 

Activity Type

An activity type identifies activities provided by a cost center to manufacturing orders. The secondary cost element associated with an activity type identifies the activity costs on cost center and detailed reports.

Actual Costing

Actual costing determines what portion of the variance is debited to the next-highest level using material consumption. All purchasing and manufacturing difference postings are allocated upward through the BOM to assemblies and finished goods. Variances can be rolled up over multiple production levels to the finished product.

Assembly Scrap

Assembly Scrap allows you to plan for faulty or damaged assemblies.

Since no production process is perfect, some scrap is always produced. You can either scrap or rework assemblies and components that do not meet quality standards. Depending on the problem, you may scrap cheaper items and rework costly items.

Automatic Account Assignment

Automatic account assignment allows you to enter a default cost center per cost element within a plant with Transaction OKB9.

Condition Type

A condition type is a key that identifies a condition. The condition type indicates, for example, whether the system applies a price, a discount, a surcharge, or some other pricing, such as freight costs and sales taxes.

Cost Center Accounting

A cost center is a function within an organization that does not directly add to profit but still costs money to operate, such as the accounting, HR, or IT departments. The main use of a cost center is to track actual expenses for comparison to the budget.

Cost Estimate

A cost estimate calculates the plan cost to manufacture a product or purchase a component. It determines material costs by multiplying BOM quantities by the standard price, labor costs by multiplying operation standard quantities by plan activity price, and overhead values by costing sheet configuration.

Cost Object

An SAP Cost object such as a cost center or internal order describes where the cost occurs. A cost element or account describes what the cost is.

Costing Lot Size

The costing lot size in the Costing 1 view determines the quantity cost estimate calculations are based on. The costing lot size should be set as close as possible to actual purchase and production quantities to reduce lot size variance.

Goods Issue
A goods issue is the movement (removal) of goods or materials from inventory to manufacturing or to a customer. When goods are issued, it reduces the number of stock in the warehouse.

Goods Receipt

It is a goods movement that is used to post goods received from external vendors or from in-plant production. All goods receipts result in an increase of stock in the warehouse.

Component Scrap

Component scrap is the percentage of component quantity that does not meet required quality standards before being inserted in the production process. The plan quantity of components is increased. Component scrap is an input scrap because it is detected before use in the production process. You plan component scrap in the MRP 4 view and the Basic Data tab of the BOM item. An entry in the BOM Item field takes priority over an entry in the MRP 4 view.

GRIR

SAP Goods Receipt Invoice Receipt performs a three-way match between the purchase order, goods receipt and invoice receipt.

You use the GR/IR clearing account to record the offset of the GR and IR.

Internal Order

An internal order monitors the costs and revenue of an organization for short- to medium-term jobs. You can carry out planning at a cost element and detailed level, and budgeting at an overall level with availability control.

Material Master

A material master contains all of the information required to manage a material. Information is stored in views, and each view corresponds to a department or area of business responsibility. Views conveniently group information together for users in different departments, for example, sales and purchasing.

Origin Group

An origin group separately identifies materials assigned to the same cost element, allowing them to be assigned to separate cost components. The origin group can also determine the calculation base for overhead in costing sheets.

Profitability Analysis

Profitability Analysis enables you to evaluate market segments, which can be classified according to products, customers, orders (or any combination of these), or strategic business units, such as sales organizations or business areas, with respect to your company's profit or contribution margin.

PA Transfer Structure

A PA transfer structure allows you to assign costs and revenues from other modules to value and quantity fields in Profitability Analysis.

Price Control

The Price control field in the Costing 2 view determines whether inventory is valuated at standard or moving average price.

Price Unit

The price unit is the number of units to which the price refers. You can increase the accuracy of the price by increasing the price unit. To determine the unit price, divide the price by the price unit.

Process Order

Process orders are used for the production of materials or provide services in a certain quantity and on a certain date. They allow resource planning, process order management control, and account assignment and order settlement rules to be specified.

 

Join us at SAP Controlling Financials Conference:

Meet Paul Ovigele and other SAP expert speakers in-person:

Use coupon code: JJ100 to save $100: click here

×
Join our Exclusive Members

For the latest updates

Controlling 2013 Speaker Profile: Julien Delvat
Controlling 2014 Speaker Profile: Martin Munzel, S...
 

Comments 1

Guest
Guest - Elanthendral on Wednesday, 11 May 2016 11:56

I like your collection, thanks for sharing this wonderful collection of themes with us.i am working in Erp In Chennai

I like your collection, thanks for sharing this wonderful collection of themes with us.i am working in Erp In Chennai
Already Registered? Login Here
Guest
Monday, 04 December 2023

Captcha Image