SAP CO-PA (Profitability Analysis)
SAP CO-PA (Profitability Analysis): In order to sustain and thrive in this contemporary and dynamic environment rapid and timely decision making is more essential then to make right decision.Organization profitability is one the core parameter to assess when it come to designing organization goals, objectives and strategies to achieve them. In this blog, I am going to discuss the tools incorporated in SAP ERP to analyze organization profitability.
The two useful tools provided by SAP to analyzed profitability of an organization are Profitability Analysis (CO-PA) and Profit Center Accounting (EC-PCA).
Mention below are the usage of both applications,
Profit Center Accounting (EC-PCA) | Profitability Analysis (COPA) |
If an organization wants to analyze its internal Profits and loss department wise or as per different areas within your company, then its is recommended to used Profit center accounting. | CO-PA is used to help organization to analyze its profitability as per market segments by extracting sales, profit/loss and cost related data from other modules like SD , Production and MM. |
EC-PCA can be used by companies in any branch of industry (mechanical engineering, chemical, service industries and so on) and with any form of production (repetitive manufacturing, make-to-order manufacturing, process manufacturing).
The profit-relevant data is displayed by period. Profit Center Accounting uses Period accounting and Cost-of-sales accounting. |
CO-PA can be used by companies in any branch of industry (mechanical engineering, wholesale and retail, chemical, service industries and so on) and with any form of production (repetitive manufacturing, make-to-order manufacturing, process manufacturing).
The data can be analyzed by period, or by order or project. Profitability Analysis uses Cost-of-sales accounting method. |
In EC-PCA we structure the units which we want to evaluate as Profit centers. You can create profit center according to region ( branch offices, plants) function (production, sales), or product (product ranges, divisions). | The market segments are structured like product, customers, orders , other characteristic and Organization units such as company codes or business area wise.It support management in decision making by provided in-depth reports from market oriented viewpoint
Customer+ Product= Market Segment (niche marketing) |
Periodic Accounting Vs Cost of Sales Accounting (Perpetual Accounting)
In Period Accounting, WIP Offset and Change in inventory account is used to calculated Inventory Changes in Balance sheet. The COGM and COGS is not calculated here since the expenses are not segregated so the production cost is not easily identified. The inventory is calculated through formula,
Inventory Changes in B/S = Opening Inventory – Ending Inventory (Physical Count)
In Cost of sales accounting, we segregate all expenses at time of entry functional area/department wise like Production, Sales and Marketing and Research and Development. So,here cost of Function area “Production” is our COGM. COGS is calculated through formula,
COGS = (Opening Inventory – Ending Inventory (Physical Count)) + COGM (Production Functional Area Cost)
The figure below illustrates the example of Period Accounting and Cost of Sales Accounting,
Account based Vs Costing based CO-PA
Profitability Analysis is one the most vital and valuable functionality provided by SAP Controlling module. It helps the management to analyze it Profitability from various dimension, develop its strategy and make decisions by collecting and analyzing all the useful data from other functions like, Material Management, Sale and Distribution, Production and Finance.
There are two types of CO-PA in SAP and we can used the both of these types simultaneously,
1- Account based CO-PA
In account based CO-PA, COGS is recorded in CO-PA at the time of billing in SD along with revenue generated from Invoice document generated here.
2- Costing based CO-PA
In case of Costing based CO-PA, the COGS is directly extracted from the Sales and distribution module through condition type ‘VPRS’.
The below figure shows the flow of data from other modules in both types of CO-PA,
Chart below shows the difference between the Costing Based and Account Based CO-PA,
Account-Based PA | Costing-Based PA |
Account-Based PA uses cost and revenue elements | Costing-Based PA uses Value fields to group cost and revenue elements. |
No reconciliation issues | Reconciliation issues : Reconciliation between FI and COPA. Delivery: In SD COGS is updated in FI immediately but not in COPA during post good issue. Billing: During billing COPA is updated with COGS and revenue Due to above reason reconciliation issues arouses when delivery is done in one period and billing is done in a different period as CO-PA updates the COGS during billing not at delivery. |
Incoming Sales Order data cannot be mapped in account based CO-PA | Incoming Sales Order data whose delivery for period is not yet taken place would be in transfer through SD Condition types to analyze anticipated sales |
Cost component split is not possible | COGS can be split in to cost components |
Variance analysis not possible | Variance analysis is possible |
Uses standard tables EC-PCA COEJ : Actual COEP : Planned COSS/COSP : segment Level Only below table is generated, CE4xxxx : segment table |
Following tables are generated with operating concern. CE1xxxx : actual line item table CE2xxxx : plan line item table CE3xxxx : segment level CE4xxxx : segment table |
Incoming Sales Order data whose delivery for period is not yet taken place would be in transfer through SD Condition types to analyze anticipated sales with record type A. | Incoming Sales Order data cannot be mapped in account based CO-PA. |
Below figure shows the two different Profit and Loss statement constructed through using account based and costing based CO-PA,
CO-PA Simplifications in S/4 HANA
Previously in ECC, costing based CO-PA is recommended as it has more advantages over account based CO-PA. Now in S4 HANA third generation platform, most of the advantages of costing based COPA is combined with account based CO-PA. We can construct Profit and loss statement with contribution margin calculations now in account based CO-PA.
Now in S4/ HANA, most of the benefits of Costing based CO-PA is included in Account based CO-PA. that why it is recommended to use Costing based CO-PA in S4/ HANA.
The chart below shows the pros and cons of account based vs costing based CO-PA in S4/ HANA,
Account based CO-PA | Costing based CO-PA |
Costs and Revenue elements are used to transfer data from FI to Account based CO-PA. Same as before. |
The Value Fields are used to mapped the costs to the of G/L accounts and SD condition types etc. |
No reconciliation problem. FI and Account based CO-PA both are reconciled in S4 HANA as before. At the time of delivery, COGS is recorded in CO-PA. At the time of billing, revenue and discount is recorded in CO-PA. |
Reconciliation is not guaranteed in S4 HANA. Example, if the delivery took place in one period and its billing is done in next period then at the time of billing the COGS is transferred to CO-PA |
Cost Component split data can be sent to costing based CO-PA which is not possible in ECC. | Cost Component split data can be sent to Costing based CO-PA as before |
Variance Analysis which was previously possible only for total Variance in Account based CO-PA, now is possible to analyze by variance category wise as in costing based CO-PA. |
Variance analysis according variance category is possible same as before |
Incoming Sales Order data cannot be mapped in account based CO-PA. | Incoming Sales Order data whose delivery for period is not yet taken place would be in transfer through SD Condition types to analyze anticipated sales with record type A. |
Absorption Costing Vs Variable Costing
In the field of accounting, variable (direct) costing and absorption (full) costing are two different methods of applying production costs to products or services. The difference between the two methods is in the treatment of fixed manufacturing overhead costs.
Under the direct costing method, fixed manufacturing overhead costs are expense during the period in which they are incurred.
Under the full costing method, fixed manufacturing overhead costs are expense when the product is sold.
The figure below illustrates the structure of Absorption and Variable costing method,
CO-PA Organization Structure
In order to used functionality of CO-PA (Profitability Analysis), the operating concern must be create which is highest hierarchical unit in combined FICO module. The structure and assignment of operating concern, controlling area and company code is shown in the figure below,
The Operating Concerns contains the list of characteristics and value fields,
Characteristic:
Characteristic defines the level at which you see the report. e-g; company code, sales area , customer and product. Following are the types of characteristics in CO-PA,
Fixed Characteristics: When we generate an operating concern there are some fixed characteristic which already generated in operating concerns.
e-g; Product, Company Code and sale area etc.
Predefined Characteristics: We can include more characteristics in an operating concern. These characteristics are already present in the field catalog and explicitly added to operating concern.
e-g; Sales Employee and Material group.
Customer -defined Characteristics: In field catalog we can also defined our own characteristics and from there we include them in our Operating Concern.
Profitability Segment Characteristics (Segment-Level Characteristics): Profitability segment is a unique combination of selected characteristics. i-e; Only the characteristics selected for the setting will be used in profitability segments as shown below.
T-Code: KEQ3
Example;
Char | Description | CostBased+AcctBased |
ARTNR | Product | X |
KNDNR | Customer | X |
ProdA / Customer 1 = Proft seg 1
ProdB / Customer 1 = Proft seg 2
ProdA / Customer 2 = Proft seg 3
Value Field (Costing based CO-PA):
Value Field (only for Costing based CO-PA) defines the key figure you want to see in the report. It can be either an amount or a quantity field. Example, if you want to see customer wise revenue/ cost of sales / profit. Here customer is the characteristic and revenue/ cost of sales / profit are the value field.
VV010 Revenue,
VV030 Customer discount,
VV100 Outgoing Freight,
VV130 Internal sales commission,
VV140 COGS,
VV150 Material Input,
VV250 Mat OH,
VV400 Production costs,
VV700 Sales Quantity,
VVIQT Invoiced Quantity,
Flow of Actual Data
In costing based CO-PA, the data is transferred and recorded by the record types. The figure below illustrates the record types for the different transactions in costing based CO-PA.
Record type | Description |
B | FI –> CO-PA |
C | CO –> CO-PA IO settlement to CO-PA MM Production Variances |
F | SD Billing Data |
A | Incoming Sales Order |
CO-PA Integration with Sales Order Management
Transfer of Sales and Distribution Billing: (T-Code: KE41)
Assignment of SD condition to value field. Sales and distribution data is directly transfer CO-PA using SD condition types mapping with CO-PA value field without valuation,
Transfer of Incoming Sales Order (T-Code: KE41):
Assignment of SD condition to value field. Sales and distribution data is directly transfer CO-PA using SD condition types mapping with CO-PA value field without valuation,
The activation of data transfer for Incoming orders would be done at following transaction,
- Activation on the Entry date
- Transfer with the delivery or planned settlement date
Direct Posting from FI/MM (T-Code: KEI2) :
If the company want to transfer the cost of training for specific Product e-g; sedan cars only, then it has to create and assign profitability segment sedan cars while making FI general ledger posting of training cost to Prof. segment field in FI transaction (FB50).
If we want to post to dual cost object like cost center and profitability segment, in that case the profitability segment is the real object and cost center is statistical.
Similarly, as in case of FI direct posting, the characteristic found in the financial document generated from Material Management module updates the profitability segments in CO-PA module. e-g; price difference, transfer inventory difference and expense from revaluation of materials.
To transfer actual data from FI/MM to costing based CO-PA, we need to do define PA transfer structure in which we define source cost elements to target CO-PA value field as shown in figure below,
Transfer of Overhead
Order and Project settlement (T-Code: KEI1) :
To transfer actual data from Order or Project to costing based CO-PA, we need to do define PA transfer structure as in case of posting from FI/MM, in which we define source cost elements to target CO-PA value field and assigned that PA transfer structure to settlement Profile of an order/project as shown in figure below,
Assessment Cycle in CO-PA (T-Code: KEU1):
If we want to allocate any costs from cost centers like Marketing Cost center to the any CO-PA characteristic like product e-g Sedan cars we use assessment cycle to allocates costs. The Assessment cycle contains number of segments, which describes the receivers, senders, assessment cost element, CO-PA value field/ PA transfer structure and tracing factors as shown in the figure below,
Assessment costing element we assign in segment is to used to record cost on receiver profitability segment in account based CO-PA. While the CO-PA value field or PA transfer structure assigned in segment is used for costing based CO-PA.
Allocating Process in CO-PA (KEU1):
Notice that here you transfer the valuated process quantities and not the activity type quantities as with cost centers.
When you create the process allocation, you can specify a profitability segment as the receiver by selecting the Profit segment field. Then, when you press ENTER, the system displays a dialog box in which you can specify the characteristic values to which you want to allocate the process.
The process quantity is then valuated using the planned price for that process and credited to the cost center as actual data with the allocation cost element that was assigned to the relevant business process.
In account-based CO-PA, the costs are debited with the same allocation cost element. For costing-based CO-PA, you need to assign this allocation cost element to the required value field in the PA transfer structure CO.
Transfer from Cost Object CO/ Production Order variances (KEI1):
After the completion of Production order/ Process or at the end of period we calculate production variances and settle it to accounting as well as CO-PA through allocation structure (for accounting) and PA transfer Structure (for CO-PA) as shown in figure below.
The PA transfer structure consists of one or more lines called assignment lines. In these lines we define the source cost element group and variance category for a value field of the operating concern.
All Cost elements can either group into a cost element group or we can define a number of groups for materials, internal activities, business processes, and other overhead costs elements.
The cost component of the standard cost estimate is linked to value fields. So, make sure that current standard cost estimate is selected for valuation in CO-PA. Also, the variance flag must be selected in settlement profile assigned to relevant Production Order.
Note: Only Target variance in version “0”, is settled to CO-PA.
Top Down Distribution for Actual Data:
Top down distribution of actual data is a periodic function that enables you to distribute this aggregated data to extensive levels, such as the division level or the customer level in CO-PA, based on reference information, such as the data from the previous year.
In case of information like revenue, sales deduction and COGM which are entered at extensive level like customer/ Product. Some information like freight invoices or insurance expense can only be entered at summarized level at company code or sale organization level which is needed to be distributed to extensive levels like Product/ Customers in order to generate report or analyze profitability at segment level. This splitting of summarized costs would be done through Top Down distribution.
CO-PA Characteristic Derivation
Derivation supplements or overwrites certain automatically mapped characteristic values.
A derivation strategy is a sequence of steps, where each step uses one derivation technique to calculate one or more values for one or more characteristics, respectively.
Some derivation steps are created by the system at generation time, of which some are modifiable.
Example;
Char | Description | CostBased+AcctBased |
ARTNR | Product | X |
KNDNR | District | X |
Prod A / District North = Proft seg 1
Prod B / District North = Proft seg 2
Prod A / District South = Proft seg 3
Prod B / District South = Proft seg 4
Now, for above Profitability segments we do characteristic derivation like,
Segment 1: Sedan car in North
Segment 2: Hatchback car in North
Segment 3: Sedan car in South
Segment 4: Hatchback car in South
CO-PA Valuation
Valuation is optional functionality in costing based CO-PA which is used to extract or calculate additional information in CO-PA which is not available at the time of data transfer to CO-PA.
A valuation strategy can contain CO-PA costing sheets, Sales Order Management pricing procedures (in planning), product costing calls, and user exit calls, in a sequence that can be customized.
Example:
Sale deduction like commission, cash rebates which are not available in the invoice and calculated in CO-PA as provision. Special direct costs like transporting and packaging are also calculated or provisioned in CO-PA.
Valuation Strategies and Techniques
The various valuation techniques that populate the value fields in different ways are:
1- From Product Costing, cost components are mapped to value fields.
2- With costing sheets, condition types are mapped to value fields.
3- Value fields are updated directly through user exits.
Valuation using Material Cost Estimates:
Through valuation, the product cost estimate information for CO-PC can be transferred into CO-PA, through cost component values. This function is used, so that cost-of-sales can be analyzed extensively in CO-PA and multiple margin values can be calculated and analyzed in CO-PA.
With Out valuation | COGS/COGM is determined from Material master standard price
Cost component split is not possible |
With Valuation | Without ML/Actual Costing: COGS/COGM is determined from Planned cost estimate
Cost component split is possible |
With ML/Actual Costing: COGS/COGM is determined from Actual cost estimate
Cost component split is possible |
In configuration, cost components are mapped to value fields. Each component can be map to its own value field or multiple components to a single value field.You can also map the fixed and variable portions of a component to separate value fields.
Valuation using Costing Sheet :
The SD condition types are mapped with the CO-PA value fields to fetch the data of sales at the time of SD billing. It is an real time valuation which took place at the time of actual transaction and document with record type F is generated in costing based CO-PA during billing. The two condition type mainly use are base condition type and calculation condition type
Base condition types form the basis of calculation and assigned to the value field which is populated through other means.
Calculation condition types is populated through calculations on the lines in the costing sheets that represents subtotals of amounts, such as base amount. These condition types actually populate the value fields with values.
References:
https://archive.sap.com/discussions/thread/613570
https://archive.sap.com/discussions/thread/1939416
https://archive.sap.com/discussions/thread/613570
https://archive.sap.com/discussions/thread/1939416#
SAP CO-PA (Profitability Analysis)