Reporting Tools in SAP

SAP Query,
InfoSet Query (Ad Hoc Query)
QuickViewer

You can create InfoSets from various data sources , including logical databases, tables, table joins, and so on. The best business practice is to use the SAP delivered logical databases as your data source, because they were created for this purpose and there is at least one logical database delivered with your system for each module within SAP, including Accounting, Personnel Management, and so on. The F1S database used in this example is the training database that SAP uses in its training classes based on a fictional airline scheduling system. It is best to use this database for your test cases.

In contrast to using SAP Query and InfoSet (Ad Hoc) Query, you do not need to configure User Groups and InfoSets to use QuickViewer. However, if they have already created, you can use them. Users simply select a data source (table, database view, table join, logical database, or InfoSet) when building their QuickView.

Both Report Painter and Report Writer can be used to report on the following tables and tables types:

-- Evaluation structures set up in the Logistics Information System (LIS). These structures normally begin with an "S" or "ZF." Several different tables and views within the R/3 System can be added as evaluation structures.
Note: You cannot add cluster tables, such as BSEG.
--CCSS is used for Cost Center Accounting (CO-CCA), Internal Orders (CO-OPA), Activity Based Costing (CO-ABC) and for cost element reports in Project Systems (PS).
--GLFUNCT is used for functional area reporting in cost-of-sales accounting.
--GLPCT and GLPCOP are used for Profit Center Accounting (CO-PCA/EC-PCA).
--FILC is used for Legal Consolidations (FI-LC).
--COFIT is used for the Controlling Reconciliation Ledger (CO-CEL).
--ZZ tables are created for the Special Purpose Ledger (FI-SL).
--FIMC is used for consolidations in the Enterprise Controlling module (EC-LC).
--GLT0 is used for Financial Accounting (General Ledger) reports by account, company, and business area (FI-GL).
--KKBC, KKBE, and KKBU are used for the Controlling Product Costing module (CO-Costing).

Report Writer
Set types:
Basic sets , Single Dimension sets,Predefined column , Multi-dimensional sets

Mali İşler-->Maliyet muhasebesi veKontrol -->MasrafYeriMuhasebesi--> BilgiSistemi --> Araçlar --> Report Painter

Report Painter
Library

Library determines the following in report painter report:

Table that can be used in the report
Charaterstics that can be used in the report
Key Figures that can be used in the report
Basic Key Figures that can be used in the report

In order that the Report Writer can report on a specific database table, it must be entered in the control table T804A. The database table must not exist as a physical table, but can also be defined as a logical table in the Report Writer (table T804E), and contain several physical tables.

Peki library için tablo nereden yaratcaz??

The Table is the standard structure based on which you will be creating your Library and report.

The Report Writer can only report on tables if the attributes of these tables that are relevant for reporting are defined in control tables.

You should be able to make a Data Dictionary table available to Report Painter / Writer if you can create an Evaluation structure for the table .

To create an Eval structure In Logistics :
Tcode MCS7 - Create evaluation Structure.
(Path: Logistics >Sales & Distribution >Sales Info System >Flexible Analysis >Evaluation
Structure >Create)

You could name the Eval Structure "ZF*****", (must begin with "ZF").
Then click

( if this is a table and not another Eval structure.)

Enter the DD table "******". And click the check mark.
Then click and mark all the characteristic fields you want to report on, (if
you right click
you can select), then .
Do the same for
Then generate the Eval structure or

After you created the Eval structure, you can create a library with this Eval structure (table) in it.

http://www.sapdb.info/wp-content/uploads/2008/08/report_painter.pdf