MIS reports

[Former Member]

How maby types of reports availabe in ABAP. what is mean by MIS reports

[Former Member]

Hi,

In ABAP, there are 2 kinds of reports are available:

1)Classical ( it is a plain report without any further drill downs ).

2)Interactive ( it is a report in which the user can drill down upto a level of 20 basic reports from the Basic report ).

Where as, an MIS report is like a reports done for the purpose of Management in making some key decisions in the Business...which is like takin Transactional data and making some Cleansing and etc., to make the data available in a form which will be useful for presenting in the form of a report to the Management... which is typically done using the BI ( Business Intelligence ) tools....

Thanks,

Vishnu.

[Former Member]

In ABAP, there are a total of 7 types of reports. They are:

Classical Reports

Interactive Reports

Logical Database Reports

ABAP query

ALV Reports (ALV stands for ABAP List Viewer)

Report Writer/Report Painter

Views (There are different types of views also)

Classical Reports

These are the most simple reports. It is just an output of data using the Write statement inside a loop.

Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT

Interactive Reports

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers.

And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21).

Logical Database Reports

Logical database is another tool for ABAP reports. Using LDB we can provide extra features for ABAP reports.

While using LDB there is no need for us to declare Parameters.

Selection-screen as they will be generated automatically.

We have to use the statement NODES in ABAP report.

ABAP Query Reports

ABAP query is another tool for ABAP. It provides efficency for ABAP reports. These reports are very accurate.

Transaction Code : SQ01

Report Writer / Report painter

Super users and end users can use Report Painter/Report Writer tools to write their own reports.

Giving them the ability to report on additional fields at their discretion shifts the report maintenance burden to them, saving SAP support groups time and effort normally spent creating and maintaining the reports.

ALV reports

Sap provides a set of ALV (ABAP LIST VIEWER) function modules which can be put into use to embellish the output of a report. This set of ALV functions is used to enhance the readability and functionality of any report output. Cases arise in sap when the output of a report contains columns extending more than 255 characters in length.

In such cases, this set of ALV functions can help choose selected columns and arrange the different columns from a report output and also save different variants for report display. This is a very efficient tool for dynamically sorting and arranging the columns from a report output.

The report output can contain up to 90 columns in the display with the wide array of display options.

There is no difference between drill down and interactive report, they are the same.

With drilldown reporting, SAP provides you with an interactive information system to let you evaluate the data collected in your application. This information system is capable of analyzing all the data according to any of the characteristics that describe the data. You can also use any key figures you wish to categorize your data. You can display a number of objects for a given key figure, or a number of key figures for a given object. In addition, the system lets you carry out any number of variance analyses (such as plan/actual comparisons, fiscal year comparisons, comparisons of different objects, and so on).

[Former Member]

MIS reports are nothing but report that contains Management Information system details.

In ABAP, there are a total of 7 types of reports. They are:

1.Classical

2.Interactive

3.Logical Database

4.ABAP query

5.ALV Reports (ALV stands for ABAP List Viewer)

6.Report Writer/Report Painter

7.Views (There are different types of views also)

1.Classical Reports

These are the most simple reports. Programmers learn this one first. It is just an output of data using the Write statement inside a loop.

Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.

Events In Classical Reports.

INTIALIZATION: This event triggers before selection screen display.

AT-SELECTION-SCREEN: This event triggers after proccesing user input still selection screen is in active mode.

START OF SELECTION: Start of selection screen triggers after proceesing selection screen.

END-OF-SELECTION : It is for Logical Database Reporting.

2.Interactive Reports

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers.

And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21).

Events associated with Interactive Reports are:

AT LINE-SELECTION : This Event triggers when we double click a line on the list, when the event is triggered a new sublist is going to be generated. Under this event what ever the statements that are been return will be displayed on newly generated sublist.

AT PFn: For predefined function keys...

AT USER-COMMAND : It provides user functions keys.

TOP-OF-PAGE DURING LINE-SELECTION :top of page event for secondary list.

3. Logical Database Reports

Logical database is another tool for ABAP reports. Using LDB we can provide extra features for ABAP reports.

While using LDB there is no need for us to declare Parameters. Selection-screen as they will be generated automatically. We have to use the statement NODES in ABAP report.

If there are many tables the Performance will be slow as all the table data will be read from top node to bottom node .

4. ABAP Query Reports

ABAP query is another tool for ABAP. It provides efficency for ABAP reports. These reports are very accurate.

Transaction Code : SQ01

The advantage with ABAP QUERY is logic required for classic & interactive reports system design automatically 80%.For ABAP QUERY handle these

SQ01 ; QUERY

SQ02 : INFOSET OR FUNCTIONAL AREA

SQ03: USER GROUP.

5.ALV Reports

Abap List Viewer, Its a tool provied by sap no need to write code for formating display

Important Function Modules

• Reuse_alv_list_display

• Reuse_alv_fieldcatalog_merge

• Reuse_alv_events_get

• Reuse_alv_commentary_write

• Reuse_alv_grid_display

All the definitions of internal tables, structures and Constants are declared in a type-pool called SLIS.

6. Report Writer

Key Concept :

Super users and end users can use Report Painter/Report Writer tools to write their own reports.

Giving them the ability to report on additional fields at their discretion shifts the report maintenance burden to them, saving SAP support groups time and effort normally spent creating and maintaining the reports.

Instead of using ABAP code to write a report in FI and CO, many users build a Report Painter/ Report Writer library using transaction MC27.

However, this workaround has some drawbacks. Little known transaction GRCT solves these problems in most cases, and eliminates the need to use transaction MC27.

7. Views

A view is like a navigational snap shot of a query after execution, or the report. Views are used as DataProviders in web temaplates and also as Jump Targets.

You can create a view after executing the query, and performing the navigation required (drill down, chnage in properties, filters, sort etc). Then you can click Save and Save it as a View after giving it a Technical Name and Description. You can open up Views from the same Open dialog box as for queries and workbooks.

[Former Member]

Hi there

This is the OO Forum so most of your post is really in the wrong Forum.

The bit that IS relevant is on ALV GRIDS -- now as OO you should not even mention the old SLIS stuff anymore --OLD, OBSOLETE AND DINOSAUR TECHNOLOGY.

Use class CL_GUI_ALV_GRID grid if you need editable grids or are on releases prior to 6 for ALV reports.

If you don't need to edit stuff then for releases > 4.6 (any version) you can use class CL_SALV_TABLE (particularly with the FACTORY method).

Any mention of the old SLIS Function modules for ALV GRIDS shouldn't appear on the OO Forum.

Cheers

jimbo