PERFORMANCE ISSUES IN ABAP

1. How do you take care of performance issues in your ABAP programs?

Performance of ABAPs can be improved by minimizing the amount of data to be transferred.

The data set must be transferred through the network to the applications, so reducing the amount OF time and also reduces the

network traffic.

Some measures that can be taken are:

- Use views defined in the ABAP/4 DDIC (also has the advantage of better reusability).

- Use field list (SELECT clause) rather than SELECT *.

- Range tables should be avoided (IN operator)

- Avoid nested SELECTS.

i)system tools

ii)field symbols and field groups.

ans:-

Field Symbols : Field symbols are placeholders for existing fields. A Field Symbol does not physically reserve space for a

field,but points to a field which is not known until runtime of the program.

eg:- FIELD-SYMBOL [].

Field groups : A field group combines several fields under one name.At runtime,the INSERT command is used to define which

data fields are assigned to which field group.

There should always be a HEADER field group that defines how the extracted data will be sorted,the data is sorted by the fields

grouped under the HEADER field group.

Many times we have seen many threads related to performance issues on BSEG table. Here is the solution for this.Since it is not possible to create the secondary INDEX for cluster tables, SAP came up with new concept called INDEX tables.All the accounting documents (Open and closed) are stored in BKPF and BSEG tables and querying these tables takes lot of time.So SAP has created INDEX tables for BSEG which are updated with specific data based on classification and are much faster than BSEG. EG: Customer documents, Vendor documents etc. INDEX TABLES: BSID- Accounting: Secondary Index for Customers (Open Items)BSAD- Accounting: Secondary Index for Customers (Cleared Items)BSIK- Accounting: Secondary Index for Vendors (Open Items)BSAK- Accounting: Secondary Index for Vendors (Cleared Items)BSIS- Accounting: Secondary Index for G/L Accounts (Open Items)BSAS- Accounting: Secondary Index for G/L Accounts (Cleared Item) How to remember these tables???Remember BS* *

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk