Maintenance of Selection Variables in the TVARV Table

Purpose

You need to specify variants with parameters for a report. This is required because the report is provided with these parameters while it is running. However, parameters can change within a chain or at the start of different chains. An example of this is the selection date. You cannot specify a fixed date because of the daily change.

Define the parameters or the variants as selection variables whose value is taken from the TVARV table. The value of a variable is automatically read from the TVARV table if the Selection Variable attribute is set for the variable in the variant. Then choose the selection option and specify which entry is to be used from the TVARV table to fill the variable value. You need to enter the data in this table yourself.

Prerequisites

You can see if a variable is a parameter or a selection option when you save the settings as a variant. Each variable is based on a P (parameter) or an S (selection option). SAP recommends that you gain an overview of the variables to be created, and then create the variables by using the SM32 transaction, and then using these in the variant. You need to enter date variables with the YYYYMMDD format.

The following table lists the most important variables that are needed in the reports:

Job Name	Field Name in the Report	Variable Type
RFBKPDT2	Bank Area	Parameter
RFBKPDT4	Bank Area	Parameter
RFBKKC20	Bank Area	Selection option
RFBKKC20	On	Parameter
RFBKCONC	Bank Area	Selection option
RFBKCONC	Balancing Selection Date	Parameter
RFBKBSST	Bank Area	Selection option
RFBKBSST	Statement Date	Parameter
RFBKCLEB	Bank Area	Parameter
RFBKCLEB	Balancing Posting Date	Parameter
RFBKCHACCUR	Bank Area	Parameter
RFBKSOCRPAR	Bank Area	Parameter
RFBK_MASS_ACCNT_CLOSURE	Bank Area	Parameter
RFBK_CLOSURE_PRENOTIFICATION	Bank Area	Parameter
RFBKCONA	Bank Area	Parameter
RFBKCONA	Accrual/Deferral Key Date	Parameter
RFBKGLBSPREP	Bank Area	Selection option
RFBKGLBSPREP	To-Date for GL Transfer	Parameter
RFBKGL02	Bank Area	Selection option
RFBKGL02	To-Date for Balance Sheet Preparation	Parameter
RFBKGL_VA_CALC_POST	Bank Area	Selection option
RFBKGL_VA_CALC_POST	Account Number	Selection option
RFBKGL_VA_CALC_POST	Posting Date	Parameter
RFBKGL_VA_CALC_POST	Valuation Date	Parameter
RFBKTDEPOSITCOLLECTION	Bank Area	Selection option
RFBKTDEPOSITCOLLECTION	Account Number	Selection option
RFBKTTERMCONTROL	Bank Area	Selection option
RFBKTTERMCONTROL	Product	Selection option
RFBKTTERMCONTROL	Account Number	Selection option
RFBKTTTERMMATURE	Bank Area	Selection option
RFBKTTTERMMATURE	Product	Selection option
RFBKTTTERMMATURE	Account Number	Selection option
RFBKTTERMNOTICE	Bank Area	Selection option
RFBKTTERMNOTICE	Product	Selection option
RFBKTTERMNOTICE	Account Number	Selection option
RFBKTMP1_PO	Bank Area	Parameter

Process Flow

In the most simple case (where there is one bank area only), the TVARV table requires only two variables:

One parameter variable for the old payment transaction date.

One parameter variable for the new payment transaction date.

You can specify all the other values directly in the variant. You need to enter the date variables daily.

There are two options:

The work preparation must adjust the variables on every working day.

You write a report that supplies the variables. Both date variables are in the BKK01D table. PDAT_ACT contains the current payment transaction date and CDAT_ACT contains the current posting closing date. The values are exported from these variables and imported to the TVARV table.

The report must be defined in such a way that it can be entered in a chain. The report uses the same logic as that from the reports delivered by SAP. The general logic is in the Online Self Service in note no. 123217.

You then need to enter the report in the list of reports that are to be chained.