SAP FICO Profitability Analysis Plan and Actual Comparion

SAP FICO and in particular controlling wing ABAP report provides a contribution margin for divisions and products. Both actual and planned data list for the contribution margin, and a variance calculates for each value in it. This report summarizes revenues and contributions, and can do an in depth analysis of the margin for specific divisions or products.

A product line manager would use this report to monitor the performance of specific divisions and products and to identify the “bottom-line” impact of revenues and costs. Two features of this report, exception reporting and ranking, help to quickly identify both exceptional and marginal performers so that a product line manager can take immediate action to improve product performance.

You must set the Operating concern (but only when you first login). Choose Accounting → Controlling → Profitability analysis → Environment → Set operating concern. For the examples in this section, the operating concern is set to IDEA using cost-based profitability analysis.

All reports in profitability analysis are user-defined. This means you must configure and generate the operating concern before creating any reports and determine the rows, columns, variables, and general format by using drill down reporting (forms and reports).

Due to the configuration of this report, you must enter all selection options (that is, period range and fiscal year).

The profitability analysis line items which list are context sensitive. For example, when you position the cursor on a cell for a line item, only the reports that contain that line item show data. This improves performance of the report as a whole.

Once the original profitability analysis document appears, the original documents related to the line item may be retrieved. For example, from a sales document, a material master, customer master, billing document, and accounting document is available. From a direct financial entry, however, only the cost element and accounting documents are available. From settlement documents, the controlling object from which the settlement took place is generally available.

Two different views are available in this report:

1. Selected columns run across the report, while the characteristics (products, for example) run down the side.
2.All columns f or a single selected product show as rows for a contribution analysis.

You can analyze data using ranking lists, exception reporting, and sorting; list line items in the profitability analysis database; and access additional SAP data from this report.

This report contains data obtained from postings to cost-based CO-PA. As such, the data cannot be changed or manipulated from the report. Since cost-based—not account-based—CO-PA is used, value fields are used in the analysis instead of account numbers or cost elemets.

To access the first screen for this sap baap fico report, choose Information systems → Accounting → Profitability analysis Profitability report → Report selection.

From the reporting tree, choose the following report:

Plan- → Plan/Actual Comparison.

The initial screen looks like this in sap systems.
The numbers marked in the screen represent the following.

1. Enter 1 in From period and 12 in To period. This report will not provide a periodic breakdown of the costs, only totals for the period range.
2. Enter 1998 in From Fiscal Year. This report runs for only one fiscal year at a time.
3. Choose Execute.

The initial output of the report is as shown and each number of the output is explained as below.


The default sales organization number (for example, 1000) cannot be changed. Divisions show in rows. In this example, all postings were assigned to a division. If postings were not assigned to a division, Not assigned would appear in the last row.

Gross revenue and contribution margin data show in columns. For each of these values, planned and actual data appear, along with the absolute and percentage variances.

4. Double-click on the first division, Pumps. This screen shows the products within the Pumps division. Notice the breakdown of the Product characteristic as compared to the previous screen.
5. Choose Display to navigate to Division characteristic. This screen shows all Divisions.
6. Select the High Tech line.
7. Choose Enter.


Related Posts:

My sapcrm customers and consumer segmentation
Organizational challenges in crm and mysap solutions
Business View and Mysap.com
What is SAP R/3 introduction to mysap.com

No comments :

Post a Comment