Profitability Analysis (CO-PA) End User material explain in step by step manner with screenshots, how to do transaction.
Profitability Analysis (CO-PA) End User document will help you understand how to run transactions in SAP and complete your business process.
In this document set we cover following transactions Master Data
S_ALR_87005722 Maintain Plan Version Planning
KE1E Transfer Planned Quantity from PA to SOP KE1V Transfer Plan Data from PA to PCA
KE13N Upload COPA Offline Planning KE28 Top Down Distribution
KEPM Sales Planning Reporting
KE21S Simulate Valuation
KE24 Line Item Display Actual Data KE25 Line Item Display Plan Data KE30 Execute Profitability Report
S_ALR_87005722 - Maintain Plan Version Functionality
In this step you define the CO versions you want to use for your operating concern. These versions are valid for all of CO and for all operating concerns.
In Profitability Analysis, you can only use versions for plan data. Consequently, the fields "Actual" and "Exclusive use" are not relevant for CO-PA.
Each version has attributes, which are only valid for one operating concern. The attributes determine the following:
Whether you can plan a version
The Version locked indicator lets you lock a plan version so that no more changes can be made to it.
Which currency type should be used to store the data in this version
If, alongside the operating concern currency, the company code currency or the profit center valuation is also active in your operating concern, you need to specify the currency type for each version.
Which exchange rate should be used to translate foreign currencies to the local currency
In planning, the system always tries to derive values for the characteristics, which you do not specify. Since these derivation rules are time-dependent, you can specify which date the system should use when it performs derivation.
Scenario
Create plan version 4. Requirements Operating Concern
Menu Path Accounting Controlling Profitability Analysis Planning Current
Settings S_ALR_87005722 - Maintain Plan Versions
Transaction Code S_ALR_87005722
Double click on S_ALR_87005722 - Maintain Plan Versions. General Version Definition
Click the New entries button. Update the following fields:
Field Name Field Description Values
Version Number key identifying plan version Example: 4
Name Description of the Name. Example: Plan Version 4 Click the checkbox in the Column Plan to select it.
Click the checkbox in the Column Variance to select it. Click the Save button.
Select the 4 line and click the Settings in operating concern button.
Confirm transfer from version
Click the Yes button.
Change View "Settings in operating concern": Details
Update the following fields:
Field Name Field Description Values
Exch.rate type Exchange rate type that will be used for currency translation.
Example: P
Derivation date Date for derivation of characteristics in planning. Example: 01.01.2002 Click the checkbox of the Check derivation to select it.
Click the Enter button.
Click the Save button. The message bar displays “Plan version saved” KE1E - Transfer Planned Quantity from PA to SOP
Functionality
You can transfer the sales quantities either by individual products or by product groups. You can use any profitability segments (for example, all products in a division) and time frames (posting periods and weeks) as selection criteria.
You can transfer a sales plan more than once, since the sales volumes are overwritten in SOP with each transfer. If you select the Transfer changes only field, you can ensure that only the changes are transferred when you have made changes to a CO-PA sales plan.
Scenario
Transfer Planned Sales Quantities to SOP for: Company Code 5200
Plant 5200 Requirements
Plan data were entered into CO-PA.
Menu Path Accounting Controlling Profitability Analysis Planning Integrated
Planning KE1E - Transfer Quantities to SOP
Transaction Code KE1E
Double click on KE1E - Transfer Quantities to SOP. Transfer Plan to SOP: Initial screen
Update the following fields:
Field Name Field Description Values
From period Entry field for beginning period and year. Example: 001.2002 To Entry field for the last period and year of the transfer. Example: 012.2002
Version Plan version (CO-PA) enables you to keep two or more sets of data for the same object. You can maintain and evaluate several plan versions at the same time.
Example: 0
Record type Record types in CO-PA tell you what type of business transaction the data transferred to CO-PA comes from.
Example: F
Version Version in SOP, a sales quantity plan can be stored in different versions. One of these versions is always 'active'.
Example: 099
Click the Enter button.
Click the Selection criteria button. Transfer Plan to SOP: Selection criteria
Update the following fields:
Field Name Field Description Values
Company Code Code identifying the company. Example: 5200 Plant Code identifying the plant in which product is produced. Example: 5200
Click the Enter button. Click the Execute button. Transfer to SOP: Log
Click the Back button.
Transfer Plan to SOP: Initial screen
Note: You can transfer a sales plan more than once, since the sales volumes are overwritten in SOP with each transfer. If you select the Transfer changes only
field, you can ensure that only the changes are transferred when you have made changes to a CO-PA sales plan.
If you are satisfied with the results, repeat the same process in Production mode by deselecting the Test run checkbox.
Click the Back button to go back to SAP Easy Access screen. KE1V - Transfer Plan Data from PA to PCA
It is possible to transfer planned values and quantities periodically from costing-based
Profitability Analysis (CO-PA) to Profit Center Accounting. To do so, you need to assign the value and quantity fields in CO-PA to the accounts in Profit Center Accounting. You can define rules in Customizing to derive the correct account in EC-PCA.
Scenario
Transfer PA plan for 812W LLDPE to PCA. Company code 1000; and Plant 1000. Requirements
In addition, plan data must exist for combinations of profit center, controlling area, and company code in costing-based CO-PA. Note that when no profit center is found for a posting to CO-PA, the system automatically assigns that posting to the dummy profit center. Plan data that is not assigned to a specific controlling area and company code cannot be transferred to EC-PCA.
Menu Path Accounting Controlling Profit Center Accounting Planning Plan Data
Transfer KE1V - Costing-based CO-PA
Transaction Code KE1V
Double click on KE1V - Costing-based CO-PA. Transfer to EC-PCA: Initial screen
Update the following fields:
Field Name Field Description Values
From period From Period Example: 001.2002
To To Period Example: 012.2002
Version Plan version, relevant for Co-PA planning
Example: 2
Record type Relevant record type: billing document. Example: F (Billing)
Click the Processing instructions button to select what Characteristics should be retained, and which should be summarized.
Click the Value fields button ot select the value fields you want to transfer to PCA. Note that these value fields should have been defined in the derivation rules of the accounts numbers.
Transfer to EC-PCA: Value fields
Click the Revenue . and the Sales quantity. checkboxes to select them.
Click the Selection criteria button. To select what are the criteria for the transfer.
Update the following fields:
Field Name Field Description Values
Profit Center Profit Center of the material plan to be transferred Example: 4101 Click the Execute button.
Transfer to EC-PCA: Log
Click the Back button.
If you are satisfied with the results, repeat the same process in Production mode by deselecting the Test run checkbox.
Click the Back button to go back to SAP Easy Access screen.
KE13N - Upload of COPA Offline Planning Functionality
The Excel template created in Customizing can be copied as often as required and used to create planning data in Excel. By using the uploading function for Excel, you can transfer the individual files into the SAP system. This means that planning data can be entered into different PCs, local planning thereby being possible.
Scenario
Upload Sales Plan file under the name “SALES.TXT”. Requirements
The file name adheres to the generic file name, so that it can be assigned to the file description correctly.
Menu Path Accounting Controlling Profitability Analysis Planning Integrated
Planning Upload from Excel KE13N - Execute
Transaction Code KE13N
Double click on KE13N – Execute. Flexible Upload
Update the following fields:
Field Name Field Description Values
Operating concern A unique four-character key for the CO organizational unit operating concern.
Example: 1000
Type of Profitability Analysis
Costing-based Profitability Analysis and/or account-based Profitability Analysis.
Example: 1
Press [F4] or Click the Search button in the Path or file field. Select the SALES file in list box.
Click the Open button. Flexible Upload
Click the Execute button. Flexible Upload
Note: If there are problems in the upload, make sure that the “Totals” line in the text file to be uploaded is deleted (last line).
Click the Back button. Flexible Upload
Click the Back button to go back to SAP Easy Access screen.
KE28 - Top-Down Distribution Functionality
In Profitability Analysis: sales revenues, sales deductions and costs of goods manufactured are generally stored at the customer/product level. However, many business transactions - such as freight invoices, insurance expenses, or advertising - cannot easily be assigned to such a detailed level in CO-PA. Consequently, these need to be posted at a summarized level, such as the division, sales organization, or company code level.
Top-down distribution of actual data is a periodic function that lets you distribute this
aggregated data to more detailed levels in CO-PA on the basis of reference information (such as the data from the previous year).
Scenario
Distribute Custom Clearance posted to Company Code/Product/Plant to Customer/Country. Requirements
You use costing based Profitability Analysis.
Menu Path Accounting Treasury Profitability Analysis Actual Postings
Period-End Closing Periodic Adjustments KE28 - Top-Down Distribution
Transaction Code KE28
Double click on KE28 - Top-Down Distribution. Top-Down Distribution: Initial screen
Update the following fields:
Field Name Field Description Values
From period Beginning period of actual values to be distributed
Example: 10.2002
To The last period of actual values to be distributed
Example: 10.2002
Record type Type of business transaction the data transferred to CO-PA comes from.
Example: F
From period Beginning period of reference data. Example: 10.2002 To The last period of reference data. Example: 10.2002 Record type Type of business transaction the data
transferred to CO-PA comes from.
Example: F
Click the Test run checkbox to deselect.
Click the Processing instructions button. Top-Down Distribution: Processing instructions
Note: Set the radio button for characteristics that you want to distribute in “Dist” column.
Click the Customer radio button.
Click the Country radio button.
Click the Selection criteria button. Top-Down Distribution: Selection criteria
Note: Select the characteristic values that you want to distribute. Update the following fields:
Field Name Field Description Values
Company Code Code identifying the company. Example: 1200
Click the Value fields button.
Click the Deselect all button.
Note: Select the Value fields that are to be distributed.
Click the Cost-Customs Clear checkbox. Top-Down Distribution: Value fields
Click the Check button to check that there are no errors in the set-up of the top distribution.
Click the Execute button. Top-Down Distribution: Log
Click the Back button.
Top-Down Distribution: Initial screen
KEPM - Sales Plan Functionality
The automatic planning method Copy allows you to copy existing reference data to data area specified by the selected planning package. Reference data can be, for example, the actual data from the previous year or planning data from a different or the same plan version. You can use the copied data as the basis for planning, for example, and then change it by applying other planning methods.
Scenario
Copy Sales Plan from the year 2002 to 2003. Requirements
Reference data in year 2002 exist.
Menu Path Accounting Controlling Profitability Analysis Planning KEPM -
Edit Planning Data
Transaction Code KEPM
Double click on the KEPM - Edit Planning Data. Planning Framework: Overview
Click on the DSP Button to expand the structure. Planning Framework: Overview
Double click on the DSP2003 Button to display planning methods. Planning Framework: Overview
Click on the Copy Button to expand the structure. Double click on the Copy Button to start coping. Planning framework: Information
Click the Continue Button . Planning Framework: Overview
Click the Upd. run Button .
Planning Framework: Overview
KE21S - Simulate Valuation
Functionality
To test valuation in detail or to run a detailed analysis of errors, you can simulate valuation for the different points of valuation. The screen that appears matches that for manual line item entry, but no values are posted.
From this screen, you can use the valuation analysis described above, as well as the separate condition and access analyses.
Thus you can test various valuations without actually posting SD billing documents e.g. Material cost estimate for cost of goods sold when qty of sales is entered.
Scenario
Simulate the valuation of a Manual Planning entry (version 0), for material 20000239 and plant 1200.
Operating concern environment is active.
Menu Path Accounting Accounting Controlling Profitability Analysis Tools Analyze Value Flows KE21S - Simulate Valuation
Transaction Code KE21S
Double click on KE21S - Simulate Valuation. Valuation Simulation CO-PA: Initial Screen
Update the following fields:
Field Name Field Description Values
Posting date Posting date Example: 11.11.2002
Record type Type of business transaction: billing (record type 'F') or incoming sales orders (record type 'A') in Sales and Distribution (SD), allocation of cost center costs (record type 'D'), and settlement of orders or projects (record type 'C').
Example: F
Pt. of valuation Profitability Analysis recognizes four points of valuation: 01 Real time valuation of actual data; 02 Periodic valuations of actual data; 03 Manual planning; 04 Automatic planning.
Example: 03
Version Plan version Example: 0
Valuation Simulation CO-PA
Update the following fields on the Characteristics tab:
Field Name Field Description Values
Company Code Code identifying the company. Example: 1200
Product The Product. Example: 20000239
Plant Code identifying the operational unit of the company where the material is manufactured and stored
Example: 1200
Click the Value fields tab button. Valuation Simulation CO-PA
Update the following fields on the Value Field tab:
Field Name Field Description Values
Sales quantity The planned sales quantity. Example: 10
Unit Unit of measure. Example: TO
Click the Enter button.
Click the Valuation button. Valuation Simulation CO-PA
Note: As a result of the valuation, value fields will be populated with figures if there was a cost estimate available for the material. This is in the case of Manufacturing Affiliates, but in the case of Non-Manufacturing Affiliates, no breakdown of cost will be available, where materials will be valuated based on the future price in the material master.
Tip: To analyze valuation steps in detail way click the Analyze valuation button.
Click the Back button to go back to the SAP Easy Access screen.
KE24 - Line Item Display - Actual Data CO-PA Functionality
In this report you can display a specific amount of line items in the line item list. The line item list is especially useful for displaying characteristics that you do not use for creating profitability segments and that you have deactivated accordingly in Customizing. In costing-based Profitability Analysis, these characteristics are still filled in the line item and hence listed in the line item list.
Scenario
Report of all line items coming from billing documents for the whole year 2002 must be prepared.
Requirements None.
Menu Path SAP menu Accounting Controlling Profitability Analysis
Information System Display Line Item List KE24 - Actual
Double Click on KE24 – Actual
Display Actual Line Items: Initial Screen
Update the following fields:
Field Name Field Description Values
Currency type Code identifying the currency in CO-PA, i.e. ‘B0’ Operating Concern Currency
Example: B0
Record type Record type, i.e. ‘F’ Billing document Example: F
Period/year Period/year, 0MM.YYYY Example: 001.2002
to To Period, 0MM.YYYY Example: 012.2002
Click Layout .
Choose layout (1) 1 Entry found
Display Actual Line Items: Initial Screen
Click .
Display Line Items
Click <tab button> Value fields . Display Line Items
Click <tab button> Origin data . Display Line Items
Click <tab button> Administrat.data . Display Line Items
Integration: Selection of Transactions
Click Display Sales Order .
Click Button .
Display Sales Order 401: Overview
Click Button ‘Document flow’ Document Flow
Click .. Invoice 90000193 / 10 Button .
Click Display document Button .
Invoice 90000193 (F2) Display: Overview of Billing Items
Click Accounting Button . List of Documents in Accounting
Click 777 Button .
Note: Now you are displaying the same CO-PA document '777' from side of a Billing Document. According to document flow you made a circle.
Display Line Items
Click Back
List of Documents in Accounting
Click Cancel Button .
Click Back Document Flow
Click Back
Click Back . Display Line Items
Click Back .
Click Back .
KE25 - Line Item Display - Plan Data CO-PA Functionality
In this report you can display a specific amount of plan line items in the line item list. Scenario
Report of all line items coming from billing documents kept in the version ‘Plan version: change 1’ for the whole year 2002 must be prepared.
Requirements None.
Menu Path SAP menu Accounting Controlling Profitability Analysis
Information System Display Line Item List KE25 - Plan
Transaction Code KE25
Double click on KE25 - Plan
Update the following fields:
Field Name Field Description Values
Currency type Code identifying the currency in CO-PA, i.e. ‘B0’ Operating Concern Currency
Example: B0
Record type Record type, i.e. ‘F’ Billing document Example: F Version Three-digit number which represents the version
of the forecast parameters as defined in the forecast profile
Example: 1
Period/year Period/year, 0MM.YYYY. Example: 001.2002
To To Period, 0MM.YYYY Example: 012.2002
Click Layout .
Choose layout (1) 1 Entry found
Display Plan Line Items: Initial Screen
Click the Execute button. Display Plan Line Items: List
KE30 - Execute profitability report Functionality
In this transaction you can analyze your profitability data in drilldown reporting. Execute a report that has been defined in accordance with your requirements.
Scenario
You are supposed to prepare profitability report for Company Code 5200 for the whole year 2002, according to profit center hierarchy. After execution of the report a currency of the report must change from USD to SAR.
Prerequisites None.
Menu Path SAP menu Accounting Controlling Profitability Analysis
Information System KE30 - Execute Report
Transaction Code KE30
Double Click on KE30 - Execute Report. Run Profitability Report: Initial Screen
Select the ZSAI1001 tree view node – choose report appropriate for your requirements. Click the Execute button.
Update the following fields:
Field Name Field Description Values
Company Code Organizational unit in FI that represents business entity.
Example: 5200
From Period.Year From Period.Year, 0MM.YYYY Example: 001.2002 To Period.Year To Period.Year, 0MM.YYYY Example: 012.2002
Click the Execute button.
Click the Product field in the Navigation Section to move this characteristic to the right section and break the data according to the Product.
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Customer field in the Navigation Section to move this characteristic to the right section and brake the data according to the Customer.
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the button to move back the first characteristic into Navigation Section. Click the button to move back the second characteristic into Navigation Section. Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Total line to highlight it.
Click the Details button to change the layout of the report. Key figures from columns are moved into lines.
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Customer field in the Navigation Section to move this characteristic to the right section and brake the data according to the Customer.
Click the Customer button to switch between different Customers. Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Product field in the Navigation Section to move this characteristic to the right section and brake the data according to the Product.
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Product button to switch between different Products. Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Product button to switch between different Products. Click the button.
Click the Back button.
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Switch Drilldown Characteristic
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click Button .
Currency Translation: All Columns
To-currency (1) 185 Entries found
Select the SAR - Saudi Riyal in list box. Currency Translation: All Columns
Click Translation key Button .
Select Default for drilldown reporting in list box.
Click the Execute button.
Execute Drilldown Report "SAI Revenue/Expenses": Drilldown List
Click the Back button. Exit Report
