SAP Controlling Information System

SAP Controlling Information System has some good reporting tools.Several totally different reporting tools are used in the Controlling Information System. Every report device has its personal options and range of applications.Report Painter permits you to create reports using data from CO and different R/3 application parts, which you may give you the option to adapt to satisfy your particular person requirements. Lots of your reporting necessities can already be met through the use of the usual studies supplied by the various CO utility components. If these standard experiences don't meet your reporting wants, Report Painter lets you define your specific stories rapidly and easily.Report Painter fulfills a perform much like Report Writer, but is much less complicated to use. A lot of the capabilities present in Report Writer have been built into Report Painter; however, you wouldn't have to be familiar with all Report Author concepts (such as Units) in order to use Report Painter.Drill down reporting is used in Profitability Analysis (CO-PA) and in Product Value Controlling (CO-PC).



This reporting software makes use of characteristics to categorize transaction data. Controlling area, company code, buyer, product group, order, and product are examples of characteristics. The time reference (fiscal 12 months, period) is also a characteristic. Key figures represent specific values of the categorized data. Examples of key figures include direct prices, gross sales, sales deductions, variety of employees, and sales quantity. You'll find a way to carry out calculations with key figures to derive values such as gross sales per worker and contribution margin.

The ABAP Checklist Viewer standardizes and simplifies the operation of lists within the R/3 System. It is used for line item reporting all through CO. A uniform interface and record format is available for all lists. It contains handy features for the dynamic creation of show variants. Utilizing show variants, you may change the format of your list. You may select fields to be added to the display, change the order of the fields, and modify the column width to suit your requirements.

Report Selection

Data is evaluated in Controlling by means of reviews which are provided in the standard system or that you define yourself.You select stories within the information system utilizing the report tree. The report tree comprises all reviews in an utility organized in a hierarchical tree structure.
There's a separate normal report tree in each software area in Controlling. The standard experiences for each utility space are assigned to the nodes of the related report tree. Along with the report tree in the standard system, you can also outline your personal report tree to which you'll give you the option to assign both commonplace reports and your own reports.

Report Writer

In addition to normal reports, you can too use Report Painter and Report Writer to define your own reports. You may then add these customized studies to your reporting tree.Within the interactive information system, you probably can evaluate posted knowledge immediately after its entry into the SAP R/3 System, and comply with its origins all the way down to the document level. Each Report Painter and Report Author reports offer a variety of options to display, kind, filter, and summarize the data.Report Painter has related capabilities to Report Author, but is simpler to use. A lot of the features of Report Author have been integrated into Report Painter, however generally have been designed to be extra intuitive and finish-user oriented.Report Painter experiences will be edited through the use of Report Author, but can then not be maintained by Report Painter. Report Author experiences can't be modified by Report Painter. While you use Report Painter to create your personal studies, you outline the report column and row construction and general information selection. Report Painter can entry the data out of an extract, immediately out of the info base, or out of an archive.The variation characteristic makes it doable to create an individual report for every element of a bunch that you defined within the basic information selection. For example, you presumably can create a person report for the total summary node and every group node in a price center hierarchy.

All studies accessible on-line will be executed within the background at predefined times. This could be significantly helpful throughout a process equivalent to interval-finish reporting, where a number of stories are executed for various customers all through the organization. This characteristic means that you just can process massive quantities of data in periods of lower system use.



Total Values and Line Items

Within the R/3 System, a distinction is made between line gadgets and totals records. These are recorded in separate database tables.A line merchandise is entered for each business transaction. You'll have the option to access these line objects utilizing the line item report.For reporting, all the line objects entered for business transactions are mechanically saved in totals records . The amounts are totalled in the R/3 System based on the price middle/cost component or value center/cost component/exercise type and permits information to be evaluated extra quickly. You may analyze the totals data using a Report Painter/Report Writer report.Usually, you'll analyze a value center using a Report Painter report. For those who require detailed data for particular price components posted to the cost heart, you can call up the corresponding line items.The line item report shows the actual prices, plan costs or commitments as line items and as primarily based on the posting documents. This information is displayed as an inventory (output listing display).

Interactive Information System

You ought to utilize the interactive data system to total and analyze all, or chosen enterprise transactions, in response to varied standards (for example, cost middle / cost ingredient).The totals data within the Report Painter report are usually analyzed, however typically the road gadgets from the summary report are also chosen and examined. You might also move from the road items to the corresponding supply documents. The supply doc may be an FI doc, or for example, an accounting doc from a re posting.You'll be able to call up other studies utilizing the Report/Report interface.

User Settings

You can specify general and consumer-particular default values for the selection standards, and the report currency. The benefit of person settings is that more than one, or all values that you just normally want to enter before executing a report group are routinely displayed. Once you name up a report, the R/3 system checks to see in case you have made all the required entries. If that's so, then the report might be executed without any entries required within the choice screen.You presumably can enter the next default values:

1. Primary data (controlling space, value heart, or price heart group, cost aspect, and so on)
2. Settings for extract management
3. Planning time frame
4. Reporting time frame
5. Report foreign money
6. Other specs, equivalent to, the version

Line Item Report

The R/3 system provides you with standardized show variants. You can define extra variants for global or consumer-specific use.You can select as many fields as required from the group of accessible fields (together with customer specific fields) for a display variant that's enterprise-specific.You want to outline the merchandise (column) within the report, and the column width for each field.Relying on the column width, the R/3 system robotically uses the quick textual content or long text from the sector name. It also uses your log-on language if this is accessible for the report.You presumably can select an ascending or descending type sequence for each column.You presumably can outline filters for every column. Rows that fulfil filter standards usually are not displayed. However, they are included in the totals and subtotals calculation.You'll find a way to outline totals interactively, by selecting a column after which totals. It's potential to select multiple column at a time.

In drilldown reporting you can summarize information in response to the characteristics, after which drill down interactively. At each level of the report, you can display the drilldown list (overview) or detailed data (margin evaluation).The features of drilldown reporting are divided into three ranges in an effort to give each user solely those capabilities that he or she requires.Stage 1 comprises the fundamental functions of drilldown reporting, plus it permits you to send reports by SAP mail.This degree is designed for users who do not require the full performance of drilldown reporting.Degree 2 accommodates the rest of the drilldown functions, plus it enables you to display graphics and download stories to Microsoft Excel.All capabilities affords you all of the capabilities in drilldown reporting, together with the print setup function and the functions for saving report knowledge and defining exceptions. This level is designed for customers who must print and modify reviews in addition to all the interactive drill down functions.

Data Source

For those who save reports in extracts , then you may have sooner access to the info saved. Report extracts for groups assist navigation in the group with the "Variation" function.It is attainable to select data from the database to create an advert-hoc report with probably the most present information.It is usually possible to learn from archive data. Reports are used for offering archived information.To create extracts, you may select Create extract earlier than you run the report, or you'll have the ability to choose Yes on the dialog box that appears when you exit the report. The selection parameter and the time of the report definition mechanically characterize the extract.In Extract Management in customizing, you specify the user-specific settings for the data access.The following options are supplied for this:

1. New choice : The system re selects the info and doesn't use existing extracts for the specified selection criteria.
2. Show extract :If current extracts fulfill the choice standards, then the R/3 system displays them in a dialog box for selection. If not one in every of the extracts fulfill the criteria then the R/3 system uses the current data records.
3. Automatic display of the present extract :The R/3 system automatically displays probably the most present extract. You probably can display all the extracts in an summary, or you'll give you the option to print or delete them, or change the expiration date .

Using the Report Painter

The Report Painter functionality is utilized in a quantity of completely different areas of Controlling.The Report Painter is used to create and execute experiences in the Overhead Value Controlling, Product Value Controlling, and Revenue Middle Accounting components.The performance of Report Painter is also utilized within the definition of planning layouts in Overhead Value Controlling, Profitability Analysis, and Revenue Center Accounting.Drill-down reporting additionally makes use of Report Painter functionality in the definition of forms.Forms are utilized in drill-down reporting within the Product Value Controlling, Profitability Evaluation, and Revenue Middle Accounting areas of Controlling. A kind determines the content and formal construction of a report. A form will be regarded as a semi-completed report, which you complete by specifying (further) characteristics and key figures when you define the person report. The content material of a type is generally fastened and changes only below rare circumstances. Once you change a type, it impacts each report that makes use of that form.


RELATED POSTS

SAP Controlling and daily processing 
SAP Financial and Controlling Overview 
SAP Controlling Information System 
SAP Financial Company Organization 
Customizing SAP Controlling 
Creating General ledger accounts in sap controlling
Creation of customer and vendor accounts
SAP Controlling Event Based Posting
SAP Financial Payment Cards
SAP Financial and Controlling Overview
SAP Financial Profit Center Analysis 
SAP Financial Information System
SAP Financial Legacy Data Transfer