Show TOC

 Summarization

Use

During the term of a loan contract, the system usually generates a large number of individual flows (loan document items). The system must have efficient access to these posted flows for calculating capital amounts and the cash flow, even if there are a large number of loan contracts involved.

The summarization function summarizes regular condition-based document items. For each flow type, it generates summarized records from the start of the term up to the summarization date. Application functions now only need to access a few summarized records and no longer have to process numerous individual flows.

This improves system performance, particularly when you have a large number of loan contracts for which a large number of condition flows are posted at short intervals. Otherwise, evaluating all the document items is very time-consuming.

Integration

The following application functions can process summarized records:

  • Updating Planned Records

  • Accrual/Deferral of Expenditure and Revenue

  • Loans for the Partner

Prerequisites

You can only use the summarization function if flows have been posted. In other words, regular condition-based loan document items must exist.

Features

  1. The following criteria are available for selecting the contracts for which you want the loan document items to be summarized:

  • Company code

  • Contract number

You can restrict the search further under General Selections :

  • Product category

  • Product type

  • Contract currency

Under Further Selections you can also limit the search according to the summarization status of a loan.

  • Loans with valid summarization

  • Loans with deleted summarization

  • Loans with invalid summarization

  1. In the Execution Parameters section you specify the summarization key date. The summarization key date should be at least three payment installment periods before the current date. This is to ensure that the summarization does not overlap with the current repayment settlement periods. All flows posted between the summarization key date and the current date (delta information) are considered on an individual basis again.

Therfore, the application function accesses the summarized records generated on the summarization key date and the individual records since the summarization. This ensures that all the relevant document items for the current key date are included in the evaluation.

Recommendation Recommendation

To ensure that the system performance when you evaluate loan document items is optimized in the long term, you should run the summarization at regular intervals. Due to the runtime for the summarization and lock problems, you should schedule the summarization as a background job for a time when the system is not being used online.

End of the recommendation.

  1. Under Call type you have the following options:

  • Carry out summarization

The system summarizes the selected loan data as at the key date you entered.

  • Invalidate summarized records

The summarized records for the selected loans are flagged as invalid. The summarization records remain on the database. The application function now reads the individual loan document items, which are no longer cumulated. You can summarize this data again.

Note Note

If you have already summarized the flows for a certain period, and then make an unexpected posting (such as a reversal) within the summarization period, the summarized records that have been created are no longer up-to-date. In this case, the application invalidates the summarized records automatically.

End of the note.

  • Delete summarized records

The summarized records for the selected loans are not just set to invalid, but actually deleted. As for invalidated records, the application function now reads the individual loan document items, which are no longer cumulated. You can summarize this data again. Deleting the summarized records takes longer than invalidating them.

  • Display information

The system displays the summarization status of the selected loans. You see how many loans have valid summarization records, invalidated summarization records or have not been summarized, as well as how many summarization records have been deleted. You can use this function to check your loans.

  1. Under Output control you can use the F4 function to specify the type of list display (for example, as a short text or a detailed list).

  1. You can further improve the performance during the summarization by making entries in the section headed Details for Parallel Processing for Call Type Summarization . You can use parallel processing to carry out the summarization for a server group on different instances using remote function call (RFC).

Activities

  1. Choose Start of the navigation path Position Management Next navigation step Periodic Processing Next navigation step Reorganization Next navigation step Summarization End of the navigation path . The Loans: Summarization of Document Data screen appears.

    1. Enter the selection criteria for the loan document items to be summarized and the summarization key date.

    2. Choose the Call Type , and choose the list format under Output Control.

    3. If you want to use parallel processing to improve performance during the summarization, select the Parallel processing required indicator and enter the necessary details.

  3. If you want to save your selection details, choose Save as variant… . If you have already saved one or several variants, you can call them up by choosing Get variant . You can then make any necessary changes before executing the summarization.

  4. Once you have made your entries or activated the required variant, choose Execute.

Note Note

You need to delete all of the summarization records for loans in the relevant company codes immediately before or immediately after a local currency conversion, so that the functions Update Planned Records , Accrual/Deferral of expenditure and revenue and Loans for the Partner can operate correctly.

End of the note.