Update Planned Records (SAP Library

Update Planned Records

Use

The Update planned record function relates to the derivative financial instruments, Cap, Floor, Swap and FRA.

Usually, future interest payments are passed on to Cash management to have a correct liquidity status. Flows with a fixed interest rate are immediately passed on to Cash management when the transaction is created.

Estimated values of amounts for flows with a variable interest rate must be determined as the percentage values of reference interest rates can change daily.

You use the Update planned record function for:

Determination of all planned records that are relevant/still exist.
Determination of all reference interest rates that have an influence on the size of the amount of the individual record.
Determination of the interest rate (percentage value) per reference interest rate.
Determination of an amount per planned record using the interest condition.
Iteration of all planned records.
Resetting of the corresponding planned records in Cash management
Update of this record in Cash management using planning level control.

Prerequisites

In Customizing, you must maintain a planning level via Product types to be able to assign a planning level to the transaction activity.

When defining the flow type for interest flows, you must be careful to describe it as "Relevant to Cash management" (otherwise, these flows get a Cash management block).

Activities

Selection

Choose Derivatives ® Back office ® Update planned records.

This takes you to the screen entitled Cash Management - Update of Flows with Variable Interest Rate.

You have the following selection criteria available for the report:

Company code
Product type
Transaction number

Note the following points in the Update planned record area:

Earliest adjustment date: The selection date controls the date on which the relevant interest rates are read from the interest rate table. The planned records are passed on to Cash management with these rates. The date on the day is usually used.

Manual interest rate adjustment: Set this flag if you only require manual interest rate adjustments. Interest rate adjustments can be carried out manually per transaction or automatically for all transactions (refer to the unit entitled Interest rate adjustment for more information).

The function can also be used in the Test run. The amounts for each planned record are determined and displayed, the database is, however, not updated.

Choose Execute.

Output

The output list Update of variable planned interest in Cash management is in the following format:

Company code
Transaction number
Interest rate

By double clicking on the interest value, you get to the reference interest rate and the value.

: This sign means that the reference interest rate is used in one or several transactions but that a value was not found by the specific table search.

Number of updates

Via double-click, you access the single planned records and their amounts that are passed on to Cash management in a productive run. You can also see the planning level at which the planned record is posted in the planned record detail view (for a productive run).

Product type
Transaction type
Activity
CM update (only in productive run)

shows success of update

Error message (see above: Prerequisites)