Re: Report tree query

Former Member — Mon, 23 Jul 2007 14:42:56 GMT

Report Tree:

An ABAP reporting tree program that allows the user to press enter or double click on any line. The report is updated with new internal table data and re-written. The cursor and paging returns to the exact same line the user was on, even though the report was re-written from the internal table. Input fields are filled with data based on ENTER of DOUBLE CLICK. [+] and [-] is displayed on each line and changes if user selects to expand/collapse.

Here, you specify the name of the tree to be used for report selection in the application menu. SAP supplies one default tree per application, but customers can create their own trees and overwrite the SAP tree.

Under Extras -> Control, you can define whether the reports in the tree are to be displayed in a selection window or on a separate screen. To suppress the processing of report trees for the relevant application by choosing Inactive . When you call report selection in the application menu, the list selected in the report list is then displayed.

It is also possible to deactivate the report tree for any end-user in any application by setting the user parameter 'KBT' to 'X'.

Transporting the Tree Sructure

When you change a tree, it is included in a transport request (transport object R3TR SRTR). The following are then transported:

• The tree structure all the texts

• Node entries (the names of the reports and variants)

The following are not automatically transported:

• User-specific settings (initial position, sub.trees, visible entries)

• Saved lists

When you change a node, it is also included in a transport request. The following are then transported:

• Node entries (the names of the reports and variants)

Manual Transport (for Special Cases)

The tree structure is stored in the table SERPTREE. A tree structure can only be transported as a whole, and the transport request should contain the following entry:

• R3TR TABU SERPTREE and SERPT. Function R transports all trees from the source system and overwrites those in the target system.

• R3TR TABU SERPTREE und SERPT. Function K transports only those trees specified on the next screen. You must enter function R. You can only specify the tree ID; the node ID must be specified generically.

If you want to overwrite a tree structure in the target system, the node contents (table SREPOVARI, see below) and the user-specific views (table SERPENTR and SREPOUSER, see below) should also be transported, or at least deleted in the target system.

Transporting Node Contents

The contents of report tree nodes (reports and variants) are stored in the table SREPOVARI. In this case, you should make the following entry in the transport request:

• R3TR TABU SREPOVARI. Function R transports the contents of all nodes of all trees from the source system and overwrites those in the target system.

• R3TR TABU SREPOVARI. Function K transports only the node contents specified in the next screen. You enter function R here.

If you want to overwrite a node in the target system, the user-specific views (table SREPOUSER, see below) should also be transported, or at least deleted in the target system.

Transporting User-Specific Views

The views of the report tree are stored in the table SERPENTR. You must make the following entry in the transport request:

• R3TR TABU SERPENTR. Function R transports the views of all users of all trees from the source system and overwrites those in the target system.

• R3TR TABU SERPENTR. Function K transports only those views specified on the next screen. You enter function R here.

The views of the nodes are stored in the table SREPOUSER. You must make the following entry in the transport request:

• R3TR TABU SREPOUSER. Function R transports the view of all users of all nodes from the source system and overwrites those in the target system.

• R3TR TABU SREPOUSER. Function K transports only those views specified on the next screen. You enter function R here.

Delete country-specific reports from report tree

Example

Deleting country-specific personnel reports from the report tree, for example, deleting the reports for USA.

Further notes

Selection criteria on the selection screen:

• Reports to be deleted: Specify the report name (optional)

• Report tree: for example, SAP1 for the tree displayed when you choose Information systems -> Gen.report selection.

• Delete also in user trees: Default = checkbox selected.

• Change database: Test mode = Checkbox not selected, i.e. no database updates.

When you execute the report, you get a list of all countries for which country-specific reports can be deleted. You then select the countries for which you want to delete reports.

• To delete single reports, choose Country-spec. report. To delete all country-specific reports for the countries selected, choose Delete tree area.

• When you choose Delete tree area, you are prompted to confirm the deletion. The selected reports are then deleted and the system displays a log of the deleted reports (also in test mode).

Working with Reports in the Report Tree

Prerequisites

Once you have accessed General Report Selection, you can expand the report tree structure to find the reports you want to start and perform other related functions:

You can:

• Start reports

• Start reports in the background

• Find reports

• Display report attributes

• Display report variants

• Display report documentation

• Access and start reports that do not appear in the report tree

Procedure

Starting Reports

...

1. Expand the report tree structure until you reach the required report

2. Position the cursor on the report and choose Execute (or double-click on the report)

If the report has no selection screen, the resulting list is displayed immediately.

If the report has a selection screen, go to step 3.

3. Enter your selection criteria and choose Execute

For an example of how to start a report in General Report Selection, see:

Starting a Report in the Report Tree: Example

Starting Reports in the Background

Only reports, for which variants exist, can be started in the background. You must also schedule a background job.

To start a report in the background:

...

1. Expand the report tree structure until you reach the required report

2. Position the cursor on the report and choose Execute in background

For more information about working with variants and scheduling background jobs, see:

Variants

Background Processing

Searching For Reports

To find a particular report in the report tree structure:

...

1. Choose Edit  Find  Objects

2. Enter your search criteria

You can enter basic search criteria and, for ABAP reports only, additional search criteria.

Basic Search Criteria

Search criterion Remarks

Report name This is the technical name of the report (for ABAP report, Report Writer reports, and transactions), or the user group for queries.

Extended report name This is the technical name of the report (for drilldown reports or report portfolio reports), or the query name for queries.

Title This is the report title. Here, the system searches for a title that matches the user's entry exactly.

Node This is the technical name of a node in the report tree.

You can specify additional selection criteria for ABAP reports as specified in the program attributes:

Additional Search Criteria

Search criterion

Application

Logical database

Created by

Last changed by

To determine the area in which you want to search for a report, check the appropriate boxes as follows:

Restrict Search Area

Restrict to… Action

Whole report tree Enter the technical name of the root node and select Find in subordinate nodes.

Sub-tree Enter the technical name of the sub-tree node and select Find in subordinate nodes.

Node Enter the technical name of the node and select Find in subordinate nodes.

You can search for a report using one or more character strings that appear in the report documentation, but this is very time-intensive.

You can also perform generic searches using *.

3. Choose Execute

The list of results is sorted by node.

Displaying Report Attributes

To display the attributes of a report in the report tree structure:

...

1. Position the cursor on the relevant report

2. Choose Edit  Node attributes

You see the following information (if present):

 Report type

 Technical name of the underlying executable program

 Extended report name

 Report variant

Checkboxes also indicate whether:

 The report is started using a variant

 The selection screen of the report is skipped

Displaying Report Variants

If a report has variants, these are listed as subordinate nodes. You can start variants just like any other reports.

To display the variants of a report in a different way:

...

1. Position the cursor on the relevant report

2. Choose Goto  Variants

3. Ensure that the Variants field is left blank and get a list of possible entries

4. Choose Display

You see a list of variants defined for the report.

If you want to start a report in the background, you must create a variant first.

For more information about working with variants, see:

Variants

Displaying Report Documentation

To display detailed documentation about a report:

...

1. Position the cursor on the relevant report

2. Choose Goto  Documentation

Starting Reports not in the Report Tree

If the report you want to start is not in the report tree, and you cannot access it through other menus, you can start it by running the underlying executable program. To do this, you need to know the program name:

...

1. Choose Goto  General reporting

2. Enter the program name

3. Choose Execute

For further information about working with reports, see:

Reports

Starting a Report in the Report Tree: Example

To get a list of the remaining leave entitlement of various employees:

1. On the General Report Selection screen, expand the tree structure by choosing Human Resources  Time management  Absence

2. Place the cursor on the Leave Overview report and choose Execute (or double-click the report)

3. Enter your selection criteria and execute the report

The system displays the results on the screen.

Report Variants

Definition

Group of selection criteria that has been saved. A report can have several different variants, with each variant retrieving different types of information. For example, a vendor report might have one variant for U.S. vendors and another variant for European vendors.

Use

Instead of entering the same values in the selection criteria input fields each time you execute a report, you can enter the values once and then save the selection criteria as a variant. The next time you execute the report, you only need to enter the variant name, not the selection criteria. If you use variants, the selection criteria screen is already filled with data.

To execute certain reports, you must use a variant. In this case, a system message prompts you to do so. Although you are not always required to use variants or selection criteria, it is a good idea to use them when possible. Your resulting lists will be smaller and take less time for the system to process.

Background Processing

Use

In background processing, the SAP System automatically runs any report or program that you can start interactively.

When you schedule a job in the background processing system, you must specify:

• The ABAP report or external program that should be started

• The start time

• The printing specifications

The background processing system starts your job and runs the program(s) that you specify. Afterwards, you can check whether your job was executed successfully and display a log of any system messages.

Suppose you need to run a report of customers whose bills are overdue.You can:

o Start the report yourself from the ABAP Editor. If you do this, the system runs the report interactively, in a session at your PC or workstation. While the report is being processed, your computer response time may be slower.

o Or, you can have the background processing system run the report. To do this, you must create a background job that tells the system what you want it to do.

The background processing system runs your "late bills" report according to your instructions. The list generated by the report is either printed directly or is waiting for you in the SAP output controller (see Using the Output Controller).You can also check in the background processing system whether the report ran correctly.

Features

• Running a report in the background does not tie up the SAP sessions you are currently working with.

When you start a report interactively, your current SAP session is blocked for further input for as long as the report runs.

When you start the report in the background, running the report does not influence your interactive work with the SAP System.

• You can shift the execution of reports to the evening or other periods of low load on the SAP System.

You can schedule a report or external program to run at any time that the SAP System is active. You can also set up reports to run automatically on a regular basis (for example, on the last day of each month).

• Background processing is the only way you can execute long-running jobs.

To prevent tying up system resources with interactive sessions for long reports, the SAP System has a built-in time limit on interactive sessions. If a single ABAP report runs for more than 5 minutes continuously in an interactive session, the SAP System terminates the report automatically.

The background processing system executes long-running ABAP reports more efficiently. Often, such reports are automatically scheduled for execution in the background. In this case, you do not need to schedule them for background processing yourself.

Reports

Use

When you are working in the SAP System, you may want to access information from the database. To do this, you use reports.

In this documentation, report refers to the report program, and list refers to the output – that is, the results of the report.

Some reports display information; others allow you to perform analyses.

A report must be started, or executed. In many cases, the SAP System automatically executes a report. Sometimes, however, you will want to execute a report yourself.

In addition to report programs, the SAP System provides numerous reporting tools, each of which has its own set of procedures for executing report programs.

This documentation describes report programs only. For an introduction to the SAP reporting tools, refer to the Reporting Made Easy guidebooks (Release 4.0B). You can find these guidebooks at: www.saplabs.com/rme .

<b>Kindly reward this if found useful</b>

topic Re: Report tree query in Application Development and Automation Discussions

Report tree query

Re: Report tree query

Re: Report tree query

Re: Report tree query