How to do the Performance optimizations for FI-CA on SAP HANA?
As of SAP Enhancement Package 7 for SAP ERP 6.0, SP 02, and SP 03, you can improve the performance of numerous Contract Accounts Receivable and Payable processes. To do this, you have to activate optimizations for the database accesses in Customizing, in particular for column-oriented main memory databases such as SAP HANA:
In the Implementation Guide (IMG) of Contract Accounts Receivable and Payable under "Technical Settings -> Activate Optimizations for Database Access", activate the optimization IDs. The following optimizations are available:
| Process | Transaction code | Optimization ID |
| Payment Lot | FP05 | 0001, 0002 |
| Cash Desk Evaluation | FPCJR | 0004 |
| Payment Run | FPY1 | 0010, 0011, 0012, 0020, V010 |
| Automatic Clearing | FPMA | 0020 |
| Dunning Proposal Run | FPVA | 0020, 0030, 0031, 0032 , 0033 |
| Dunning Activity Run | FPVB | 0035, 0036 |
| Correspondence Printing | FPCOPARA | 0040, 0041, 0042, 0043 |
| Open Item List | FPO1/FPO4 | 0050 |
| All item-relevant posting processes (for example, FPY1, VYSPA) | 0060 | |
| CO-PA Transfer | FPG3M | 0070 |
| Reconcile with General Ledger | FPG2 | 0071 |
| Check Totals Tables | FPT1 | 0072 |
| Check CO-PA Documents | FPG7, FPG7M | 0073 |
| Release to Collection Agency | FP03M | 0079, 0082 |
| Submission to Collection Agency | FP03DM | 0083 |
| Information for Collection Agencies | FPCI | 0084 |
| Mass Run: Write-Off | FP04M | 0080, 0081 |
| Interest Run | FPINT1 | 0085, 0086 |
| Mass Activity: Revenue Distribution | FP60M | 0087, 0088 |
| MassAct. Post Distribution Documents | FP60PM | 0089, 0090 |
| Requests | FKKORD1/FKKORD2/FKKORD3 | 0095 |
| Credit Clarification | FPCRPO_DET | 0100 |
| Invoicing | FKKINV_MA | 0550, 0580 |
| PS-CD Transfer of Billing Documents | P001 | |
| Account Balance | FPL9 | R001, T001 |
| IS-U Create Bill | EA26 | R480 |
| Insurance Billing Documents | VYCOV004 | V015 |
| Debit Entry | VYSPA | V020 |
| Payment Plan Transfer | Function module ISCD_SCPOS_MAINTAIN | V030 |
| FS-CD Dunning Proposal | VPVA | 0020, V040, V041 |
| FS-CD Dunning Activities | VPVB | V045 |
| Broker Report | IBR50 | V055 |
For more information, see the following release s:
- FICA_607_2_PERFOPT (for SP 02)
- FICA_607_3_PERFOPT (for SP 03)
that not every activation of an optimization ID for your settings and data in the productive system may lead to a performance improvement.
Optimization of customer-specific FI-CA event definitions
SP 03 provides the new FI-CA event 1820 for custom developments for FI-CA events within mass activities:
In the mass activity framework, the event 1820 performs preparatory selections prior to the processing of each individual interval. By default, no processing is intended at this point. However, you can define an installation-specific function module.
Example:
In the interval module of a mass activity, the system selects customer objects. The mass activity is a SAP standard implementation for the interval module. To optimize the data selection, fill the buffer for the subsequent selection in the interval module at event 1820.
Typically, the parallel processing object (I_BASICS-RUNKEY-OBJECT) is determined for this. For this object and the current interval limits (I_LOW, I_HIGH), a suitable mass read module can be called, which writes the data read in a buffer. The single accesses that subsequently occur in the interval module can then read from the buffer.
Further optimizations for your own customer developments
For general performance recommendations for customers, see http://service.sap.com/performance.
On the left side, navigate to "Performance -> Resources -> Best Practices for ABAP Performance". This displays a list of documents. In particular, the document "Performance Do’s and Don’ts ABAP", which does not contain any recommendations that are specific to SAP HANA, but recommendations that are nevertheless valid for SAP HANA.
Currently, there is an exception for SAP HANA: We recommend that you do not use joins in combination with SAP HANA because this may have a negative effect on performance.