what is report painter in sap CO

 REPORT PAINTER

Report to view customer wise/product wise /Sales organization wise /plant wise profitability

Define forms for profitability reports :

Path :SPRO-Controlling –Profitability analysis –Information system –report components –Define forms –Define forms for profitability reports-(The Tr code is KE34)

Double click on creation Form 

Give the operation concern form :AML

Form description                     : From AML profitability

Select two axes (matrix) radio button

Select create button

Select operating concern currency radio button

Enter

Double click on row 1

Select value field with characteristics radio button

Enter

Value field select VV010 – Revenue

Select confirm button

Double click on row 2

Select value field with characteristics radio button

Enter

Value field select VV140 –cost of goods sold

Select confirm button

Double click on row 3

Select formula radio button

Enter

Select Y001

Select minus button

Select Y002 cost of goods sold

Enter

Short text Net profit

Select copy short text button

Enter

Double click on column 1

Select characteristics radio button

Enter

Select plant /Actual indicator for available characteristics

Select left arrow

For plant /actual indicator

From :Select 0 actual data 

Select confirm button

Save

From the menu select Edit-General data selection

Once again general data selection

From the available characteristics column

Select record type, period /year

Select left arrow

For record type

For form column :Select B direct posting from FI

For To column :Select F billing data

For period /year : For from column :Select variable on /off check box

Local variable              :Enter 1

Press enter

For to column select variable on/off check box

Local variable              :2

Enter

Select confirm button

From the select Extras –variables –variable definition

For name 1      : Give the description from period /year

For name 2 Description           :To period /year

Enter & save

Create profitability report:

Same path

Double click on crate profitability report

Tr code is KE31

Give the report            :BILREPORT ( This is a text field)

Description                  :BIL Profitability Report

Select report with from radio button

Give the form name    :BIL1

Select create button

Select operating concert currency radio button

From the characteristics list :Select customer /plant /product ,Sales organization

Select left arrow

Select output type tab

Select classic drill down radio button

Select available on selection screen check box

Save

Ignore the message press enter

Select execute button

Form period/year         :01.2008

To period /Year           :12.2008

Execute

Ignore the message select press enter

To view product wise profitability from the menu select navigate-with drill down

Double click on product

This called date cube