Report Writer Reports 
Purpose
You use the Report Writer – in conjunction with the Report Painter – to create reports with the data in SAP Consolidation.
The Report Painter uses a graphic reporting structure, which is the basis for the report definition. While defining the report, you are able to see the structure of the report as it appears when the data is output.
Features
Note
You can use Report Writer reports in many SAP applications.
The following sections focus on the special features of Report Writer reports in SAP Consolidation.
For detailed information, see the SAP Library under
Accounting
Financial Accounting (FI)
Special Purpose Ledger (FI-SL)
Report Writer
You can use Report Writer reports to:
define reports
edit reports
execute reports using report groups
The following characteristics in SAP Consolidation are available for the reports:
Dimension, version, and ledger
Consolidation units, consolidation groups
Financial statement items and subitems
Fiscal years and periods
and so on
See also
Constraints
SAP Consolidation does not support multiple selections of data. Instead, you can use variations for the characteristics in the General Selection (see also: General Selections ).
Examples of Report Writer Reports in Consolidation
Example: Balance Sheet Changes
Report: |
Balance Sheet Changes, Assets |
||||
Consolidation Unit: |
CU1000 |
||||
Period/Fiscal Year: |
012/2000 |
||||
Assets |
Reported (Local) Value |
Standardizing Entries |
Elimination Entries |
Consolidated Value |
|
Inventory |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Accounts Receivable and Other Assets |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Securities |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Total Current Assets |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Unpaid Equity Contributions |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Intangible Assets |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Property, Plant & Equipment |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Financial Assets |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Total Fixed Assets |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Prepayments/Accruals |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
TOTAL ASSETS |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
XXX,XXX,XXX.XX |
|
Explanation:
The columns use the posting level characteristic.
The rows use a generated item set .
Example: Consolidated Income Statement of Business Areas
Report: |
Income Statement by Business Areas |
|||
Consolidation Group: |
CG1 |
|||
Period/Fiscal Year: |
012/2000 |
|||
Annual Net Income |
Net Sales |
Return (in %) |
||
Pest Control |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
|
Seeds |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Agriculture |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Dyes |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Industrial Chemicals |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Plastics |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Fine Chemicals |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Chemicals |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Baked Goods |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Beverages |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Soups |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Foods |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Cosmetics |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Pharmaceuticals |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Health Products |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
TOTAL |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX - |
XXX,XXX,XXX.XX |
|
Explanation:
The columns use financial statement items and a formula for the return.
The rows use a custom characteristic business area .