Re : How to configure report painter

[Former Member]

hii kings

could u tell me how to create report . what are the steps require to report painter. In that what is the purpose of Library , how is create the same. We can report Create report Under the library sothat which purpose.

[Former Member]

Hi Ramu,

Check out this link for report painter

http://www.virtuosollc.com/PDF/Get_Reporter.pdf

Assign points if useful

Regards

Genie

[Former Member]

Hello

Process Flow

Selecting and maintaining a library for your report.

As the transfer structure to Report Painter you use a report table, which is defaulted by SAP and can not be maintained. This table contains characteristics, key figures and predefined columns. In a library, you collect the characteristics, key figures, and predefined columns from the report table, which you need for your Report Painter reports.

When you define a Report Painter report, you assign it to a library. Reports assigned to one library can only use the characteristics, key figures, and predefined columns selected for that library.

When you create or maintain a library, the Position field determines the sequence in which the characteristics, key figures or (predefined) key figures appear in the Report Painter selection lists when you define a report. This allows you to position the objects that you use regularly in your reports at the beginning of the selection lists. If you do not make an entry in the Position field, you will not be able to use this object in Report Painter reports.

You can use either the standard SAP libraries for your reports or define your own.

Selecting or maintaining a standard layout for your report.

Standard layouts determine report layout features and the format of your report data.

If the SAP standard layouts do not meet your reporting requirements, you can create a new standard layout or change an existing one.

Defining row and column models.

A model is a one-dimensional, predefined reporting structure that you can insert in either the rows or columns of your report.

If you often use the same or similar row or column definitions in your reports, it is recommended that you create row or column models.

You must define the row and/or column models that you want to include in your report definition before you define the report.

You can also use the standard column models supplied by SAP.

.

Defining the report.

Defining a Report Painter report involves the following steps.

Define the report columns

You define the report columns using the characteristics, key figures, and predefined columns selected for the library that the report uses. Alternatively, you can use a column model for column definition. Column models are predefined column structures which you insert into your entire column definition, instead of defining each individual column.

Define the report rows.

You define the report rows using the characteristics selected for the library selected for the report.

Alternatively, you can use a row model for your row definition. Row models serve the same purpose as column models, but are used to define a report row.

Edit and format the report rows and columns in line with your requirements. (For example, you can hide rows or columns, define the column width or define colors for your report rows).

Define general data selection criteria for the selection of your report data.

Selection criteria are the characteristics used to select data for the entire report. You cannot enter characteristics as data selection criteria if they are already being used in the report rows or columns.

Assigning the report to a report group.

Once you have defined a report, you must assign it to a report group. A report group can contain one or more reports from the same library. However, reports that share the same data will select data more quickly and improve processing time.

You can assign a Report Painter report to a report group containing Report Painter and Report Writer reports.

Generating the report group.

During this step, the system generates the programs necessary for processing the reports.

When you generate a report group, Report Painter reports are converted to Report Writer format. However, you can only change or display Report Painter reports using the Report Painter tool.

Executing the report group.

Report execution involves the selection and output of all the database records used in the report.

Once the system selects records according to the online selection criteria, it outputs the report data in the format defined for the report in question.

Regards

[Former Member]

Hi,

now i will send it steps

Report Painter

Key Features of Report Painter

Prepare Plan/Actual/Variance Expense Report

Cost Elements Actual Plan Variance

Salaries Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx

Office Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx

Travel Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx

Supplies Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx

Total Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx

Use the following account numbers and descriptions in your report:

Account number Description

430000 Salaries

470000 Office

474100 Travel

476000 Supplies

Create a new report.

Menu Path: Information Systems > Ad hoc reports > Report Painter > Report > Create

On the Report Painter: Create Report screen, enter:

Library – 1VK

Report RSS-A

Report Description – Report w/Total Row

Hit <Create> button to move to the next screen.

Create the Rows of the Report – The first four rows are cost element characteristics

Screen: Report Painter: Create Report

Type ‘Cost Elements’ in the lead column cell

Double click on Row 1

In the Pop-up window 'Element definition: Row1", enter:

Note: If Pop-up window (select element type) appears, choose 'characteristics' and hit <Enter>.

Select 'Cost Element' as the characteristic in the 'Available characteristics' section

Hit <Move selected to left> button to move the characteristic 'Cost element' to the 'Selected characteristics' section

From – 430000

Hit <Change short, middle and long texts> icon (at the bottom of the window)

In the Pop-up for Enter Texts, Enter:

Short – Description from Table above for this Account

Click on the <Copy short text> button to copy this description to the other fields.

Hit <Confirm> to close the Pop-up

Hit <Confirm/Enter> to check consistency and close.

Repeat the above steps for the other 3 accounts

Create a formula row to calculate the total of the Cost Element rows

Screen: Report Painter: Create Report

Double click on Row 5 or the next empty row.

In the Pop-up for Select Element Type select 'Formula'

Hit <Enter> to close the Pop-up

In the Pop-up 'Enter Formula'

Use the calculator buttons to create the formula Y001 + Y002 + Y003 + Y004

Hit <Enter> to close the Pop-up

In the Pop-up 'Enter Texts'

Short – Total

Click on the <Copy short text> button to copy this description to the other fields.

Hit <Enter> to close the Pop-up

Make sure your cursor is in the cell containing the word ‘Total’

Follow the Menu Path: Formatting > Row

In the Pop-up 'Row Formatting'

Over score – checked

Underscore – checked

Hit <Enter> to close the Pop-up

Create the first column for actual costs

Screen: Report Painter: Create Report

Double click on the ‘Column 1’ cell.

In the Pop-up 'Select element type'

Select Predefined Key Figure radio button, and press <Enter>.

In Pop-up 'Choose predefined column'

Select Actual Costs as the predefined column, and press <Enter>.

In the Pop-up 'Element definition: Actual costs'

Press <Confirm> to check consistency and close.

Define the second column for plan costs

Screen: Report Painter: Create Report

Double click on the ‘Column 2’ cell.

In the Pop-up 'Select element type'

Select Key Figure with Characteristics as the element type, and press <Enter>.

In the Pop-up 'Element definition: Column 2'

Value Type – 01 (Plan)

Version – 0 (Actuals)

Valuation – 0 (Legal valuation)

Hit <Change short, middle and long texts> icon

In the Pop-up for Enter Texts, Enter:

Short – Plan

Click on the <Copy short text> button to copy this description to the other fields.

Hit <Confirm> to close Pop-up.

Hit <Confirm> to check consistency and close.

Create a formula column to calculate the variance between actual and plan costs

Screen: Report Painter: Create Report

Double click on the ‘Column 3’ cell

In the Pop-up 'Select element type'

Select Formula as the element type, and press <Enter>.

In the Pop-up 'Enter Formula'

Use the calculator functions to create the formula X001 – X002.

Hit <Confirm> to close the Pop-up

Enter Variance as the text for all three fields.

Hit <Enter> to close.

Define the parameters for general data selection

Screen: Report Painter: Create Report

Follow the Menu Path: Edit > Gen. data selection

In the Pop-up 'Element definition: General data selection'

Select Controlling Area, Cost Center, Fiscal Year, and Period as the selection characteristics

Hit <move selected to left> icon to move the selected characteristics to the selected characteristics section of the window

Enter the following values for your characteristics:

Controlling area – RSS ('from' field)

Cost center - 1000 to 2000

Fiscal year - Current year

Period - 1 to 12

Hit <Confirm> to check consistency and close.

Check the report for any errors and save it

Screen: Report Painter: Create Report

Follow the Menu Path: Report > Check or press < Shift + F6>.

When the system comes back with a message of ‘No errors were found’, click <Save> to end.

Assign the report to a report group using the function in Report Painter

Screen: Report Painter: Create Report

After the system has come back with ‘Report RSS-A was saved’

Follow Menu Path: Environment > Assign report group

On the Insert Report in Report Group Screen:

Enter Z0#A as the group

Hit <Enter>

In the 'Create report group' pop-up window

Click <Yes> to create the group

Make sure the system has come back with ‘Report RSS-A was saved in Report Group Z0#A’.

Execute the report

Screen: Report Painter: Create Report

Follow the Menu Path: Report > Execute

Notice that there are no selection criteria to enter. These were hard coded in the general selection characteristics.

Click the <Execute> icon.

It is a very basic report of plan, actual, and variance costs for a group of predefined cost centers.

it's useful assigne points as a way to say Thanks

Regards

gvr