Programme SAP /IBS/MRB_PEWB_REFRESH - RBD: CML Arrears Monitoring:Planned Record Generation(FIVA) and Pstng

Title

Updating a Flat-Rate Individual Value Adjustment (FIVA)

Purpose
You use this report to update a FIVA in terms of the documents that arecurrently overdue. Based on the selection criteria you specify thesystem only uses documents with certain attributes or documents fromloans with certain attributes.
You can also enter the length of time that they have been overdue as avariable. In practice you would select a quantity of documents that havenot been cleared for more than three months (90 days).

Integration
The report is usually run in a job schedule on a monthly basis to updatethe FIVA accounts. A separate job schedule is required for each FIVAaccount.

Prerequisites
You need to have created and saved the FIVA account for which you wantto run the update. You must also have entered a description for the FIVAportfolio (interest or charges FIVA).

Features

Selection
The report for monitoring arrears has the following selection criteriathat can originate in CML and in the RBD component:
Criterion (Optional / Required Entry Field) Origin
Meaning
RBD Context
Parameter (Required) RBD Area (RBD)
These parameters specify the risk portfolio to which the documents to beselected from CML are assigned.
Parameter (Req.) Account number (RBD)
Here you enter the RBD account for which a FIVA is being updated orgenerated.
Loan Contract
Selection Option (Optional) Company Code (CML)
You can limit the company codes from the source system.
Selection Option (Optional) Contract Currency (CML)
Only certain contract currencies can be considered.
Selection Option (Optional) Status (CML)
Only certain statuses can be considered.
Selection option (Required) Product Type (CML)
Product types to which the CML loans are assigned.
Selection option (Optional) Dunning level of document (CML)
Selection criteria at document level so that only documents with certaindunning levels are included.
Selection option (Optional) Dunning level of contract (CML)
Selection criteria at contract level (dunning symbol) so that onlycontracts with certain dunning levels are included.
Selection Option (Optional) Contract Number (CML)
Restriction for source system in selection.
Selection Option (Optional) Finance project number (CML)
Restriction for source system in selection.
Selection Option (Optional) Business Partner (CML)
Restriction for source system in selection by main borrower partnernumber.
Control
Parameter (Required) Document Date Source System (CML)
Restriction for source system in selection by document date.
Parameter (Required) Posting Date (Posting System and RBD)
Parameter (Optional) Special Period (posting system and RBD)
You can specify a special period for posting here.
Parameter (Optional) Fiscal Year (posting system and RBD)
Here you can specify in which fiscal year the postings are to be made.If you do not make an entry here the system determines the fiscal yearon the basis of the posting date.
Parameter (Optional) Posting Text
You can enter a generally valid posting text here. If you do not make anentry here the system generates a text based on the RBD flow type, theRBD area and the RBD account number.
Parameter (Required) Valuation Area (RBD)
The valuation method in the RBD component indicates the procedure to beused to prepare the balance sheets for the value adjustments. This doesnot refer to a procedure in the context of valuation methods accordingto § 240 paragraph 4 § 256 line 1of the German Commercial Code but to ageneral differentiation for example:
Valuation methods based on the GCC
Valuation methods based on IAS
Valuation methods based on US-GAAP.
Radio Button (Req.) Simulation or update run
Here you can choose whether the processing is simulated first or you runan update run straight away.
Radio button (Req.) Generate or post planned records
Here you can choose whether you only generate the planned records orwhether they should be posted immediately.
Radio Button (Req.) Synchronous or Asynchronous Posting
You can choose whether the posting (update run and planned record orposting) is started immediately or run asynchronously as a backgroundjob.
Radio Button (Req.) Display Individual Documents
Depending on the volume of data expected; you can limit the display ofindividual documents for large volumes. The individual documents clarifythe link from planned or actual records to the CML loans.
Output fields for posting (actual) records
RBD document number
Flow type
Text for flow type
D/C indicator
Transaction currency
Amount in transaction currency
Fiscal year
Posting date
Document number in the posting system
Flow type group
RBD class
Automatic posting
Output fields for planned records
Sequence number of planned record
Flow type of planned record
Name of flow type
D/C indicator
Transaction currency
Amount in transaction currency
Fiscal year
Posting date
Sequence number of posting record (actual record)
Flow type group (capital, interest or charges)
RBD class
Indicator for automatic posting
Output fields for individual documents (optional)
Sequence number of individual documents
Valuation method
Component ID of source system
Contract number in source system
Document number in source system
Document item in document number in source system
Reversal indicator
Active indicator line item
Indicator reclassification
D/C indicator
RBD class
Currency of individual document
Amount of individual document

Activities
Selection
In the first step the system selects all contracts from CML that meetthe product criteria entered (product type, company code, contractnumber, finance project number, main borrower partner number, risk class
, contract status, loan type, currency).
The system only considers the product types that have been defined asrelevant for the RBD component in the Customizing settings.
The system then takes all of the items from CML that correspond to theflow data criteria to the Portfolio selected:
,,CML flow type corresponds to the restriction according to theselection option
,,Only documents with named dunning levels
,,Only documents that are open or partially cleared in the posting date(according to the parameters) and in which
,,The posting date and the payment date are before or the same as theposting date in accordance with the parameters.
The program must also check each document to see whether is has alreadybeen value adjusted in another RBD account.
Subsequent processing
The system forms totals at CML flow type level, CML company code level,CML account assignment reference level and at currency level (in thishierarchical structure). From these totals the system generates valueadjustment proposals in the form of planned records. The followinginformation is taken from Customizing:
,,Which business operation is being dealt with (for exampleappropriation monitoring of arrears) and the business operation text.
,,Which RBD flow types are to be used for the business operationappropriation monitoring of arrears. (Only the flow types appropriationFIVA interest, appropriation FIVA charges are relevant for this report.)Flow types from the source system without the equivalent in Customizingare ignored.
,,Which CML flow types correspond to which RBD flow types
,,Which debit / credit indicator belongs to each RBD flow type
,,Which RBD class is required, based on the CML company code, CMLaccount assignment reference and currency
,,
The posting date entered in the parameters is used as the posting datefor the business operation. The individual planned records are assignedto the business operation with RBD item numbers.
Planned Records Transfer
The planned records generated are added to the RBD account selected. Ifno postings are made and you have not selected the simulation run, theplanned records table for the specified RBD account must be extended.
Individual Document Transfer
The CML documents waiting for value adjustment must be entered in theindividual documents table displayed with an activation indicator andthe RBD account data, RBD area, RBD documents number and RBD accountnumber.
Posting
Depending on the parameters entered and the indicator for automaticposting set in the RBD account or for the RBD flow type, the systemforwards the planned records generated by the report for posting. Thismeans that the program must first determine the debit and creditaccounts for posting in FI using account determination. The actual re
cords table for the specified RBD account must then be extended and therecords transferred to the posting interface. The system also assignsdocument numbers for the RBD documents. The FI document numbers reportedback from FI on the basis of the postings are assigned to the RBDdocuments.