SAP CO Profitability Analysis Transaction Codes

SAP CO Profitability Analysis Transaction Codes

KE30

Execute profitability report

VALU

Valuation Analysis

KE21N

CO-PA Line Item Entry

KE24

Line Item Display - Actual Data

KEDR

Maintain Derivation Strategy

KEPM

CO-PA Planning

KEB0

Create CO-PA DataSource                                                                              

KE4I

View maintenance VV2_T258I_V

KEU5

Perform act. cost-ctr cost transfer

KEA0

CO-PA: Maintain Operating Concern

KE4U

Maintain view cluster V_TKEVAx

KEPH

Segment-Specific Events

KEA5

Maintain Characteristics

KE4S

Post billing documents to CO-PA

KEPC

Flexible Callup of Cost Estimates

KEI1

Maintain PA Transfer Structure

KE31

Create profitability report

KES1

CO-PA Maintain Characteristic Values

KE4J

Maintain view V_TKEVA03M

KEQ3

Maintain Charact. for Segment Level

KEB2

Display Dtld Info on CO-PA DataSrce

KE4W

Reset value fields

KEAT

Reconcile CO-PA <-> SD <-> FI

KE4R

Maintain view V_TKEVA04

KE3I

CO-PA: Transport tool

KE35

Change form

KEFC

CO-PA External Data Transfer

KE27

Periodic valuation

KEI2

Maintain PA Transfer Structure

KE28

Create top-down distribution

KE34

Create form

KE4M

Maintain view V_T258M

KEND

Realignments

KE13N

Upload from Excel

KE4SFI

CO-PA: Post Subsequently from FI

KE32

Change Report

KE4ST

Simulation billg docs transfer CO-PA

KE11

Change plan data

KE4G

Maintain View V_TKEVG

KEPA

Char. Groups for Actual and Planning

KE40

Maintain view V_TKEVA03

KECM

CO-PA: Customizing Monitor

KEDE

Maintain Derivation Rule Entries

KEKE

CO-PA: Activation Indicator

KEU1

Create Actual Transfer of CCtr Costs

KE26

Repost Accounting Document

KE21

Create CO-PA line item

KE94

Create form

KEDV

CO-PA: Maintain Summarization Levels

KES3

Maintain Characteristics Hierarchy

KEKF

Transfer Incoming Sales Orders

ORKE

Display CO-PA IMG

KER1

Maintain Key Figure Scheme

KE4H

Maintain view V_TKEVA03A

KEUB

Perform plan cost-ctr cost transfer

KE29

Management

KEA6

Edit Value Fields

KE29N

Administration: Logs

KE25

Line Item Display - Plan Data

KEB5

Reduce Data Volumes for Test

KE4S00

CO-PA: Reversal of Line Items

KE1E

Transfer Plan Data to SOP

KE3E

Maintain Global Variables

KE1C

Delete Plan Data

KE4IM

Maintain View VV_T258I_M

KEDU

CO-PA: Build Summarization Levels

KEPP

Check plan structure

KE37

Maintain Report Authorization Object

KE41

Create condition

KEVFG

CO-PA Value Field Groups

KE4MS

Assign CO-PA Standard Quantity

KE1V

Transfer to EC-PCA

KE91

Create Line-Item-Based Report

KEDVP

Default for Summarization Levels

KE33

Display Report

KE4F

Post Incoming Orders Subsequently

KEU2

Change Actual Transfer of CCtr Costs

KE3Q

Maintain Variants

KEVG2

Assign Characteristic Group

KE4T

Set Up Transfer of Incoming Orders

KE3P

Maintain Variant Groups

KE4SMM

CO-PA: Post Material Documents Subs.

KE3R

Schedule Variant Group

KE23N

CO-PA Line Item Display

KE3S

Define Variant Group

KEBC

Change operating concern

KEI3

Maintain PA Transfer Structure

KEAW

Reconciliation Make-to-Order Prod.

KE14

Create Planning Layout

KE1F

Complete Plan Management

KE1FN

Admin.: Logs for Overall Planning

KEN1

Maintain Number Range: COPA_IST

KEKK

Maintain view V_TKA01_ER

KE21S

CO-PA Valuation Simulation

KE13

Upload from Excel

KE23

Display CO-PA line item

KETE

CO-PA: Operating Concern Templates

KEN2

Maint. number ranges: CO-PA planning

KES2

Customizing: Display characteristics

KE3B

Print and actualize reports

KE4TS

Simulate Doc. Transfer from Orders

KE36

Display form

KE4Z

Maintain view V_T258Z_KE

KEF1

Change Revaluation Keys

KE4E

Maintain View V_T258W_KE

KEFA

Maintain Sender Structures

KEG5

Execute Indirect Actual Acty Alloc.

KEP8

Operating concerns

KE4D

Maintain external str. in ABAP Dict.

KE16

Display Planning Layout

KEFB

Maintain Rules

KEB1

CO-PA Hierarchy DataSource

KE1N

Display Plan Structure

KE1Z

Transfer CO-PA Plan Data to GL (New)

KEVG6

PA Transfer Schema: Overhead ACTUAL

KEB3

Activate Debugging Support

KEBD

Set Operating Concern

KECRM_0KEL

PCA: Substitutions CRM Integration

KE12

Display plan data

KE17

Maintain Planning Authorization Obj.

KEB4

Debugging Support Hierarchies

KE42

Change condition

KEDZ

Read Interface for CO-PA Log

KE15

Change Planning Layout

KEDB

Deletion of Test Data in CO-PA

KE3Y

Report selection

S_ALR_87005722

IMG Activity: SIMG_CFMENUORKEOKEQ

KE43

Display condition

GLPLI

FI-SL Create Planning Layout

KE4A

Change condition table

KE2B

Correction to Incoming Orders

KEV2

Change distribution key

KEOV

CO-PA: Cycle Overview

KEMO

Profitability report: Test monitor

KECP

Copy Operating Concern

KE45

Maintain View V_T258I_KO

KEUG

Set up cost-center cost transfer

KE1D

Forecast Plan Data

KE39

CO-PA: Reorganize report data

KE97

Maintain Report Authorization Object

KEPI

Maintain Rule Values for Revaluation

KE1A

Copy complete plan

KED0

Derivation: Initial Screen

KEV1

Create distribution key

KE4Q

Execute Pricing Report

KE27S

Reversal of KE27 Delta Line Items

KE1K

Transfer to LIS

KEU6

"Actl Transfer of CCtr Costs

KE1B

Process complete plan

KE4L

Pricing report

KEIT

CO-PA Allocation: Table Information

KE2C

Delete records from error file

KEFD

Maintain Rules

KEPMU

Create Planning Level from Layout

KE0C

CO-PA Distribution: Initial Supply

KE38

Display report authorization objects

KEP6

Maintain characteristics

KE1T

Change Forecast Profile

KEU4

Delete Actual Transfer of CCtr Costs

KE96

Display Form

KE2D

Display Error File

KEII

CO-PA Assessment: Field Usage

KE1I

Maintain Ratio Scheme

KEDW

CO-PA: Fill Summ. Levels (Expert)

KETR

CO-PA Translation Tool

KE3J

Import

KE2K

CO-PA: Maintain Key Figures

KEAI

Value Flow FI -> SD / CO -> CO-PA

KEPV

Plan Settlement: Assign Version

KEIM

CO-PA Allocation: Field Group Texts

S_ALR_87005759

IMG Activity: SIMG_CFMENUORKEKE40

KE4SCRM

Subsequent.Post CRM Billing to CO-PA

GLPLD

FI-SL Display Planning Layout

KE1W

Transfer of CO-PA Plan Data to FI-GL

KELV

BW/CO-PA Ret: Variant Query Variable

KELR

BW/CO-PA Retraction: Execute

KELS

BW/CO-PA Retraction: Cancel

SAP MATERIALS: Check List for FI Year End Closing

SAP MATERIALS: Check List for FI Year End Closing

Check List for FI Year End Closing

Check List for FI Year End Closing

  1 Execute Report for InterCompany Activity & Journal Entries
  2 Open posting period for next yr
  3 Run Business Area's Assignment report.
  4 Review list of recurring journal entries
  5 Execute Recurring Entries for A/R, A/P, G/L
  6 Process Parked A/R, A/P, G/L accounting documents
  7 Final Cutoff for the Maintenance of Fixed Asset- Add Transfer and Retire
  8 Run Depreciation in Test Run and post
  9 Verify Display Log for Depreciation Test Run
10 Capitalize AUC Assets if needed
11 Enter Payroll Data to SAP
12 Verify Depreciation Balances  with GL balances
13 Post Depreciation
14 Execute Asset History Report, and retire assets if needed
15 Adjust specific depreciation areas if necessary
16 Reconcile AM subledger with GL
17 Check Bank Data
18 Review AR Open Items
19 Review AP Open Items
20 Execute Pending Invoices
21 Clear Open Item for GRIR, freight
22 Reconciliation of Financial Documents and transactional figures
23 Open new CO Posting Period
24 Compare current  (cost estimates) with last current price (Moving Avg)
25 Update current cost price to material master price field.
26 Process Freight charges, Match SD freight to actual
27 Review Internal Order Postings
28 Settle All Orders
29 Verify All Post Goods Issue have been Invoiced (Billing Due List)
30 Review SD Billng Doc from prior mth that have not yet been released to accounting
31 Reconciliation of MM movements in Transit Intra-SAP to NonSAP
32 Reconcile PI Inventory with SAP
33 Perform Manual Adjustment if needed
34 Verify balance of the GR/IR account
35 Post Accruals and Deferrals
36 Clearing of Cancelled Documents
37 Check Profitability Segment Adjustment
38 Aging Report-Reconcile GL balances with  subledger  balances AP
39 Check the check run numbers
40 Bank reconciliation Data
41 Enter Tax Journal Entry
42 Reconcile GL balances with  subledger  balances AR/MM/AP
43 Display Balance Sheet Adjustments
44 Post Balance Sheet Adjustments
45 Post Foreign Currency Valuation (foreign exchange)
46 Check generic cost centers for posting with wrong accounts
47 Correct wrong postings on generic cost centers
48 Check Validation dates for Cost Centers, Cost Elements, CO area
49 Check COGI--for both month end and year end
50 Doubtful receiviables
51 Verify In-transist Inventory
52 Reconcile PA to G/L
53 Post Cost Centre Assessments and Distributions
54 Run CO-FI Reconciliation to balance
55 Run BW reports P&L and Balance Sheet
56 Maintain CO yr variant
57 Fiscal Yr Balance carryforward AP/AR/AM
58 Fiscal Yr Balance carryforward CO
59 Fiscal Yr balance carryforward FI
60 Fiscal Yr balance carryforward PCA
61 Set Document number ranges - FI - new year
62 Set Document number ranges  AP/AR - new year
63 Generate Financial statement Reports
64 Change Fiscal Year For Assets
65 Year end Closing-- Asset Accounting--final for year end
66 Close CO Posting Period
67 Close Prior A/R Posting Period
68 Close Prior A/P Posting Period
69 Close Prior MM Posting Period
70 Reverse accruals and deferrals for the new month
71 Reconciliation of Financial Documents from old fiscal year and new fiscal year
72 Load Balances, Budget Data for Cost centers, sales
73 Update Retained Earning Account , balance carry fwd 

Profit Center Q&A

Profit Center

What is the basic purpose of creating a Profit Center?

The basic purpose of creating a Profit Center is to analyse the revenues

and costs for a particular product line, or a plant or a business unit.

Though you can generate balance sheets and profit and loss accounts

per Profit Center still a profit center should basically be used as a tool

only for internal reporting purposes.

If legally one has to produce the Balance sheets and Profit and Loss

Accounts for a profit center then it is advisable to create it as a company

code instead of a profit center

How does the cost and revenue flow to the Profit Center?

The profit center is stored in the cost center this way the costs flow to the

profit center.

The profit center is also stored in material master. This way all sales

orders created for the finished product automatically picks up the profit

center from the material master and all the revenues and costs coming

from this sales order for that finished product is passed on to this profit

center.

A profit center document is created in addition to the Finance document

whenever revenue or consumption takes place. This document contains

the details of the profit center.

Once both the costs and revenues flow to the profit center you can write

reports using the Report Painter to get intelligent analysis. You can also

use SAP standard reports

Statistical key figures are created in the cost center accounting

module. Now the same statistical key figures are required in the

profit center accounting module. Is it required to maintain the

statistical key figure in PCA module?

No. Since the statistical key figures are created in a controlling area.

Profit center is a sub module within controlling area. The statistical key

figure is created for the controlling area and as such is available in profit

center accounting module.

What are the precautions to be taken while maintaining the 3KEH

table for profit center accounting?

You should not maintain the customer and vendor reconciliation

accounts in the 3KEH table. Further you should also not maintain the

special GL accounts in this table. Since we are transferring the customer

and vendor balances to profit center module through separate month end

programs. If the reconciliation’s accounts are maintained here it will

result in double posting in the profit center module.

Should secondary cost elements be maintained in the 3KEH table?

No. Since here we maintain only those accounts for which the value

should flow from FI to PCA. Secondary cost elements are already defined

in the controlling module which will reflect in the postings in PCA also

How can the default settings be maintained for cost elements per

company code?

The default settings can be maintained in transaction OKB9. Here we

can specify for a company code, cost element which is the cost center to

be defaulted or whether profitability segment is to be automatically

derived. Further we can also maintain whether business area is

mandatory or profit center is mandatory and can maintain the default

business areas and profit centers.

What are the other important activities in Profit Center?

The assignments of profit center to the cost center and also assignment

of profit center to the material master is what will determine the success

of the Profit center posting. If these assignments are wrongly done then

the profit center postings will not come in properly.

Profitability Analysis Q&A

Profitability Analysis

Explain the organizational assignment in the PA module?

The operating Concern is the highest node in Profitability Analysis.

The operating concern is assigned to the Controlling Area.

Within the operating concern all the transactions of Profitability Analysis

are stored.

The operating concern is nothing but a nomenclature for defining the

highest node in PA.

What is the functionality of the PA module?

PA module is the most important module when it comes to analyzing the

results of the organization.

In this module you basically collect the revenues from the sale order , the

costs from the production order, cost center or internal order and

analyze their results.

The interesting part about this module is that when it collects the costs

and revenues it also collects the characteristics associated with the costs

and revenues and this is what makes it stand out

So for e.g. using PA module you can find out the following:

Profit of a certain product

Profit of a certain product in a certain region

Profit of a certain product in a certain region by a certain customer

Profit of a certain product in a certain region by a certain sales person

And the list can go on in depth

It is one of the most wonderful modules in the SAP

How do you get all those characteristics defined above and how do

you analyze them?

To do so while defining Operating concern one has to define

Characteristics and Value fields.

What are characteristics and Value Fields?

In the operating concern two things are basically defined

a) Characteristics

b) Value Fields

Characteristics are nothing but those aspects on which we want to break

down the profit logically such as customer, region product, product

hierarchy, sales person etc

Value Fields are nothing but the values associated with these

characteristics

Eg Sales, Raw Material Cost, Labour Cost, Overheads etc

Once you define the characteristics and value fields these values are

updated in the table.

From where does the characteristics come from?

The characteristics which are defined above basically comes from either

the Customer Master or the Material Master.

How does various values( revenues and costs) flow into PA?

The Sales Revenue comes from the Condition Type in SD.

We need to map the Condition Type in SD to the respective value fields in

customizing to have the revenue flow into PA.

The Cost comes from Cost estimates which are transferred using the PA

transfer structure which we have covered in the Product costing section.

The various cost components of the cost component structure is assigned

to the value field of PA module and this is how the costs come into PA.

Once the actual revenue and the std cost defined above are captured in

PA the variances are also transferred into PA.

This way the std cost variances equal the actual cost.

So actual revenue- actual cost helps us determine the profit.

How do you configure the assignment of variances from product

costing to COPA module?

The variance categories from product costing along with cost element is

to be assigned to the value fields in COPA

Once you have captured all the costs and revenues how do you

analyze them?

The costs and revenues which we have captured in the above manner are

then analysed by writing reports using the Report Painter Functionality

in SAP.

What is characteristic Derivation in Profitability Analysis Module?

Characteristic Derivation is usually used when you want to derive the

characteristics . An example of this could be say you want to derive the

first two characteristics of product hierarchy.

In such cases you define characteristic derivation where you maintain

the rules, which contain the table names of the product hierarchy fields

and the number of characters to be extracted, and it also specifies the

target characteristic field in PA.

What is the basic difference in customizing in Profitability analysis

as compared to other modules?

In PA when we configure the system i.e. creating operating concern,

maintain structures no customizing request is generated. The

configuration needs to be transported through a different transaction

called as KE3I.

What is the difference between Account based Profitability Analysis

and Costing based Profitability Analysis?

Account based Profitability analysis is a form of Profitability analysis (PA)

that uses accounts as its base and has an account based approach. It

uses costs and revenue elements.

Costing based Profitability Analysis is a form of profitability analysis that

groups costs and revenues according to value fields and costing based

valuation approaches. The cost and revenues are shown in value fields.

What are the advantages and disadvantages of Account based

profitability analysis vis-à-vis costing based profitability analysis?

The advantage of Account based PA is that it is permanently reconciled

with Financial accounting.

The disadvantages are that it is not powerful as the costing based PA,

since it uses accounts to get values. No Contribution margin planning

can be done since it cannot access the standard cost estimate. Further

no variance analysis is readily available.

The advantages of the Costing based PA are manifold. They are as

follows: -

· Greater Reporting capabilities since lot of characteristics are

available for analysis.

· This form of PA accesses the Standard cost estimate of the

manufactured product and gives a split according to the cost

component split (from the product costing module) when the bills

are posted.

· Contribution margin can be planned in this module since the

system automatically accesses the standard cost estimate of the

product based on the valuation approaches.

· Variance analysis is ready available here since the variance

categories can be individually mapped to the value fields.

Disadvantages:-

Since it uses a costing based approach, it does not sometime reconcile

with financial accounting.

Can both Account based and Costing based Profitability analysis be

configured at the same time?

Yes. It is possible to configure both types of costing based profitability

analysis at the same time.

What is the advantage of configuring both the type of Profitability

analysis together?

The advantage of activating account based profitability analysis along

with costing based PA is that you can easily reconcile costing based

profitability analysis to account based profitability analysis, which means

indirectly reconciling with Financial accounting.

Is there any additional configuration required for Account based

profitability analysis as compared to costing based profitability

analysis?

No. There are no special configurations required except for activating the

account based profitability analysis while maintaining the operating

concern.

What is the difference between Profitability analysis and Profit

center accounting?

Profitability analysis lets you analyze the profitability of segments of your

market according to products, customers, regions, division. It provides

your sales, marketing, planning and management organizations with

decision support from a market oriented view point.

Profit center accounting lets you analyze profit and loss for profit centers.

It makes it possible to evaluate different areas or units within your

company. Profit center can be structured according to region, plants,

functions or products (product ranges).

What configuration settings are available to set up valuation using

material cost estimate in costing based profitability analysis?

In Costing based Profitability analysis you define costing keys. A costing

key is a set of access parameters which are used in valuation to

determine which data in Product cost planning should be read. In the

costing key you attach the costing variant.

In the costing key you specify whether the system should read the

current standard cost estimate, the previous standard cost estimate or

the future standard cost estimate or a saved cost estimate.

The configuration settings to determine this costing key is as follows:-

1) Assign costing keys to the products – Three costing keys can be

attached to a single product for a specific point of valuation, record

type, plan version.

2) Assign costing keys to Material types

3) Assign costing keys to any characteristics – You can use your own

strategy to determine the costing keys. This is through user

defined assignment tables.