reports

[Former Member]

Hi,

How many types of reports are there in ABAP and what is the difference between them?

[Former Member]

hi

REKH0004 SAP demo program that shows how to do 2D, 3D, and 4D graphics.

RGUGBR00 Substitution/Validation utility

RHGEN00 Regen PD and PA inconsistencies

RHGRENZ0 Delimit IT1000 and related 1001s. Program will delete any 1001 infotypes whose start date is after the delimit date.

RHGRENZ1 Extend the end date on delimited records. Very useful when you delimit a bunch of records incorrectly, and need to change the end date.

RHGRENZ2 Delimit IT1001 only.

RKCTSEAR Search source code for up to two strings. Also see RSRSCAN1 and RPR_ABAP_SOURCE_SCAN.

RPDTRA00 List all HR transactions.

RPR_ABAP_SOURCE_SCAN Search ABAP code for a string. Has many more options for selecting the ABAPs to search than RSRSCAN1 or RKCTSEAR.

RPUAUD00 HR Report to list all logged changes for an employee. Uses the PCL4 Audit Cluster.

RPUAUDDL HR Report to delete audit data from the PCL4 Audit Cluster.

RPUDELPN Delete all info for an employee number, including cluster data and infotypes

RPUP1D00/10 View/Delete data from PCL1 Cluster

RPUP2D00/10 View/Delete data from PCL2 Cluster

RPUP3D00/10 View/Delete data from PCL3 Cluster

RPUP4D00/10 View/Delete data from PCL4 Cluster

RSABAPIV Mass print/display of ABAP/4 help text

RSAVGL00 Table adjustment across clients

RSBDCBTC Submit a BDC job with an internal batch number and wait for the end of the batch input session.

RSBDCDRU Prints the contents of a Batch Input session. No options for error transactions only.

RSBDCOS0 Execute UNIX commands. Looks similar to the old SAPMSOS0 program that disappeared in 3.0

RSBDCSUB Release batch input sessions automatically

RSBTCDEL Clean the old background job records

RSSDOCTB R/3 Table Manual - prints a list of all fields in the selected tables with the field name and the field documentation.

RSCLTCOP Copy tables across clients

RSDBCREO Clean batch input session log

RSINCL00 Extended program list

RSNASTED Process message control output for entries in the NAST table

RSORAREL Get the Oracle Release

RSPARAM Display all instance parameters

RSPO0041 Removing old spooling objects

RSRSCAN1 Search source code for a given string. Will also search includes. Also see RKCTSEAR and RPR_ABAP_SOURCE_SCAN.

RSSNAPDL Clean the old ABAP error dumps

RSTBSERV Compare a contents of a table between clients

RSTXFCON Converts SAPScript page formats

RSTXSCRP Save a SAPScript layout set to disk, and load it back into SAP.

RSTXSCRP Transport SAPscript files across systems

RSTXSCRP Upload and download SAPScript layout sets

RSTXTPDF4 Pass the spool number of a report's output to this program to have the output converted to PDF format.

RSTXTRAN Add standard texts to a transport so they can be moved between systems.

RSUSR003 Check the passwords of users SAP* and DDIC in all clients

RSUSR006 List users last login

RSWBO052 Change development class of a sapscript (provided by Alan Cecchini)

RSWBO060 put objects into a request and transport it to any other system

also chk the links below...

http://www.erpgenie.com/abap/ireports.htm

http://wiki.ittoolbox.com/index.php/How_many_types_of_reports_are_there_in_ABAP_and_what_is_the_diff...

http://sap.ittoolbox.com/topics/t.asp?t=322&p=322&h1=322

http://sap.ittoolbox.com/topics/t.asp?t=322&p=322&h1=322

Reward if USeful

Thanx & regards.

Naren..

[Former Member]

HI

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

· Classical

· Interactive

· Logical Database

· 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. 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.

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:

1. AT LINE-SELECTION

2. AT USER-COMMAND

3. AT PF

4. TOP-OF-PAGE DURING LINE-SELECTION.

HIDE statement holds the data to be displayed in the secondary list.

sy-lisel : contains data of the selected line.

sy-lsind : contains the level of report (from 0 to 21)

Interactive Report Events:

· 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.

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 .

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.

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.

ABAP Report Types

ABAP report types are those ones available in some report's attributes screen, i.e. :

· Executable program

· Function group (containing function modules)

· Include

· Interface pool

· Class pool

· Module pool

· Subroutine pool

Also ALV means ABAP List Viewer. Most convenient way to use it is through reuse library (cf. transaction se83) available from release 4.6 of SAP R/3.

ALV is available in two modes: list and grid. List mode is good old list processing with standard functionnalities, and grid mode is using a new OCX object displaying grids.

http://www.erpgenie.com/abap/reports.htm

http://searchsap.techtarget.com/ateQuestionNResponse/0,289625,sid21_cid476785_tax285320,00.html

[Former Member]

Dear Dilip,

Visit the following link:

http://www.sap-img.com/abap/difference-between-drilldown-report-and-interactive-report.htm

1. Classical Reports

2. Interactive Reports - Drilldown reports where you can drill to find more information.

Layout wise:

1. Normal Reports

2. ALV Reports (Grid, List, Hierarchy) - Has better look and feel. Also, has a toolbar where you can perform various actions such as sum, sort etc.

Regards,

Naveen.