Ansicht
Dokumentation

OHIX1673 - Set Flow Control for the Logical PNP Database

In this step you determine the type of data selection used to transfer data from the logical database PNP to SAP reports and your customer-specific reports.

You can make different settings for the two possible report flow types (Online processing, background processing).

The access options available to you for each report, both with online processing and background processing, are as follows:

• '0': SQL safety setting

This setting does not lead to improved performance.

The reports for which you make no entries in this step are automatically given the SQL safety setting.

• '1': Forwarding of Select Options

The selection fields of the logical database PNP are passed on directly to the database.

The exception to this are concatenated selection fields.

• '2': Array-Fetch active

Array-Fetch makes access to sets of data from the database possible. This reduces the number of times you have to physically access the database and leads to a marked increase in the rate of processing.

• '3': Array-Fetch active and Forwarding of Select Options

The greatest performance gain is achieved by combining access options '1' and '2'.

Note

• The initial value (space) is an invalid setting and therefore should not be used. This value is interpreted as if no settings had been made.

• If no settings have been made for a report, data selection is performed according to setting '3' and consequently achieves the best performance gain.

If you use access option '1', '2' or '3', you should note the following:

• If you assign access option '1' or '3' to a report, check to see if your system requirements (Database, database profiles) are suited to this.
  
  

• If you assign access option '2' or '3' to a report, this report requires more main memory, thus allowing the use of larger internal tables.

The SAP Standard System contains several reports with assigned access option.

1. Check the SAP default entries and, if necessary, adapt them to your requirements.
2. Delete entries that are not required.
3. Add SAP reports as well as customer-specific reports.
1. Choose New Entries.
2. In the field Program, enter the name of the report for which you want to determine the access option.
3. In the field Batch, indicate the access you want for background processing.
4. In the field Online, indicate the access you want for online processing.





PERFORM Short Reference   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 3588 Date: 20240607 Time: 161311     sap01-206 ( 40 ms )