Iconet Services Ltd - SAP ABAP / SAPScript Consultant

Home Page
Company Profile
Search Internet for SAP Information
Subscribe to SAP R3 Mailing list
Sample ABAP Programs
ABAP How to
General Purpose layout set

Performace enhancement for PCH logical database

Logical database PCH is large and can take a while to run. To improve performance it is possible to restrict the hit on the database by filtering on any field, for example when retrieving records from infotype P1007 (vacancy) for current vacancies you can include the following code before the get statement:-

CONSTANTS: $1007 LIKE P1007-INFTY VALUE '1007'.

START-OF-SELECTION.

*----------------------------------------------------------------------*

RH-SET-INDEX-INFTY $1007.

RH-CONDITION-LINE VACAN EQ 'X' SPACE.

RH-SET-INDEX-INFTY-CONDITION.

GET objec.

*----------------------------------------------------------------------

This will retrieve only those records from the logical database where the field p1007-vacan = 'X', otherwise you would need to retrieve all records first and then filter on p1007-vacan (where vacan = 'X')

Cant explain this code as cant find any documentation on it but it is used in SAP standard.

Back to How To list